What users are saying about

1010data

5 Ratings

MySQL

Top Rated
623 Ratings

1010data

5 Ratings
Score 4.2 out of 101

MySQL

Top Rated
623 Ratings
Score 8 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

MySQL

MySQL is fantastic for those who just want to dip their toes in the water, as well as those Olympic style swimmers who are much more advanced. It is extremely flexible and there is a ton of support out there due to its increased popularity as a BI tool. I would definitely recommend using another BI tool that could integrate several MySQL databases together to avoid any lag times with reporting.
Joseph R. Sweeney profile photo

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • MySQL is very easy to setup and use. You can create a new MySQL instance in a matter of minutes.
  • MySQL comes with a great set of tools out of the box that make database administration as easy as possible. Everything from creating or restoring backups to setting up remote server replication is doable with the built in tools.
  • MySQL is highly configurable and can be easily tuned to suit the individual needs of the user.
No photo available

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • MySQL simply doesn't scale as well as commercial databases. It seems to reach a performance plateau where you are then required to shard the data into different instances to get the performance you need.
  • The stored procedure and programming language is too limited compared to TSQL or PL/SQL.
  • Configuring the different storage engines is cumbersome to enable features like spatial queries. It would be helpful if all features could run out of the InnoDB storage engine.
  • It lacks some of the higher end features of commercial databases such as flashback recovery, updateable views, etc.
Christopher Weiss profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
MySQL8.1
Based on 3 answers
Performance is pretty good for medium to large set of data. We haven't tried using it for super large set of data.
No photo available

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
MySQL7.7
Based on 4 answers
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Kenneth Hess profile photo

Support

No score
No answers yet
No answers on this topic
MySQL8.4
Based on 2 answers
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Kenneth Hess profile photo

Implementation

No score
No answers yet
No answers on this topic
MySQL7.3
Based on 1 answer
1. Estimate your data size.2. Test, test, and test.
No photo available

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of things and here I mean it does seem quicker using Oracle to import/export very large databases/indexes and partitions however we decide to live with the difference. All in all set up and ongoing costs was a significant factor in our decision to use MySQL.Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.
No photo available

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • Moving to MySQL 5.6 has allowed us to see a near 35% increase in database throughput and I/O operations
  • By clustering our MySQL instance, we're able to increase the performance of the entire system substantially--it should scale to (potentially) a petabyte level as our business grows
  • The lack of great support for UDFs and window functions has meant our development time has increased slightly when needing to extract data from MySQL
Ivan Miller profile photo

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MySQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details