June 19, 2013

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

May 22, 2013 By Leave a Comment

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

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

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

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

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

Filed Under: MySQL

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

Filed Under: MySQL, Percona Software

Post: The ultimate tool for generating optimal my.cnf files for MySQL

August 18, 2008 By 34 Comments

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

Filed Under: Insight for DBAs Tagged With: ,

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

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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

Filed Under: Insight for DBAs, MySQL

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

Filed Under: Insight for DBAs, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

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

Filed Under: Insight for Developers Tagged With:

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

February 26, 2013 By 1 Comment

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

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