MySQL Reviews

1) It is freely available under the terms of GNU General Public License.2) MySQL works seamless on various platforms and environments.3) It is mainly used in Client/Server environment and it can be embedded in standalone applications. 4) Support SQL standards, and also provide Multi-thread environment.5) Offers high performance due to its unique storage engine architecture as well as it's core written in powerful languages such as C and C++.

1) Does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.2) MySQL uses temporary tables to execute queries, so it consumes more space.3) MySQL is missing some RDBMS features like stored procedures, foreign keys, transaction, rollback, and subselect. And it also does't support triggers.It is widely used in web applications, and several software stacks includes MySQL as a Data Base Management System like (WAMP, XAMPP) considering its flexibility and simplicity.

And if some one is looking for Database which performs simple processes like storing and displaying data only, then MySQL is the right choice.

It has a relational database system. Client/Server Architecture SQL compatibility (Structured Query Language) .MySQL has the features of the current SQL standard (at the moment SQL: 2003). SubSELECTs: From version 4.1, MySQL is capable of processing a query in the form of SELECT * FROM tablename1 WHERE x IN (SELECT y FROM tablename2). MySQL supports views from MYSQL version 5.0. Stored procedures: Is capable of storing codes: MySQL has supported SPs since version 5.0. Triggers: MySQL has supported triggers in a limited form from version 5.0 Unicode: MySQL has supported all conceivable character sets since version 4.1, including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2). User interface: There are a number of convenient user interfaces for administering a MySQL server. Full-text search: Full-text search simplifies and accelerates the search for words that are located within a text field. If you employ MySQL for storing text (such as in an Internet discussion group), you can use full-text search to simply implement an efficient search function. Has got statement-based replication. It's one of the simplest ways to create databases.

DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are non deterministic. Statements using any of the following functions cannot be replicated properly using statement-based replication: LOADFILE (), USER ().

MySQL is open source, highly extensible and scalable, and is available from a web interface via PHPMyAdmin, which is excellent because it's platform independent.In almost all instances that I have used MySQL, it has handled whatever I threw at it and hasn't failed me yet.

It is a community driven project, which means that support is sometimes scarce and hard to find. Also, it really doesn't have an IDE per-se, like MSSQL does.

I use MySQL on a regular basis, specifically whenever I am managing or installing a Wordpress instance. Combined with PHPMyAdmin, MySQL is an excellent database solution for small to medium sized businesses or installations. I would recommend using a better supported database like Oracle or MSSQL for mission critical tasks on an enterprise level, but MySQL is completely capable of performing the same tasks as those other databases.

• Free to download and use • Loads of new features over 4.1 version. • Excellent support for a range of platforms. • Performs well in small and medium applications. • Most popular Open Source database engine. • Supports advanced concepts such as replication. • Performs extremely well in the average case.

• It doesn't support stored procedures. • You probably wouldn't use it for heavy-duty installation. • There is no active directory for integration with Microsoft SQL Server or other data bases.

As a developer I have used many database engines but MySQL is by far the best known and most popular Open Source database engine.

The best features in MySQL, making it one of the most used databases globally, are- 1) Multi-threaded architecture for multiple CPU utilization and kernel threading 2) Use of triggers and crash recovery techniques 3) Indexed Conditional Pushdown 4) Integration with LAMP/WAMP 5) Easy setup with Memcached for increasing performance and scalability

Few cons in MySQL are 1) Increased complexity in InnoDB 2) Slower performance when using InnoDB as compared to MyISAM for using simple queries 3) Only identical MyISAM tables can be merged. 4) No active directory integration as in SQL server 5) It does not support check constraints

MySQL is indeed the world's most popular open source database. It has been designed on the hyper threading infrastructure and supports multi-threaded architecture for using multiple CPU's. It works on index compression with B-Tree disk tables popularly known as MyISAM. Its efficiency depends on the implementation of SQL functions with optimization of library classes.

I use the product as a backend to my application.

The product is flexible and easy to use.

The interface could be improved.

I have been using the solution for seven to ten years. I am using the latest version of the solution.

I rate the tool’s stability a nine out of ten. The stability is good.

I rate the tool’s scalability a seven out of ten. We have four direct users and more than 1000 indirect users. We use the tool twice a week.

I rate the ease of setup an eight out of ten. The deployment took a few minutes. We need two system administrators to maintain the tool.

The deployment was done in-house. We need one system administrator to deploy the tool.

I rate the pricing a seven or six out of ten on a scale of one to ten, where one is cheap and ten is expensive.

We used different solutions before, but I do not know why we switched to MySQL. I recommend the solution to others. Overall, I rate the product an eight out of ten.

On-premises

We use MySQL primarily for internal application systems that we developed.

We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good.

I have been using MySQL for approximately six years.

The stability is fantastic, it has been 100%.

We did not plan to increase the usage of this solution at this time.

We have not needed to contact technical support.

The implementation was simple and took approximately one day.

I did the implementation of the solution myself and I used community support. The support from the vendor costs money.

We are using the free community version of the solution.

I rate MySQL a nine out of ten.

Hybrid Cloud

We use MySQL to organize data, analyze information, and make decisions for the company. We also use it to process information from different areas in the company.

What I really like about MySQL is the opportunity to search for information and organize it any way I like. If you know the queries and you add the code, you can organize information any way you like.

MySQL needs to be more accessible and user-friendly. The person working with it needs to be trained in MySQL to have the necessary skills to control the database and analyze data. It should provide better customer experiences.

I have been using MySQL for one year.

The initial setup depends on your knowledge. If you know the principles, except when it comes to queries, it's easy. But if you don't know anything about MySQL or SQL, you can't do it. It took us about six months to set up and deploy MySQL.

I would tell potential users that people in production have to be trained to use MySQL. They should take some courses, and get certificated. This will show them how to use the principal tools and provide some context about how MySQL works. 

On a scale from one to ten, I would give MySQL an eight.

Private Cloud