June 18, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine.  In my testing I discovered that innodb_old_blocks_time had an… KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Leave a Comment

…() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug… 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…

Filed Under: MySQL, Percona Software

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

…() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug… 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…

Filed Under: MySQL

Comment: MySQL 5.5 and MySQL 5.6 default variable values differences

March 31, 2013 By 8 Comments

… 5.6 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…

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

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.118…

Filed Under: MySQL Tagged With: , , ,

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb-flush-log…

Filed Under: MySQL

Post: Review of MySQL 5.6 Defaults Changes

October 8, 2012 By 10 Comments

… not just default at 2000 ? innodb_file_per_table =1 Great! We found it is better choice in 95%+ of installations innodb_log… even more would be good default. query_cache_size = 1M Query cache remains off by default but default size is raised to 1M… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring…

Filed Under: Insight for DBAs, MySQL

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

February 26, 2013 By 1 Comment

…_name` varchar(100) DEFAULT NULL, `details` text, PRIMARY KEY (`id`), FULLTEXT KEY `full_name` (`full_name`,`details`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 We… people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case… to the default InnoDB settings for MySQL 5.6, and that was to change innodb_ft_min_token_size from the default of 3…

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

Post: How to recover a single InnoDB table from a Full Backup

January 25, 2012 By 10 Comments

… on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log…

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: A quest for the full InnoDB status

October 31, 2008 By 4 Comments

… can have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status.InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full…]ysqld 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my case the process ID is 11886, so I…

Filed Under: Insight for DBAs Tagged With: ,
« Older Posts