… considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used… example of a program is worth a 1000 instructions. Please do this for us. I am sure there are many in this situation…
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 ?
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
…you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries…of concurrent load on it the response times will increase and user experience will suffer. So what you can do to prevent this…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
…can you help re-affirm this statement about replication? I’ve observed things differently in MySQL…boxes, then the LOAD DATA command will fail silently, allowing replication …this, make sure ‘/tmp/data.out‘ does not exist in any of the slaves when you run this on master LOAD DATA INFILE ‘/tmp/data.out…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
…query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run…you want to leave the IBM i platform and switch to Oracle’s MySQL…variant of the MySQL server. We have a history of improving the MySQL … Zend took this initiative, and even happier that we can play a …
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… into t values(33); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction Here I tried to insert a value out of [21…) MySQL thread id 31929, query id 484616 localhost root update insert into t values(33) ——- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK…
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
…of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can…run. will that cleanup ? Q: dose the tool exit gracefully while interupted? The tool doesn’t…MySQL bug. Are you sure this…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…query, assuming you can get each index query down to one disk seek.) I claim that this…mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if you fail…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
…t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error and stop this script. As I can…of “Slave_SQL_Running: Yes” fails, because the server is not running as a slave. So the 2nd start of pacemaker would be fail…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the buffer…query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now…causes a write throughput increase of 2x to 3x. In this particular case, since I …
