… “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you…movies, but your random number generator picks values …, it is equivalent to this expression: WHERE k1.keyword = ‘espionage’… I did not use the STRAIGHT_JOIN, the query optimizer …Q: Bill, back to the query where you were trying …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… queries only. An additional benefit is that SchemaSpy is …mysql.properties file While not explicitly required, I prefer to create this once so that the command line is… at all. This is where Metadata files come …is the only component of the tool. There are additional tabs: Tables – Names, number…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… monitor MySQL to determine when it’s not responsive? A: The easiest way to do this is to simply… number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing… back end, but I think that’s probably where the similarities end. Q: What kind of replication…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…#1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force…_CHANGED_PAGES query is issued that has an empty LSN range and thus does not need to… #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu …
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT…Number of processes running now: 0 130528 09:53:56 mysqld_safe WSREP: not restarting wsrep node automatically 130528 09:53:56 mysqld_safe mysqld from pid file /var/lib/mysql…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…is that it is not persistent. While a common design consideration when using a cache layer is…MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
…MySQL performance at low concurrency is important for you. I decided to write about this topic as a number…MySQL server does not use multiple threads to execute query…is not possible. Want to talk more about performance? Come to Percona Live MySQL…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… numbers from the vCache test where the time-based flushing is enabled…percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb …= 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log =…cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… clarify what MySQL Query Cache is – I’ve seen number of people being confused, thinking MySQL Query Cache is the same as Oracle Query Cache – meaning cache where execution plans are cached. MySQL Query Cache is not. It does not…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…as where this query comes from or what application user triggered such query. Query Cache …. Many applications in MySQL have very large number of queries doing updates through …not quire sure if it is worth doing or if delayed invalidation is enough. Improve Manageability What is in the MySQL Query…
