… solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are… (your log rotation scheme likely offers similar options with a different name): copytruncate – Copies the file to a new name, and…/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…built from several queries) Infrequently changing data (…’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts = array( ‘servers‘ =>array( array( ‘host’ => ’192.168….differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…to see this point of intersection, let’s review different workload (which actually is closer to what I …-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = …
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…in Percona Server attacks this problem from a different (and a wider!) angle. It requires neither read-only server nor rewriting application queries. Furthermore, it can be combined with the read-only optimization in MySQL 5.6 to…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 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 70 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: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… still need to keep into account possible query changes, replication etc. Q: Is it possible… Another thing to mention having multiple instances of different MySQL versions on the same box typically means… from MySQL 5.5 to Percona Server 5.5 Compatibility is our highest priority with Percona Server,…
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…
