… works on MySQL, with no need to rewrite applications, management scripts, or anything else. There is no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically on… play a role. Zend DBi is available under GPL license from Zend website.
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…standoff” talk at the upcoming MySQL conference, and Timour and Sergei from Monty Program will present a… log makes the server much faster with the binary log enabled Faster queries through speedier joins, faster… in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different forms, …
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…makes the replication between servers consistent. If you execute SELECT * FROM id > 1000 FOR… entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 …difference between these two options is that the second one is a global variable that affects all sessions and needs a server…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
…queries) and not “made up” queries 2) with a master, slave system so we could also benchmark virtualized servers with different workloads. We have made the same observations as you, but from a different angle. In fact the servers… it to MS SQL Server, not to MySQL yet, but it is…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
…query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server…query took on the server, and the client that sent the query to the server might see something quite different…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… property is different from completely transparent cache and you’ll see why below. So what I think could be done with MySQL Query Cache… where this query comes from or what application user triggered such query. Query Cache matching can be done a lot smarter. At Percona Server we…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query…Query cache catches network packets as they sent from client to the server…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… for similar reason as MySQL Restart – the traffic on different boxes might be different and hence cache content… traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it … when overly eager batch job doing updates from 20 threads on the master will create …
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL Server is a very interesting task as you can approach it with so much different “depth…or work differently after change. For example you may get queries returning different result or getting different execution …SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL version…
