Backing up MySQL Database most people compress them – which can make a good sense in terms of backup and recovery speed as well… transfer default GZIP compression will not speed things up on the standard point to point 1Gbit network connection. If we try gzip -1….7 seconds which gives 105MB/sec read speed from archive media and 276MB/sec write speed to the hard drive – this means…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… interesting investigation of the fact read_buffer_size variable affects connection speed. This is not something you would expect right ? me too… use the buffer only once. What can be done to speed things up here ? Of course you can tune you malloc settings… quick. Also MySQL should get smarter in terms of which buffer size should be used, even for sake of speeding up the reads…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… lagging we can’t expect to get absolutely up to date data anyway. I’d like to …from query cache and there are multiple connection requesting the same item. What MySQL will do ? It will allow …results at faster than wire speed for 1Gb networks. Plus if we can get MySQL protocol to support such …
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…called “Query Cache” which is quite helpful for MySQL Performance optimization tasks but there are number … uses non-deterministic functions such as UUID(), RAND(), CONNECTION_ID() etc it will not be cached. …producing small result set will be offering best speed up. So when it is good idea to use…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… terms of size and spindle speed. I need to know how…up with the database. The first step is to find out what MySQL… | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | |…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…time name P cnf # name cmt sta Up Dn Up Dn Up Dn pau snt dst lcf bfa …important to understand that this tool only currently connections to a single node (by default, localhost). The…if multi-threaded replication could help improve replication speed at all. Conflct Replication conflicts, as described …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… have small number of connections all connections will be printed in transaction list, if you have large number of connections Innodb will only… each of connections for MySQL there will be ether not started state if there is no active Innodb transaction for this connection, or… index is hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash search. This section…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…, which showed MySQL 5.6.10 to be much slower than MySQL 5.5.30 even with only a single connection. I felt… connection I modified the queries to use ANSI JOIN syntax. No other changes to the queries were made. Test Environment The MySQL… speed is very consistent, just a few tenths of a second off per run. I then rebooted the machine and fired up…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Total | 23.59G … Locator Size Speed Form Factor Type Type Detail ========= ======== ================= …MySQL configurations, I didn’t try out different MySQL…back_log = 50 max_connections = 2500 max_connect_errors = 10 table_…incredible performance boost – up to 33x in…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…mysql> SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS WHERE USER=’#mysql_system#’\G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 2 CONNECTED…
