… 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: Announcement of Percona XtraDB Cluster 5.5.23
May 16, 2012 By 11 Comments
Gilles, you can filter what tables to replicate using regular replication filter i.e. replicate_*, for it does not affect a node propagation. The new node still will copy all databases and instances.
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… 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 ? without any replication…
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: 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: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling New SST wsrep_sst_method=skip, useful when you… 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…
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…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… if you have system completely at your disposal. If you however need system to serve other users too you typically need to reduce concurrency to where… idea. It also often helps with monopolizing replication thread. For example if I need to delete old data instead of DELETE FROM…
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…
