… 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… without swap file. If on the contrary you want to use as much memory as possible to get last bit of performance and…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… couple of percent. Some people try to solve it with disabling swap file but it can hurt another way – OS may kill MySQL… work quite well with swap disabled and there are other reasons against it. For some people having no swap works, though they usually… buffers, which may have other performance benefits as well. Tuning your VM to be less eager to swap things by echo 0…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… load data (especially if you disable unique key checks and foreign key…file in chunks as though it were many small files, which avoided splitting the file… pool and InnoDB essentially starts swapping between its buffer pool and the… server and see what the performance impact is, especially on other …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…and in an ascending order of the file address, then InnoDB schedules the read … the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here…performance tuning in heavily concurrent environments. Sets the max\ imum number of threads allowed inside InnoDB. Value 0 will disable…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…, which runs mysqlcheck, which can destroy performance. It can happen on a server …have to do this without death-by-swapping, which would be extremely slow on …on RW-latch at 0x2aaaae0b70b8 created in file btr0sea.c line 139 a writer (… B. The real solution is to disable this startup process. It’s not…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… much memory so it will swap badly until it runs out …also use similar technique with innodb_file_per_table. However you can’… variables but this will obviously disable password brute force protection. Mutex … heavily you can reduce system performance beyond being functional. General Overload …
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… from Ronald Bradford (here), I decide to verify and benchmark performance while varying the size of the sort_buffer. It is… to perform 12 queries like ‘select * from sorttest order by data limit 78000,1′ with, of course, the query cache disabled. I also verified that during the whole process, the computer never swapped and I pre-warmed the file cache before…
Comment: MySQL Performance on Memory Appliance
June 19, 2008 By 23 Comments
… After initially seeing terrible numbers, we disabled the key_buffer and saw a … high context switching and paging (not swap) activities. We are running multiple MySQL …single Violin with virtually the same performance. Details below: 03:00:01 PM…0 03:00:01 PM dentunusd file-sz inode-sz super-sz %super…
