… | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | …determine what kinds of things I ought to look for later during query…query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…storing the results of a query in Memcache. When the cache “expires”, the contents must be … from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( ->… orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query OK,…
Comment: MySQL caching methods and tips
April 5, 2011 By 5 Comments
I’ve always thought of the mysql query cache as being pretty much worthless, I mean it’s a … of a query can cause it not to use the cache – http://dev.mysql.com/doc/refman/5.1/en/query-cache-operation.html “Queries must be exactly the same (byte for byte) to be seen as identical.” The amount of limitations that determine…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… in which to determine how many concurrency tickets a query uses, making… that can enter InnoDB is limited by innodb_thread_concurrency (which…–max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable …_connections=3000 query_cache_size=0 skip-name-resolve table_cache…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…determine the memory consumption per connection in average? This leads to the next question c. Can we have a limit…query_cache_size=10M # Might be increased thread_cache_size=40 table_cache…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…is used by the randgen to determine the number, composition, and population… = [["--innodb-dict-size-limit=200k --table-open-cache=10"]] Granted, these are … ./dbqp.py –default-server-type=mysql –basedir=/path/to/Percona-Server … of other bugs: Crash when query_cache_strip_comments enabled For this …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… and the patch is. First you should determine how your current MySQL installation was built, so you can… file sql/slave.cc patching file sql/sql_cache.cc patching file sql/sql_class.cc patching… long_query_time AND min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 29, 2007 By 57 Comments
… not true, in “EXPLAIN SELECT SQL_NO_CACHE count(*) FROM count_test WHERE b = 666;”, count…WHERE b = 999 ORDER BY c LIMIT 5;”, mysql uses index to determine number of rows to examine (through…is much faster than issuing two queries. because second query which accepts limit and offset do the same thing…
