Solved

Is MySQL 5.1 stable?

Posted on 2007-04-03
3
602 Views
Last Modified: 2012-06-21
Hello,

Is mysql 5.1 stable enough for a large application. I need to use it's partitioning funcionality.

Thank you!
0
Comment
Question by:ditkis
  • 2
3 Comments
 
LVL 30

Expert Comment

by:todd_farmer
ID: 18847211
Well, it's still in beta.  Obviously, MySQL would like it to be GA, so there are outstanding bugs that are preventing it from getting there.  MERGE tables are an alternative in 4.1 or 5.0, although those also have a number of issues that can cause problems if you aren't careful.
0
 

Author Comment

by:ditkis
ID: 18847893
As I understand, MERGE wokrs only with MyISAM, we need some solution for InnoDB. Do you know of anything that can help us split very large table (handreds of millions of rows)  into several ones?
0
 
LVL 30

Accepted Solution

by:
todd_farmer earned 500 total points
ID: 18847904
Outside of partitioning, no.  You can, of course, do application-level partitioning (say, A-D in tableA, E-J in tableE, etc.) - but that can be quite a change at the application layer.

I'd take a real good look at all of the open bugs (at http://bugs.mysql.com) related to partitioning before deciding to implement 5.1 in it's current beta state for this feature.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Creating and Managing Databases with phpMyAdmin in cPanel.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now