… am considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one user to lock records for edit…
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
May 21, 2012 By 10 Comments
hi ~ Ovais Tariq ,do you have dbt-3 Implementation document ?
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… couple scripts to be able to visualize sysbench results, they’re available here: https://github.com/tsuna/sysbench-tools I understand you need the fixes in your kernel, and many of Percona’s customers are in the same situation. That’s why we don‘t use RHEL/CentOS, because they come with generally outdated software and it’s hard to use newer versions…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… here. Q: Isn’t it possible to take all the locks required in the beginning to prevent dead locks? So you would get a… is designed to be resumable, although we 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…
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 tool …” on the y-axis. The reason why I have chosen to show “millions of rows” on the x…. Other important things to consider when you are concerned with write performance is using partitioning to reduce the size …
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have assisted Zend to introduce… on the IBM i platform. Zend approached us to say that they want to ensure there’s a way forward for IBM i…. If you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…
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 cluster. I am new in this field and being a startup company cannot afford to get paid support from percona, but at-least you can answer this one or provide a link to sample configuration…
Post: Training in London next week
May 16, 2012 By Leave a Comment
I’m going to deliver MySQL Training next week (May 21-24) in London. … of US. There are still some places left if you want to sign up. You will also get a signed copy of High Performance…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful when you start… Ubuntu 12.04, they are coming soon. If you want to know more how to migrate to XtraDB Cluster, we will be giving a free… is a software, so bugs are expected. If you encounter them, please report to our bug tracking system. Links: We provide tar…
Comment: Load management Techniques for MySQL
May 11, 2012 By 3 Comments
So, i dont know if there is the right place to suggest somenting , but i will, i have one question about… registers , so , what i can do , to get randomic result from this table, with best perfomance?!!? Do you want to post about it?! thanks..
