… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…a virtual-machine approach, but for the optimal production deployment you want two identical physical…slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If … file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… primers” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL and… a lot when my.cnf has extremely bad parameters. The kind you’ll get from tuning primers and automated my.cnf optimization scripts.
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…’ [generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than debugging)….–default-file=/etc/my.cnf (if this is where your my.cnf file is located) in…event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in …
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… settings. James also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes… have in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard 
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to … some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some…, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its…need more than simply looking at your my.cnf file. It’s sometimes possible to look at…prefer to speak specifically of configuring, or of performance optimization, or something more descriptive and concrete…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
….cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization… a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The… /usr/libexec/mysqld –defaults-file=/etc/my.cnf –basedir=/usr –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid…
