June 18, 2013

Post: What's required to tune MySQL?

July 27, 2011 By 4 Comments

…!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question that I hear often… actually badly configured, you can hurt its performance significantly. Correcting these mistakes can correspondingly improve performance. But such mistakes are relatively few… see are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server really hasn…

Filed Under: Insight for DBAs, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…are at this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? … systems that are at any level of tuning, from completely untuned to a system that’… there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… identical to the same query when performed against InnoDB data, OR that the results returned by InnoDB FTS will somehow be “better” (as… and MySQL 5.6.10 with no configuration tuning other than to set innodb_ft_min_token_size to 4 (rather than… search terms, and in this case, both MyISAM and InnoDB FTS performed identically and found it. I’m not really concerned about…

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

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

February 26, 2013 By 1 Comment

… 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain below) – the…’ll get to performance in the third installment. For now, the important number here is to note that the InnoDB buffer pool… bulk insert performance. At the very bottom, the page claims that you can speed up bulk loading into an InnoDB FT index…

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

Post: How Innodb Contention may manifest itself

July 28, 2011 By 1 Comment

… you can consider increasing innodb_sync_spin_loops to a higher number. It is worth to note fine tuning Innodb Contention with number of spin locks loops is something i would consider last resort tuning, the performance improvements it…

Filed Under: Insight for DBAs, MySQL

Page: Consulting for MySQL

July 31, 2006 By

…workload. Innodb Storage Engine Running transaction applications with MySQL ? Need help with deadlocks, understanding how Innodb locking works or having Innodb performance issues ? …implementing Full Text Search solution ? We can help with fine tuning MySQL build in Full Text Search indexing or help …

Filed Under:

Post: Side load may massively impact your MySQL Performance

November 13, 2011 By 7 Comments

…. It is very typical to hear complains about MySQL interactive performance – serving simple standard web traffic is drastically impacted when some… makes workload extremely IO bound hence such drop in performance. The performance of mysqldump is impacted too because we now have 2… advanced tuning you might also look into changing how buffer pool is split into young and old sublists via innodb_old_blocks…

Filed Under: Benchmarks, Insight for DBAs, MySQL

Post: InnoDB Flushing: a lot of memory and slow disk

March 31, 2011 By 57 Comments

… increase innodb_io_capacity and decrease innodb_max_dirty_pages_pct so as to have fewer dirty pages. But I call that tuning… InnoDB will flush, and P is our page. So, as a result of how it works, instead of performing 1 random write, InnoDB will perform 8 random writes. I do not have a…

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Post: The performance effects of new patches

September 9, 2008 By 14 Comments

…, in some extreme cases, it is worth to tune. The following parameters are added. innodb_read_ahead (default 3) This controls [enable… help the performance. * This test uses “innodb_read_ahead = 0″ (The both of read-ahead are disabled) “innodb_ibuf_contract_const = 50000″ “innodb_ibuf…

Filed Under: Benchmarks, Percona Software Tagged With: , ,

Post: How well does your table fits in innodb buffer pool ?

December 9, 2010 By 12 Comments

…_id = innodb_sys_tables.id JOIN innodb_index_stats ON innodb_index_stats.table_name = innodb_sys_tables.name AND innodb_sys_indexes.name = innodb_index… use this feature to tune buffer pool invalidation strategy, for example play with innodb_old_blocks_pct and innodb_old_blocks_time actually… recover. This tool can be also helpful for capacity planning/performance management. In many cases you would learn you need a…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , ,
« Older Posts
Newer Posts »