… increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time … is being done in terms of requests per second. Should be easy to see on the… queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query …
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…performance: understanding events at points in time. And in a system that accepts, processes, and replies to requests (queries…maybe a bit longer. This is common in MySQL servers I work with when they’re … per second. A few of the requests will arrive in one second and complete in the next second, …
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
…a customer issue wherein they were observing database performance that dropped through the floor (to the point…to be considered as being defined first. So, MySQL checks our INSERT, sees that the next auto…what the problem turned out to be. 1500 queries per second all trying to lock and update the same…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… Performance Overhead Checking whether the connection is active typically involves a call to the ‘ping’ or ‘statistics’ command at the MySQL …their queries take longer than a millisecond or so. When you’re running 20k queries per second against your database server, an extra 20k queries per second…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
…Per second (latency sensitive) or using Over 500MB/s bandwidth (bandwidth sensitive). I wonder how many of MySQL…MySQL as MySQL optimizer with its nested loops joins does not favor sequential scans even for analytic queries executions. Also lack of parallel query… performance with multiple MySQL …
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…have discovered with the buffered IO mode the query was taking almost half the time of …| with number of data reads spiking to over 2000 per second – a lot more than this software RAID could…performance should be better as it has less overhead with double buffering as well as more information MySQL…
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
… you get multiple queries to execute at once you can perform optimizations to share certain execution steps for the queries. This is more… date to show history of matches per day. This could be very well optimized by performing search query only once while having multiple… them. Even though second feature may look simple I do not think it would be implemented in MySQL any time soon – this…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… how much data we can comfortably put in MySQL Instance without getting in too much trouble with …per second and your SSD drive can do 10000 does it mean if you have array with 50 hard drives it would perform… delay or speeding up this 3 hours reporting query or 5 hours ALTER TABLE command. Let me …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… between the counter events and the query‘s execution time. Alas, that correlation…per second. Compare that to what your disks are capable of, and draw your own conclusions about whether this is a performance…MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
… Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5…in performance. Other then that, I have also disabled query cache to avoid contention caused by query… Per Second, while with the table purchases_index, the avg. insert rate reduced to ~9k INSERTs Per Second….
