…_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX….2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30…_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been…
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
If you enable logging of all queries as “slow queries” using the patch or MySQL 5.1 you can get log file to grow huge. Same may happen with general log… on typical Linux systems – If you follow most simple process – delete log file you do not need and run “FLUSH LOGS” so file…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_64 x86_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (Tikanga) From…/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL… microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…log_slow_filter. log-slow-queries[=name] Log slow queries to this log file. Defaults logging to hostname-slow.log file. Must be enabled to activate other slow log…MySQL console wit SET or SET GLOBAL command. log_slow_filter=name Log only the queries…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… slow log any queries executed by the slave’s SQL thread. This patch allows you to change that behavior with the new parameter –log-slow-slave-statements. THE DETAILED INFORMATION ABOUT QUERY EXECUTION Each query can be executed in various ways… any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on other systems. Maciek…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… -9 is run. Our mysql db contains a mix of innodb and myism tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large…_length=2048 long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…by aggregating query log with mk-query-digest. When I filtered out only queries of … 10 libaio::??,os_aio_linux_collect,os_aio_linux_handle,fil_aio_…_index,btr_search_info_update_slow,btr_search_info_update,btr_…JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… microsecound in slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… log position you’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL…. Normally you can skip slow query logs and error log while taking backup. You also can skip most of binary logs – however if some of…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…as you can query temporary tables too: mysql> select sum(…like valgrind are too slow to run in production…
