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… too high Many developers will test script with multiple level of concurrency and find out doing work from 32 processes is…
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…. Memory Leaks There are many kinds of memory leaks and I would say these are rather rare in MySQL. Most suspected memory leaks… it should be and I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in this space allowing us…
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 cool… are interested in all kinds of plugins, replicating from MySQL to Cassandra and doing other cool stuff. Some of this cool stuff can be… of MySQL users which is in hundreds of thousands to the millions. Do not get me wrong this is a very important group of…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… not enough as MySQL allows you using multiple storage engines in the query you need to test all kinds of combination such as running multi-table update joining PBXT and Innodb tables. Operations Things like backup and… very actively because of potential complications involved. Now lets think what we could have if we have a version of MySQL Server which…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…-helgrind-55.patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5… errors were data races, and here we see a new kind of error: lock order violation, thus a potential deadlock. The locks…-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
… to stay on old MySQL releases. Now where I’m looking for your feedback is understanding what kind of Version and Platform support do you think is adequate for MySQL ? Oracle seems to have extended support for MySQL versions… option to upgrade operating system as well Or is MySQL Upgrade to new version while sticking to very old operating system is important…
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 do… about MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating… in Percona Server indeed by running the same test on MySQL server of the same version. If you’re Support customer you…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty …it is requiring in average 0.54 read operation per second which takes 4ms which adds … what kind of hardware will take you to reach appropriate performance, what kind of hardware provides better balance of …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL…kind of breed between Ruby on Rails in terms of getting it up and running fast and Scalability on the scale of…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… work during maintenance window which involved a lot of data copying around between MySQL boxes. We had prepared well and had measured how fast we could copy the data between servers of these kind connected… DBA you better to understand network topology to understand what kind of performance availability and failure scenarios you should expect. If your…
