… 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…
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
… lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163 localhost msandbox TABLE LOCK table… difference between these two options is that the second one is a global variable that affects all sessions and needs a server… these locks can be different. In the following link there is a good source of information: http://dev.mysql.com/doc/refman…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… for the binary log makes the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and… also available either in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different forms, so there is some subtlety to this list. For example, Percona Server has the same group commit fix, and MySQL…
Comment: Introducing new type of benchmark
February 27, 2012 By 16 Comments
… (real 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 that…-look/3. We have applied it to MS SQL Server, not to MySQL yet, but it is the same idea and only…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… is different from completely transparent cache and you’ll see why below. So what I think could be done with MySQL Query Cache… this query comes from or what application user triggered such query. Query Cache matching can be done a lot smarter. At Percona Server we… complex expensive queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in…
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… For example I’m using Query Cache on server which runs this blog. …query, have extra space or use different case – these would be different queries for query cache. Only SELECT queries…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case of Percona Server, a great deal… the time the query took on the server, and the client that sent the query to the server might see something quite different. Sometimes it…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… multiple servers you may decide ether to grow system in MySQL+Apache pairs or split MySQL And Web Server and place them on different boxes. Generally using separate boxes for MySQL and Web Servers is… generated by 1000+ queries, which is bad idea already. One case I should mention when shared MySQL and Web server makes sense is…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… Live London ticket! But first, what’s new with the MySQL query cache? You may know that it still has the same… was still a query-cache single choke-point in the server. Now that’s gone. As of MySQL 5.5, the query cache mutex… some related changes in Percona Server 5.1 a while ago. I don’t recall the differences between Oracle’s changes and…
