… hundred dollars more per server just to avoid nightmare of scheduling learning cycles. I’m surprised it takes so many years… is going through the process. Second. Schedule it. Most systems would be much better with scheduled learning during the night or weekend… Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase innodb_write_io_threads to get more…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by…. INNODB USAGE The final part are the InnoDB usage statistics. MySQL currently allows you to see many per-session statistics for…_pages_distinct: 20 InnoDB_IO_r_ops is the counter for the number of page read operations scheduled. The acutal number of…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be …size becomes the limit rather than number of IOs it can handle. Imagine for example data archive…and why. A lot of pieces – filesystem, disk scheduling, database buffer management can be rather complex but…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…tables. This is of course something which is scheduled to be fixed before stable release but …applications if implemented well. It is too bad MySQL Users Conference only allowed 45 minutes for … also checked for CPU bound workload – with disk IO situation can be rather different. Looking at …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… contents of the Data dictionary to the mysql error log, which looks something like this: ===========================================… customer had a few hundred tables. I scheduled a time with the customer during off…dict/dict0dict.c: line 4883 So, the io-wait spike is explained by table statistics …
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… off power on SSD drive in the middle of tpcc-mysql run, just SSD power, not whole server. No wonder FlashCache… after restart FlashCache was able to attach previous cache, and MySQL was able to start and finish crash recovery. I am… change default IO scheduler from CFQ to Deadline. Seriously, it makes so much damage on performance on servers with IO intensive workloads, so…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…on backups It is a good idea to schedule both logical and binary backups. They each have…maximum rate the server allows, given it’s IO system It can typically execute a backup …weeklies, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… of Database Programming in digital formats for Kindle, iOS, and PDF at the publisher site: http://pragprog…. much computation load onto their database server. Their MySQL server became CPU-bound, while their multiple PHP …training/ for details on our training offerings and the schedule for upcoming …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… wrong. Q10: When Innodb decides to schedule sequential read-ahead, random read ahead ? HT: InnoDB schedules a sequential read-ahead when it…. I thought Innodb will make sure to schedule synchronous wait in front if read-ahead IO has not been started already. The… additional throughput? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… declared inside InnoDB 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query…these variables is indication of IO bound workload. Note however – IO requests submited by threads … state of Innodb main thread which controls scheduling of number of system operations – flushing dirty pages…
