June 20, 2013

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

May 3, 2011 By 13 Comments

…MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL 5.5…my.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….

Filed Under: MySQL

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

February 26, 2013 By 1 Comment

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

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

Post: Tuning InnoDB Concurrency Tickets

May 24, 2010 By 5 Comments

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

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: , , , ,

Post: thread_concurrency doesn't do what you expect

June 4, 2012 By 3 Comments

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

Filed Under: MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…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.cnf…InnoDB tables whose .frm files exist but have been dropped from InnoDB…

Filed Under: Insight for Developers Tagged With:

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

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

Filed Under: Benchmarks

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

October 28, 2012 By 4 Comments

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

Filed Under: MySQL, XtraDB Cluster

Comment: MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

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

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

Post: Side load may massively impact your MySQL Performance

November 13, 2011 By 7 Comments

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

Filed Under: Benchmarks, Insight for DBAs, MySQL

Comment: When is it a time to upgrade memory ?

December 9, 2009 By 11 Comments

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

Filed Under: Insight for DBAs Tagged With:
« Older Posts