Percona's MySQL & InnoDB performance and scalability blog
… I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_STOPWORDS.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15… people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the case…
…=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post…on asynchronous replication, galera and built-in mysql replication are independent from each other. Q…specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments…
… affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> SELECT COUNT(*) FROM test_table; — 3 Tickets Used +———-+ | COUNT(*) | +———-+ | 3…_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency…-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G…
… them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema…-mode=accurate –db-plugin=libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql-schema=imdb This example uses accurate… this information to decide if the test server needs further tuning or how it will be able to sustain production load…
… tuning ? If you want fast full table scans for large table you should set this variable 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…
… you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30… default-storage-engine=InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file…
… a difference between “better than default my.cnf” and “optimal my.cnf” – It is indeed possible to automate …. This is in particularly so because during tuning there are many questions which human needs …log_file_size than optimal), fast warmup after MySQL Restarts (so you need double buffering and…
… to 11% yes… Perhaps I should say MySQL 5.5 is 11% faster than MySQL 5.6 rather than 5.6 is… used MySQL Sandbox set up with MySQL 5.6 and 5.5 in their default settings. I did not do anything to tune… “skip-performance-schema” to my.cnf I think you guys in development team grossly overestimate how much tuning the general user is going…
… I’ve tuned everything up in the settings and have a better understanding of what each setting does in the my.cnf, I… set your buffers and settings too high and restart your mysql server, mysql wont instantly complain. What I think happens is it… is slow. This can seriously impair your performance! My only wishes for mysql would be that they would allow you to log…
…supportingmysql/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/en…on. QC off tends to be best for well tuned OLTP and web sites using queries that mostly …it in the server defaults but in the default my.cnf file that we ship. It’s also done by…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.