June 20, 2013

Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5my.cnf settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_flush_log_at_trx_commit=2 innodb_doublewrite=1 innodb… future 5.6 tuning. MySQL 5….

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

… it is true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical… used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that…likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that…

Post: Tuning InnoDB Concurrency Tickets

…: 0 mysql> ALTER TABLE test_table ADD INDEX (id); — 5 Tickets Used… this scenario, you will tune innodb_concurrency_tickets to the …mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb

Post: thread_concurrency doesn't do what you expect

… the default my.cnf files of MySQL like my-large.cnf, my-innodb-heavy-4G.cnf and so on have the thread_concurrency enabled with a tune advice helping…/ innodb_thread_concurrency places a limit on the number of threads that can be running inside InnoDB. The default value in 5.5 is…

Post: How Percona does a MySQL Performance Audit

tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf… cases): vmstat 5 5 iostat -dx 5 5 If you…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnfInnoDB tables whose .frm files exist but have been dropped from InnoDB

Post: New SpecJAppServer results at MySQL and Sun.

…disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA…mysql/var innodb_data_file_path = ibdata1:10000M:autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

…: Can you quickly show the my.cnf settings again? A: Sure, … a wan connection with ~ 5 ms latency? A: Yes, … galera and built-in mysql replication (asynchronous) for a …innodb), do you have a recommended configuration? A: We don’t have any specific recommandations for Zabbix, but general InnoDB tuning

Comment: MySQL 5.5 and MySQL 5.6 default variable values differences

5.5 and 5.6 should really take a look at https://blogs.oracle.com/supportingmysql/entry/server_defaults_changes_in_mysql… best for well tuned OLTP and …innodb_purge_batch_size is a performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb…in the default my.cnf file that we …

Post: Side load may massively impact your MySQL Performance

mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysqlmysql-host=localhost –mysql-table-engine=innodbmysql

Comment: When is it a time to upgrade memory ?

5% and sometime it’s upper 90%. I think this might be due to the “innodb… is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_…InnoDB bulk_insert_buffer_size=8M # Innobd Tuning #innodb_force_recovery=2 innodb_thread_concurrency=2 innodb_file_per_table=1 innodb