June 18, 2013

Post: A piece of Sun/MySQL Marketing

… stuff related to Sun and MySQL and among other things – These Benchmarks This may be great piece of Benchmarks for Sales and Marketing… run different MySQL and Web instances looks highly dubious to me…. at least this is not what you normally do for high performance Web apps which I have no doubt these benchmarks would be shown as. Another funny…

Post: Side load may massively impact your MySQL Performance

… It is very typical to hear complains about MySQL interactive performance – serving simple standard web traffic is …to the young sublist and as such placing high pressure on buffer pool. There is ingenious …pushed out of buffer pool. Lets repeat the benchmark with innodb_old_blocks_time=1000 which …

Post: Impact of the sort buffer size in MySQL

… Ronald Bradford (here), I decide to verify and benchmark performance while varying the size of the sort_buffer. …of MySQL. For the benchmark, I used an old PII 350 MHz computer, I think for such CPU bound benchmarks, … than 3MB. That seems to be a pretty high overhead per row (~37 bytes) but if the …

Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon

MySQL experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session is entitled “MySQL… His talk entitled “High Performance Replication” will cover his field experiences of having high throughput replication …

Post: MySQL versions shootout

… part of work on “High Performance MySQL, 3rd edition”, Baron asked me to compare different MySQL version in some simple benchmark, but on decent hardware…. Profiling MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5…

Post: EuroOSCON 2006 - High Performance FullText Search

… gave a talk on High Performance FullText Search for Database Content which is now available for download from MySQL Performance Presentations page We have… for full text search benchmarks with your own data. It was great to see a lot of MySQL guys on the conference… conference which surprisingly attracted very few people – there were more MySQL current and ex employees than attendees. Might be it was…

Post: Announcing Percona Server for MySQL 5.1.68 -14.5

MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance, scalability, features, and instrumentation. Self-tuning algorithms and support for extremely high-performance

Post: White Paper: "Scaling MySQL Deployments Efficiently" from Percona and Virident

…. I personally really enjoyed performance and stability provided by tachIOn card, and you actually saw bunch of benchmarks results published on our… the list of our recommendations for customers looking to improve performance or building high-performance solution based on MySQL.

Post: My talks on PL MySQL Conference (+free book inside)

…. There I will cover XtraDB Cluster features and usage scenarios. MySQL and SSD: usage and tuning. This talk I’ve been… new information. I will update the talk to reflect new benchmarks and new SSD. And as usually I will be available… to MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL: Optimization…

Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5

…. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w… with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb…