… be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer… focus include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to…
Post: Webinar: Best Practices for MySQL Scalability on May 1
April 30, 2013 By Leave a Comment
…: MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and indexing, and query design. To avoid having any one of them become the bottleneck that limits…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… Live London ticket! But first, what’s new with the MySQL query cache? You may know that it still has the same… on query cache mutex” when the query cache mutex is taken. This makes it really obvious when the query cache is a bottleneck. Oracle released a similar change pretty soon afterwards, but theirs changed the wording to “Waiting on query…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… common cache methods for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines each query to see if the contents have been stored in the query cache… trips to the cache. Summary tables Queries that access a lot of data usually face two bottlenecks: disk IO and CPU usage…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing performance bottlenecks as… database operations is reasonable. For example if some INFORMATION_SCHEMA query were to take couple of GB of memory we might… many performance bottleneck such profiling will help to find a lot of wasteful memory allocation and help to get MySQL on the…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… traversed in both directions for different queries. This will use fast primary key for some queries and use key K as covering… key significantly fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal with primary… the bottleneck. Also check out my old article on the topic which goes into a lot more details. Q: how mysql use…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
…-out or waiting, and the specific implementation has a scalability bottleneck on multicore servers. Mark Callaghan has done much more investigation… warehouse on MySQL, and in some cases for other uses too (note that most databases that do have these query plans usually…, because of things like the lower startup cost for the query). But MySQL isn’t a data warehouse DBMS first and foremost…
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… prevent queries from needing to enter the InnoDB kernel during the planning phase, which can be a severe bottleneck especially for complex queries… ever seen a server with dozens of queries in “statistics” state, that’s the bottleneck this feature could help alleviate. We merged…. We have decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…may cause significant overhead or may simply be bottleneck. If you can reduce your durability requirements this…use existing solutions you can use memcache + another mysql instance (or simply the database which is not …hour has to run rather complicated group by query ? Sure it does but it does not …
Post: Concatenating MyISAM files
November 19, 2012 By 5 Comments
…… select * from Innodb_table… would take about 10 days. The bottleneck was clearly the lack of concurrency on the read part… And then, back in mysql: mysql> use test Database changed mysql> flush tables; Query OK, 0 rows affected (0.00 sec) mysql> select * from test… the mix: mysql> truncate table test_concat; Query OK, 0 rows affected (0.00 sec) mysql> truncate table test_concat_part; Query OK, 0…
