Re: InnoDB vs. other storage engines

2012-09-22 Thread Michael Widenius
Hi! Manuel == Manuel Arostegui man...@tuenti.com writes: Manuel 2012/9/19 Mark Haney ma...@abemblem.com I hope this doesn't end in some kind of flame war. I'm looking to optimize my tables (and performance in general) of the DB my web app is using. I'm tweaking things a little at a time,

Re: Risks involved in MyISAM to Innodb

2012-09-22 Thread Reindl Harald
Am 21.09.2012 18:18, schrieb Rick James: (Apologies to the rare bottom-poster.) bullshit on mostly egvery mailing-list there are guidlines that you NOT should top-post, try it out on the postfix-list as example and wait what Wietse wille xplain you about both * your top-posting * and your

RE: Aggregate

2012-09-22 Thread hsv
2012/09/04 11:43 -0700, Rick James int(1) does not mean what you think. Probably you want TINYINT UNSIGNED. Yeap, a real misfeature of MySQL. It is also one of the ways wherin MySQL puts in C and takes PL1 away. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Mysql cluster installation error

2012-09-22 Thread Aastha
Hello, I am trying to install MySQL cluster on three physical machines. Management Node on one machine. Data Node on two machines. SQL node on the same machine as Management Node. Management node started Data Nodes started *SQL node started but not connected to Management NOde and it gives no

Re: Partitioning on a Substring of Varchar Column in Mysql

2012-09-22 Thread Adarsh Sharma
On Fri, Sep 21, 2012 at 9:43 PM, Rick James rja...@yahoo-inc.com wrote: Some statements are incorrect... If you PARTITION on (`x`), then `x` must be included in every UNIQUE key. That includes the PRIMARY KEY. You do not need to PARTITION on the PK. Yes true, but my application requires