… few GB of main memory). The cost of querying this database will be 10 times higher with this partitioning, however since…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…. Why is that ? Performing MySQL upgrade two things should…MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL 5.0 database with MySQL…measuring its capacity) Setting up the Slave(s) If you want to minimize downtime it is best to use MySQL…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… anyway, I decided to check peak performance of all caches compared to MySQL Server, by measuring just the time it takes cache to… was selecting from MySQL table. Query vas very simple – lookup by primary cache, so this is kind of peak performance MySQL can provide. Of course for your real queries cost of database access will normally be larger…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
… is also typical in most systems such as database servers. As a result, completion times shouldn’… maybe a bit longer. This is common in MySQL servers I work with when they’re …pretty much everything else about a system’s performance (via measuring response times), scalability (via the four …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…to predict in performance, the model baron has published for example is good for measuring scalability of …can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 …0 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…MySQL Database most people compress them – which can make a good… databases – for databases below 100GB in size compression performance is usually not the problem (though backup impact on server performance… and redirected to /dev/null so we only measure compression speed). On the test box with Intel(…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2… benchmark is long-term performance, but as a side project, I thought it would be interesting to measure the single-threaded insert…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… post I wanted to mention what James calls “Busy” Oracle database application when it comes to IO consumption: It is applications… between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large scale systems (both in terms of performance and operationally) and as MySQL is making…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-performance ratio and increase the utilization of the tachIOn drive, Vadim sharded the database into smaller instances and… of anyone measuring the different configurations the way Vadim has done. You can read the full details in our Scaling MySQL With…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
…we’re done.” In databases, we care most about the work the database is doing. That …, which has been available in MySQL for years. This is necessary …diagnose the kinds of sub-second performance stalls we are interested in. Without… awk scripts and various statistical measures. What do you think? Is …
