…level master, you leave all filters disabled; on the relay master you … eye on to prevent a problem before it occurs. For example,… that it’s starting to swap, that might indicate that something is…Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… you should have swap file enabled or disable it ? I’ve seen production successfully running on boxes both with and without swap file so it… behind disabling 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… you keep swap disabled you can run into another problems. A lot of code in the kernel assumes there is a swap space and…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… disable unique key checks and foreign key checks), I recommended against this. There are several problems…single file in chunks as though it were many small files, which avoided splitting the file and…the buffer pool and InnoDB essentially starts swapping between its buffer pool and the tablespace …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…in an ascending order of the file address, then InnoDB schedules the … kernel can decide (incorrectly) to swap out MySQL. There are two solutions… STATUS), you can try to disable thread throttling completely by setting the…your thrashing problem. PZ: Values 1,2 may solve your thrashing problem but …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…so much memory so it will swap badly until it runs out …sizes, so this is mainly the problem for smaller servers. Table Cache Merge Tables… also use similar technique with innodb_file_per_table. However you can’…errors variables but this will obviously disable password brute force protection. Mutex …
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… buffer that is allocated every time it is needed. The problem with the sort buffer comes from the way Linux allocates… query cache disabled. I also verified that during the whole process, the computer never swapped and I pre-warmed the file cache before…
