June 19, 2013

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

… on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… ALTER 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

… a virtual-machine approach, but for the optimal production deployment you want two identical physical …use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. If you’… is my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL 5…

Post: Percona Server for MySQL 5.5.30-30.2 now available

… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could…-dir 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

… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could…-dir 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

… few “tuning 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 the… my.cnf only helps 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

…[generally available] packages may contain optimized or stripped binaries, which are optimized for speed rather than …include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in …91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld…

Post: Review of MySQL 5.6 Defaults Changes

… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… 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 to amounts of memory we have in the phones these days, I made in my Optimizing MySQL

Post: What's required to tune MySQL?

…you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its…simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see… to speak specifically of configuring, or of performance optimization, or something more descriptive and …

Post: How Percona does a MySQL Performance Audit

… than my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimization…’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way… OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here…

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

…people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the … | | optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize