June 18, 2013

Comment: MySQL 5.5 and MySQL 5.6 default variable values differences

March 31, 2013 By 8 Comments

….5 but tuned a few variables up with confidence since 5.6 sets them higher by default. Another minor correction: innodb_auto_extend_increment should be innodb_autoextend_increment (no space in autoextend) I made the mistake of copying the directive and using it in my.cnf which…

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

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

August 20, 2008 By 34 Comments

… hints regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but on… named “The ultimate tool for generating optimal my.cnf files for MySQL” ? ;-) The meaning of tuning my.cnf is not do to some magic (which… a very bad my.cnf can bring performance down even if you have correct design, index and optimized queries. Innodb on the other…

Filed Under: Insight for DBAs Tagged With: ,

Post: What's required to tune MySQL?

July 27, 2011 By 4 Comments

… not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server … simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see …. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done …

Filed Under: Insight for DBAs, MySQL

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 Comments

… created on disk. innodb_buffer_pool_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much… larger) so you can see how much memory Innodb allocates for misc needs. innodb_log_file_size Very important for write intensive… session variable tuning to second step after I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files…

Filed Under: Insight for DBAs Tagged With:

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

February 26, 2013 By 1 Comment

… and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain … lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse …innodb_ft_aux_table=’test/dir_test_innodb‘; mysql> set global innodb_optimize_fulltext_only=1; mysql> select * from information_schema.innodb…

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

Post: Tuning InnoDB Concurrency Tickets

May 24, 2010 By 5 Comments

… you’re optimizing for throughput in this scenario, you will tune innodb_concurrency_tickets to the 99th percentile of small PK lookups….sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush_log…

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

Post: thread_concurrency doesn't do what you expect

June 4, 2012 By 3 Comments

… my.cnf file by default. One example is Debian and its variants. Furthermore 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…

Filed Under: MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… attention. I use “tuning” in a generic way here — we focus on far more than my.cnf files. In fact my.cnf files are usually… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without… might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA…

Filed Under: Insight for Developers Tagged With:

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

… shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical… it? What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the best way to choose an innodb_buffer_pool_size… version is: ratio-based tuning is just as wrong for InnoDB as it is for MyISAM. Ratio-based tuning is invalid and wrong…

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

Post: New SpecJAppServer results at MySQL and Sun.

November 12, 2008 By Leave a Comment

…probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction…autoextend innodb_file_per_table innodb_log_group_home_dir = /log/mysql/var/ innodb_checksums = 0 innodb_doublewrite = 0 innodb_buffer_pool_size = 5000m innodb_…

Filed Under: Benchmarks
« Older Posts