… is more version than platform dependent. PHP4 which is at end of life in 25 days handles doubles differently, on my MacBook Pro…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… inevitable: if you do this kind of data processing in MySQL, you’re going to end up heavily I/O bound.Â… “I admit defeat and accept table scans as a fact of life.” Table scans can be better than the alternative, if the…. Use The Best Technologies You Can MySQL is not the end-all and be-all. If you’re familiar with…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… not too many tools out there that can make your life easy. However, there is one such tool, pt-query-digest…. The first row in the table above shows the Count of number of times this query was executed. Now let’s take… plan used by MySQL. The end result might be that you end up limiting the number of results returned by the query, by…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… I have done thousands upgrades and downgrades in my life, the least number of problems come from RPM packages available in RedHat… never turned out to be any problem. On the other end there are Debian and Ubuntu. Both use tool called dpkg…, but this can also be the case for any high-end/enterprise class equipment. Hardware vendors may release Linux drivers on…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… with queries with no pause. That rarely happens in real life. There are no systems that are pushed to 100% load… different in the different part of day/week/month/year though). And what is important for an end user is response time… DROP TABLE, running in separate session, affect a response time of queries that handle user load ? The same for mysqldump, how…
Post: Choosing an appropriate benchmark length
March 21, 2011 By Leave a Comment
… results a lot. You can see this in all areas of life — you can sprint much faster than you can run a…. When designing a benchmark, you should think about what type of performance characteristics you are looking for in your production system… only one way to tell: keep running the benchmark. I ended up running the above benchmark for 72 hours to ensure…
Comment: Estimating Undo Space needed for LVM Snapshot
June 10, 2008 By 5 Comments
… nice writeup of background information and the plug about mylvmbackup 
The script actually prints the output of “lvs” at the end of the backup, which also provides information about the percentage of backing store used during the life time of the…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… and I am not an exclusion. I am under impression of count of storage engines were presented. In good old time when… Interesting engine, mainly because of way to store new records “never updates” and just write to the end of file. Surely it has… real situations, because theoretical ideas can be very far from life. Also nobody prohibits to add such index to other storage…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… 2339839999 1155959808 83 Linux Partition 3 does not end on cylinder boundary. The rest of the task is easy – you just have… size (logical/physical): 512B/512B Partition Table: msdos Number Start End Size Type File system Flags 1 2048s 19531775s 19529728s primary…. Now it may be interesting to see what are real life effects of misalignment, my benchmark results are in the second part.
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…realistic but could draw missleading picture as contribution of different components may be different depending on …APC shared memory cache – closest competitor. In real life performance difference can be evel larger as …the table as well – on this pretty low end box we’re getting over 7000 queries/…
