…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server…how much total gain I can get from it. Queries are not just “bad” or “good” –…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql…query logging and log_slow_verbosity=full you can also get great amount of related data from mk-query…======= ======= ======= # Exec time 8338s 1us 284s 5ms 13ms 298ms 185us # Lock time 71s 0 …
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… – I’ll just analyze queries in the slow query log generated by our mysql build running with long_query_time=0, get the slowest ones and…/log/mysql/mysql-slow.log # Time: 090115 2:25:28 # User@Host: me[me] @ localhost [] # Thread_id: 3432 Schema: test # Query_time: 0.000695 Lock… for query optimization, is it? Well, I can still aggregate the slow query log with mk-log-parser and find routines that MySQL spends…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… just can assume the team had tried to get the most the given configuration and look …output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb_… innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 300 innodb_thread_concurrency = 0 …
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…mysql> insert into autoinc (j) values (‘node2′ ); Query OK, 1 row affected (0.00 sec) node2 mysql> insert into autoinc (j) values (‘node2′ ); Query…mysql> commit; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction node1 mysql…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…easily overload methods and get debugging and profiling tools,…tables do internal full table lock if auto_increment is…more in my Why MySQL Could be slow with Large Tables article…queries, especially if you see them in slow query log. If you have trouble understanding EXPLAIN or optimizing your queries…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… where a single connection sends two queries and gets two responses, with a response…slow-query-log (for example, none of the top 5 slow queries reported by mkqd appeared in the actual slow…self.result” # check lock file if [ -e "$TMP/$LOCKFILE" ]; then echo “$self: lock file $LOCKFILE already…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…. These are going to get more attention as people run…query-digest. Side note: bravo for Daniel figuring out how to make mk-query-digest parse 2GB of slow query… 3329398998 Schema: app_db # Query_time: 0.306486 Lock_time: 0.000000 Rows_…that’s where improvements to the MySQL source code are necessary. …
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH READ LOCK…undo size is not large enough snapshot will get invalidated and backup will be aborted. Sometimes…Copy data to backup. Normally you can skip slow query logs and error log while taking backup. …
