June 20, 2013

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

…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each… 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…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

…-machine approach, but for the optimal production deployment you want two…_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. …my recommendation for MySQL 5.6? Is MHA ready for MySQL 5.6? A: My personal recommendation for MySQL…insert a few rows into an InnoDB table, but trying to run…

Post: Percona Server for MySQL 5.5.30-30.2 now available

…set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the…1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all …Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the …

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

…set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the…1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all …Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the …

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 case… happens: mysql> set global innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb_ft_config…

Post: Review of MySQL 5.6 Defaults Changes

…Good to see innodb log re-sizing is made automatic now. innodb_old_blocks_time…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: How innodb_open_files affects performance

…. I used MySQL 5.4.2 for tests which should be as good as it gets in terms of optimizations in this… 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…

Post: What's required to tune MySQL?

…expect to deliver huge wins. If MySQL is actually badly configured, you can…the InnoDB buffer pool size or log file size, and not using InnoDB. If…at your my.cnf file. It’s sometimes possible to look at the my.cnf file… specifically of configuring, or of performance optimization, or something more …

Post: How Percona does a MySQL Performance Audit

my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query optimizationmysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf

Post: Heikki Tuuri answers to Innodb questions, Part II

my workload has a hi amount of concurrent writes to about 6 tables, what version of Innodb/MySQLinnodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB…, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, …