…_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 … smaller sort buffer because allocating it will likely be faster. query_cache_size = 0M – query cache… faster but it is surely better for operations. innodb_log_file_size = 1600M – another Benchmark optimization…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…object will be free already. OS Waits are relatively slow, and if you get tens of thousands of …process id which may be helpful if you would like to use gdb to connect to running mysqld …o request or if it is executing certain operation. Number of pending operation is shown for each of helper threads …
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
… good price/performance value while if you would like to go significantly higher like 32 cores and 128G of RAM it is…, personally funding projects people rarely like to waste more money until projects takes off. As it gets slow one can spend say… risks – hardware upgrade is straightforward and can be done by operations and data center stuff so developers can keep developing new…
Post: My "hot" list for next InnoDB features
March 30, 2009 By 18 Comments
… customer systems I have wish-list of features I would like to see soon: Fast recovery. Both recovery after crash and… hours to complete, so basically it adds several hours for operations team to complete task which requires restart of slave Copy…, when InnoDB takes probes during opening table, as it is slow operation. See also http://www.mysqlperformanceblog.com/2006/11/21/opening…
Post: Compression for InnoDB backup
March 16, 2009 By 19 Comments
… compress it I noticed that gzip is unacceptable slow for both compression and decompression operations. Actually Peter wrote about it some time… speedup operation, and another my requirement was the ability to work with stdin / stdout, so I could do scripting something like: innobackupex… is even faster in decompression than qpress, but I would like to see parallel version. There is the patch for it…
Post: Living with backups
November 6, 2008 By 28 Comments
… needs to wait much longer until disk operations are scheduled and executed which converts into … with random information additional I/O occur slowing everything down even further. What does it … } … my $sth= $dbh->prepare(‘SHOW GLOBAL STATUS LIKE “Threads_connected”‘); … if ($$row[1] < 10) { $is…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… mutex on bufferpool would be held for the entire operation and then two scans of the LRU list …performance over a period of time. I would also like to point out one thing about benchmarks – we have…0. Then for analysis purposes the queries in the slow log were grouped by their timestamp, giving us a…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…query-digest (Percona Server marks Slave Thread in slow query log so it is easy to …which causes replication lag. Same may happen with operating system and other system software involved. In could…on devices themselves now, so watch for things like firmware updates bios updates etc, which even though…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…The process should end with no errors and message like this one: make[1]: Leaving directory `/home/macko…file is just a manual. For the following operations you will need to become root user, unless… min_examined_row_limit AND log_slow_filter. log-slow-queries[=name] Log slow queries to this log file….
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… be crashing , failing to execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you could also… seriously you can also add the size of Operation System cache you would like MySQL to use for your table. Take this number add to it number of memory Operation System and…
