One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… total any more as Innodb has moved allocating memory from operation system directly not from addition memory pool (hence 0). Such… Leaks There are many kinds of memory leaks and I would say these are rather rare in MySQL. Most suspected memory leaks… and fixed. This is where your MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…. Now, Valgrind does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, which is synonymous with…-55.patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5…-minor. Additionally, I’d consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… what kind of Version and Platform support do you think is adequate for MySQL ? Oracle seems to have extended support for MySQL versions… as people doing major MySQL upgrade usually would have an option to upgrade operating system as well Or is MySQL Upgrade to new version while sticking to very old operating system is important…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… cool you want your database operation to be ? Visiting customers I see 2 very distinct groups of MySQL Users Users what want… not done before, they are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff. Some… quick learning curve is robust and easy to operate and has few surprises. As MySQL matures and gets more and more used…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… not do. You should not panic and go change all kind of configuration options in case you get lucky. Sometimes you… MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating… it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld…; it is requiring in average 0.54 read operation per second which takes 4ms which adds up…. From this you can very easily understand what kind of hardware will take you to reach appropriate …
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… between MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of these kind… DBA you better to understand network topology to understand what kind of performance availability and failure scenarios you should expect. If…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… delayed invalidation. In many applications you have updates which are kind of not important you just need them to propagate sometime… exactly MySQL Query Cache is working in many cases. This however can be improved and data about Query Cache content and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… however the cache (ie memcache) is often implemented to offload MySQL. When it comes to large scale data processing other techniques… need, even on the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster… node. May be MySQL Cluster will evolve and data storage nodes will be able to perform all kinds of operations, in which case…
