…my.cnf, so you can store host, user, and password. Here’s an example of running it with verbose output: $ full-slow-log… Setting slow_query_log_file=mysql-slow.log-full-20121122112413 Setting slow_query_log=1 Flushing slow query log Sleeping 5 seconds… done. Restoring slow_query_log_file=mysql-slow…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… learned are priceless. My old slow query log was filled with thousands of unsolvable mysteries every day and the slow query time was only set… does in the my.cnf, I have it set to 3 seconds and only find that just around 100-200 queries a day… is slow. This can seriously impair your performance! My only wishes for mysql would be that they would allow you to log queries…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… than my.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without… the report to the client After the slow query log analysis is done, I format all my analysis for sending, add in things…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… can replay queries from tcpdump or slow query logs. With this tool you can measure how a database upgrade, change on my.cnf or schema… to meassure the impact of my.cnf changes replaying a slow query log. The service starts with an empty my.cnf configuration so all parameters are… we see that 324 queries returned different row numbers from 429467 queries in total. Let’s modify the my.cnf to see if we…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set…=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…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…_query_time AND min_examined_row_limit AND 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 options. This is the most important one as it enables the logging. If you don’t specify it in my.cnf…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… performance. Hardware: 32 GB – RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character…/sys/5.5.8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M…/sys/5.5.8 tmpdir=/home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation… query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time… is interesting though slow query log remained enabled – probably it caused so little overhead because there were no slow queries it just was left…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… at this question. “I have a query I know is slow and is a problem for my application. I have profiled it with… not a cause) relationship between the counter events and the query‘s execution time. Alas, that correlation fools us into thinking… shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems so definite, mathematical…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
… table. Mysql configuration is as follows::: [root@crm ~]$ vi /etc/my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql… innodb_thread_concurrency=8 My Problem is that, day by day i see that the number of slow queries is increasing on. mysql… sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457 Flush tables: 1 Open tables: 64 Queries per second avg: 1.615 ————– Please…
