… example how compression in InnoDB plugin could be useful for large warehousing tasks. One of our clients had really many problems… of conversion we’ve got 58Gb data file and 30% drop in our I/O load. This was related to the fact… surprising: Only 5Gb data file (from 60Gb) ~5% I/O load according to iostat (from 99%) ~5% CPU load according to top (from…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log… minutes of recovery time – instead you would need to apply load which is typical for your application, crash MySQL in the… to consider – how large log files do you need at all ? You could run benchmark with 1GB log files and 2GB and see…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… greater than 0, because otherwise you can have a really large log file generated. Another thing that we normally do is set…: Thu Dec 29 07:09:32 2011 # Hostname: somehost.net # Files: slow-query.log.1 # Overall: 20.08k total, 167 unique… run time which typically (not always) shows queries causing highest load on the server. As we can see here the one…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
July 25, 2008 By 29 Comments
… your test, do you have recommendation or method of efficiently loading very large file? BTW – I am NOT heavy DB programmer and… LOAD command to accomplish this but in some occasion , the LOAD command takes longer than 1 min. When this happened, the following LOAD file…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
… that there was an fsync() call when extending the data file, so I tried setting a higher innodb-autoextend-increment and… with MySQL, probably due to not writing and syncing FRM files. If I run the same program with libeatmydata, it only… it is clear that loading large amounts of DDL could be a lot faster than it is currently (although loading the data into…
Comment: SysBench - benchmark tool
March 30, 2011 By 20 Comments
… work loads and threads but the oltp tests only creates on table file which tests only performance work load of one single large file with… picture of real mysql performance with many tables and .ibd files as this seems to be more realistic. I am testing…
Comment: SysBench - benchmark tool
August 18, 2006 By 20 Comments
… work loads and threads but the oltp tests only creates on table file which tests only performance work load of one single large file with… picture of real mysql performance with many tables and .ibd files as this seems to be more realistic. I am testing…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
… world when we have significant variance in the load and many things can be happening concurrently. It …localhost msb_ps_5_5_15]# time mysqldump –defaults-file=my.sandbox.cnf test md_cache_test_big > /… gives about 330 req/sec and mysqldump for large table completes in about 95 seconds. If we …
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
October 2, 2008 By 29 Comments
What’s the best way to load lots of large and small files for full text indexing? Which database engine is best suited for FTI? of large files?
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly… degradation and you will have to deal with very large files on high loaded servers. general_log variable is dynamic so a solution…
