… with default settings using only the InnoDB storage engine. In my testing I discovered that innodb_old_blocks_time had an effect on… KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb_file_per_table innodb_stats_on_metadata=off innodb_file_format=barracuda innodb_log…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… can also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’re thinking about… obvious disclaimer here in that the aforementioned statements reflect only my opinion and not any official Percona position, and I will… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf file, site performance was good….1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845… #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845… #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
March 31, 2013 By 8 Comments
… sets them higher by default. Another minor correction: innodb_auto_extend_increment should be innodb_autoextend_increment (no space in autoextend) I made the mistake of copying the directive and using it in my.cnf which…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
In your my.cnf conf I don’t see barracuda file format and did you create your table using row_format = compressed with InnoDB which enables tablespace compression ?
Comment: Percona XtraBackup 2.0.7 for MySQL available for download
May 14, 2013 By 1 Comment
… my backup script get this error: “innobackupex: fatal error: no ‘innodb_buffer_pool_filename’ option in group ‘mysqld’ in MySQL options” My server is MySQL 5.5, my command is “innobackupex –defaults-file=/etc/my3.cnf –host=192.168.10…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… the maximum InnoDB: allowed value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too… be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf So we can see Innodb may with…
