… sure you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however… be crashing , failing to execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you could… MySQL process. You can also look at “Resident Memory” but I find it less helpful as it may down because of swapping…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… as /tmp partition is a common trick to improve the performance of on-disk temporary tables. Servers usually have less RAM… can go to swap, which would defeat the performance improvement as it uses disk I/O anyway. Ramfs will not swap, and also… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… can use result overload to make MySQL to consume so much memory so it will swap badly until it runs out of… appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization… system and wipe off both MySQL and OS caches which can cause other users queries to perform order of magnitude slower than…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… split. Q: How does latency and bandwidth affect performance? Is it practical to buildthe cluster over a … slave on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: I … the data set is very large? Can you swap in Binaries ? A: Check out Jay Janssen’s …
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…Bradford (here), I decide to verify and benchmark performance while varying the size of the sort_buffer…0 while [ "$NUMROW" -gt "$COUNT" ] do UUID=`uuidgen` mysql test -e “insert into sorttest value (‘$UUID’);” let… during the whole process, the computer never swapped and I pre-warmed the file cache …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… sometimes handy feature but it can be rather expensive from performance point of view. The nasty thing with counters as they… caches stuff and you can’t easily tell it to perform certain action (ie write back to the database) when object… insert into one and process and truncate another. MySQL offers atomic RENAME TABLE call which can be used to swap two tables.
Comment: MySQL Partitioning - can save you or kill you
June 29, 2012 By 45 Comments
… plan for the query, but it _may_ not. > This base mysql version (5.1.56) supports partitions, but does not support… and the app is CPU-intensive. Do not allow swapping; that will kill MySQL performance. “50 users” — a useless metric without knowing what…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… you may have is making your OS happy and avoiding swapping out MySQL Process or other important processes to make room for… to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning your VM to be less eager to swap things by echo 0…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock and O_DIRECT… in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent… you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them…
