… should have swap file enabled or disable it ? I’ve seen production successfully running on boxes both with and without swap file so it… swap is what there is nothing you want to swap out on such box anyway and if you disable swap file kernel will not swap… to have slowdown caused by swapping activities in case memory overcommit occurs you may be better off without swap file. If on the contrary…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…possible. Gathering information about the server I start off with these commands: date uname -a cat /etc…be: is the disk saturated? Is the machine swapping actively? (This is more important than whether it…/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… ’263413′ ‘Created_tmp_disk_tables’, ’0′ ‘Created_tmp_files‘, ’4001′ ‘Created_tmp_tables’, ’669137′ ‘Delayed_errors’, …0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running’, ‘OFF‘ ‘Slow_launch_threads’, ’0′ ‘Slow_queries’, ‘…, 882264k in_d, 96252k in_c Swap: 4194224k av, 553604k used, 3640620k free …
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… swap partition on a production machine MySQL or not. I don’t make a dedicated partition though, I just make a file on disk. As long as there is plenty of memory in the system, it shouldn’t dig into swap unless… get caught with no memory or swap and have the dreaded OOM killer start killing off things. Just make sure your swapiness…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… accessed, and in an ascending order of the file address, then InnoDB schedules the read of all …system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock … in 5.1, to implement XA, and switching off the XA will not remove that serialization. MySQL’…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… MySQL to consume so much memory so it will swap badly until it runs out of space and gets… tables. You can also use similar technique with innodb_file_per_table. However you can’t control growth of… because they would both overload IO system and wipe off both MySQL and OS caches which can cause other…
