hi ~ Ovais Tariq ,do you have dbt-3 Implementation document ?
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
…-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… you need the fixes in your kernel, and many of Percona’s customers are in the same situation. That’s why we don‘t…, we’re currently on 3.0). But I agree with you that there’s a difference between when the developers consider… can actually get the fix, regardless of whether or not you‘re on a slow track with RHEL or on a…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… that would defeat the purpose of the tool. Q: When you say bail out, what does that mean? Does the tool… don‘t yet have a “resume” feature implemented. Q: periodically the ALTER isn’t written to the bin-log and thus isn’t replicated, why… on the __tmp_x table why ? The first question sounds like a potential MySQL bug. Are you sure this is really happening…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…, and I have some interesting results that I wanted to share. I used a nice and effective… Per Second” on the y-axis. The reason why I have chosen to show “millions of rows”… secondary indexes. Other important things to consider when you are concerned with write performance is using partitioning…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
…, there are still users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that… you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is… be a great service to IBM i MySQL users who want to remain on their chosen platform. We’re happy that…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…. I don‘t see anything suspicious in the /var/log/mysqld.log file which i believe is the error log you are talking…/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don‘t see how MySQL could be using any other conf file…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
…_engine, query_cache_size, e.t.c…. Is it something built in or we just don‘t need to define it for the… afford to get paid support from percona, but at-least you can answer this one or provide a link to sample…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… can explain the performance you are seeing. But first I’d like to note that this experiment isn’t really running the…. Here’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling up… a new one. (If I read your graph correctly, you didn’t graph the performance on the first 100M rows). The minimum…
