June 20, 2013

Post: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

…/data/sandboxes/msb_5_5_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp | | SECURE_AUTH | OFF | ON | | VERSION | 5.5.30 | 5.6.10…. Good change making the default practical on larger set of installations innodb_buffer_pool_instances is now 8 instead of 1… I guess is one of the component of purging fine tuning in MySQL 5.6 innodb_file_per_table is now ON by…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…the third installment, we’ll look at query performance. In the event that a new release of 5.6 …used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception …two separate ALTER statements, and it appears to work fine. But here’s where things start to get …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Comment: What's required to tune MySQL?

August 4, 2011 By 4 Comments

One of our MySQL 5.5 installation runs on a single PC. There are no space constraints … and log_size should I keep? What other parameters to fine tune? Is there any MySQL database profiling tool through which it…

Filed Under: Insight for DBAs, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… that are at any level of tuning, from completely untuned to a system …MegaCli is installed, and use it to get information about the physical drives installed; then …to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know … hardware and the machine setup is fine, and the client has asked me …

Filed Under: Insight for Developers Tagged With:

Comment: Shard-Query turbo charges Infobright community edition (ICE)

May 6, 2011 By 23 Comments

… the table. I did not do any tuning. I simply installed the ICE RPM and loaded my data. … have a processor (i970) which supports native virtualization. 5> The airport dimension contains only 400 or so …varchar columns, but ICE will handle them just fine. After compression each node contains only a few…

Filed Under: MySQL

Comment: Pitfalls of converting to InnoDB

March 8, 2007 By 16 Comments

… found. I’m using PHP 5.1.6, MySQL 5.0.24a default installs from Ubuntu 6.10, so… to invoke the rollback(). This seems to work fine. public function begin_transaction() { $ret = self::$mysqli->autocommit(false…I’m assuming that’s standard (I haven’t tuned anything). So your script could loop for 5000 …

Filed Under: Insight for DBAs Tagged With: ,