…MySQL 5.1 are not using the InnoDB plugin because it is not enabled by default! If people cannot be bothered to add a couple of lines to my.cnf to enable the InnoDB plugin, they certainly cannot be expected to… taken the time to show diverse workloads on … people still want to know how the rest of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to find this out is to…to the query or the table. We explain how to interpret what we’re showing…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set to 1. How to…to have reviewed this post. [1] http://dev.mysql.com/doc/refman/5.1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/refman/5.1…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1…how long will this take? Is there a facility we can run to show any table / index fragmentation, without having to…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… show the my.cnf settings…How does latency and bandwidth affect performance? Is it practical to buildthe cluster over a wan connection with ~ 5…mysql …how to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to…to 1, the reason for this is that only 1 node has to…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-…5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql…to IO alignment yourself. In this case offset is correct, but file system is unaware how to…to show you. First one is with RAID controller set to…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…MySQL will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to…5.5…how Shard-Query will perform on each database. To…to show (click show/hide to change the columns) That the “public dns” field is selected SSH to… ( [count(*)] => 135125787 ) 1 rows …
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
…1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL to try to…to enable the dynamic variable innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… wrote an article on how to do this. There is…my.cnf. This will make InnoDB to write the full status output into innodb_status.
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…how to run configure command, which needs to be done prior to…to extract the archive: (garfield:~/work) % gzip -c -d mysql-5.0.51a.tar.gz | tar -x -v -f – mysql-5.0.51a/ mysql-5…show.cc patching file sql/structs.h Now it is the time to…my.cnf…
