…5 and the version of MySQL used was Percona Server 5.5…time-based flushing enabled actually produces …mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…our download site here and Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries, making it ideal for companies…Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… Meta Data Locking behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a statement that opened…_cache? That is an important question. If Query Cache is enabled and the SELECT can be serviced from the Query Cache… int(11) not null auto_increment primary key) ENGINE=InnoDB; When using MySQL 5.1 the second CREATE would just fail immediately with…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… possibilities like InnoDB doing read_ahead by noticing the sequential access pattern. BKA is available in both MySQL 5.6 and MariaDB 5.5. You… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5…_read_next’ and ‘Handler_read_rnd_next’. MariaDB 5.5 with Hash Joins enabled is doing less Handler reads as compared to when…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…is the ability to enable logging atomically, not just for new connections as in MySQL. This is very…InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB…wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film …
Post: InnoDB thread concurrency
June 5, 2006 By 4 Comments
… observed even with limited innodb_thread_concurrency. This is why innodb_commit_concurrency variable was added in MySQL 5.0 innodb_commit_concurrency limits number… may make sense. If you have binary log enabled it often does not really matter as Innodb will serialize commit operations anyway.
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… MySQL 5.5.8 (with innodb_doublewrite enabled). In summary, my conclusion is: You can try to get stable throughput in MySQL 5.5.8 by playing with innodb_max_dirty_pages_pct and innodb_io_capacity and having innodb_doublewrite enabled. But you must…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… is of importance I would recommend using Percona Server with enabled expand_fast_index_creation feature, as I just wrote this…: Upgrading to MySQL 5.5 do we really need all tables changed to Innodb and character set set to utf8? No. MySQL 5.5 continues to support… new release. Also note the default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-… at boot time [root@alarmpi ~]# systemctl enable mysqld ln -s ‘/usr/lib/systemd/system/…InnoDB | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES | YES | YES | [...] mysql…
Post: Data compression in InnoDB for text and blob fields
May 30, 2012 By 2 Comments
… default after MySQL 5.0.3 and has a more compact representation for nulls and variable-length fields than REDUNDANT. Using InnoDB’s new Barracuda file format (available since InnoDB plugin 1.1 or MySQL 5.5) you can now leverage… need to enable the dynamic variable innodb_file_format=BARRACUDA (don’t forget to set it in my.cnf!): SET GLOBAL innodb_file…
