Solved

Is MySQL 5.1 stable?

Posted on 2007-04-03
3
608 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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