… script gives below results for temp table , server has 4G ram, which almost uses, as many sites of both drupal and…/or max_heap_table_size to reduce the number of disk-based temporary tables Note! BLOB and TEXT columns are not… using these columns raising these values might not impact your ratio of on disk temp tables.
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… for write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes… same thing. PZ: First Indeed writes are slower with Flash disks compared to Reads because Flash requires “erase” cycle to replace… be running (monitoring, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql processes drops rapidly when you…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… 5150 @ 2.66GHz, 32GB RAM. There are 8 disks in RAID10(a mirror of 4+4 striped disks). Software It was used MySQL…, NOTPM Logging queries >1 SEC, NOTPM ratio 1 sec / no_logging Logging all queries, NOTPM Ratio all_logging / no_logging 1 9607…, NOTPM Logging queries > 1 sec, NOTPM Ratio no_logging / 1 sec_logging Logging all, NOTPM Ratio no_logging / all_logging 1 225…
Comment: Benchmarks of new innodb_flush_neighbor_pages
July 3, 2012 By 8 Comments
… writing in parellel instead of lazy writng to disk and set lower dirty ratio to start flushing, terminate worker flushing threads at… for ext4. If they made an SSD as fast as Ram or if one was to raid 10 a bunch of… even use any Ram and it would remove this problem? Including/improving some sort of cache to disk not ram for mysql like…
Comment: Why you should ignore MySQL's key cache hit ratio
March 1, 2010 By 28 Comments
… can either be in Cache or on disk. Now… Tune this server by allocating RAM that you have available for the key… go from poorly tuned to better tuned without affecting the ratio in a way that supports the standard argument. That said… “expensive operations” Key_reads, opened_tables, created_tmp_disk_tables more than the ratio of the “expensive operation” to the “cache hit…
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
…It uses %50 Cpu in average and just 700MB of ram. My server has 8GB and it has over 3GB… returning the cached results and do not touch the disk unnecessarily. I think the linux OS caches the innodb …_cache_limit = 1 M Current Query cache Memory fill ratio = 7.64 % Current query_cache_min_res_unit = 4 …
Comment: Why you should ignore MySQL's key cache hit ratio
March 1, 2010 By 28 Comments
… you substantiate that assertion more? In my experience, “tuning by ratio” leads to wildly stupid results that consume large amounts of… into the breeze: “I have 4GB of RAM and 1GB of indexes on disk, so 256MB of key cache might do OK…, so I’d say in 80% of cases, tuning by ratio is pure FAIL. Actually I’d say more than 80…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… now you can get a box with 128G of RAM within $15K. Keeping working set in memory is …they not only store the copy of data on the disk, wasting resources but their caches are also highly …implementations often report 90% cache hit ratio meaning 10 to 1 read ratio drop backs to one to one. This…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… 100% in RAM (even for Disk tables such MyISAM or Innodb) others keep database on SSD which has completely different ratio between CPU…
Comment: Adjusting Innodb for Memory resident workload
March 26, 2009 By 11 Comments
… ratio, so very heavy random I/O. Ability to make a 128GB RAM server and fit effectively database to memory so that disk…
