…memory increase after executing a particular query. Or, maybe mysqld is seemingly …not stripped of them (downloaded ‘GA’ [generally available] packages may contain optimized or …Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… ? Not really. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables… and other storage engines transaction logs, slow query log or general log. flush, flush_time Flushing (closing) of tables after query is complete or every flush…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… lets us gather queries from servers that don’t have a slow query log enabled, at very…general, it’s working very well. We can gather just about every bit of information about queries that mysql…Let’s see: mk-query-digest –type=tcpdump –report-format=profile tcpdump.out # Rank Query ID Response time…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL…mysql> show table status like “post_channel” \G *************************** 1. row *************************** Name: post_channel Engine: InnoDB Version: 10 Row_format… Collation: utf8_general_ci Checksum: … scan queries, though …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log…general_log = ON max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log…
Post: How To Test Your Upgrades - pt-upgrade
December 29, 2011 By 7 Comments
… queries # –print simply returns the queries in slow log format and –sample # limits this to 100 queries only # –no-report simply skips the overhead pt-query… in general how each fingerprint performs on the test servers. About 10% variation is tolerable and can be accounted for other MySQL…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… 5.1.53-12.4 is based on MySQL 5.1.53. Â New Features Added: Precompiled…Bugs Fixed Bug #643149 – Slow query log entries were not written in the usual parsing format. (Alexey Kopytov) Bug #671764 -… bugs found at Bugs in Percona Server. For general questions, use our Percona Discussions Group, and for…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… very little work and formating, so > database connection …to use query and external caching of result sets is generally… MySQL you might be > better of using several queries …queries, especially > if you see them in slow query log. If you have trouble understanding > EXPLAIN or optimizing your queries…
Post: Maatkit Now Supports Memcached
July 24, 2009 By 11 Comments
… which would be displayed for MySQL queries. Commands are fingerprinted so that…to gets (or, retrieval cmds in general) that were interrupted (some things … is “fingerprint” just like for slow query logs. So the fingerprint for this …Some things are TODO; the report format could be cleaned up a little…
Post: mk-query-digest, query comments and the query cache
…MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs… in a specially formatted SQL comment. This information can then be cross-referenced between MySQL logs and Apache logs. select 1 — File: …