… reasonable amount of connections but yet MySQL takes much more memory than you would expect, causing swapping or other problems. This simple… uses and for which purposes it is allocated. Reducing various per connection variables is how you can test it, though it does not… no control of how many tables application can create it does not really allows to restrict memory usage. For Permanent tables it…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been using before does not… not enough. You also need to perform stress testing to ensure both MySQL does not…. Swapping master. Finally as you have your slave running on new MySQL …
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
…back you just swap binaries to the old version. I think it was great. In MySQL 4….use that RPM and only upgrade it to something else if you need it for any reason. And this path does not…uninstall script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after …
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… many cases you can use result overload to make MySQL to consume so much memory so it will swap badly until it runs… few connections which use appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization control you can simply run heavy queries to get MySQL Server barely functional…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… swap file kernel will not swap and possibly will be able to manage memory smarter knowing it does not need to look for pages to swap out or balance memory for reducing a cache or swapping something out… behavior and swap buffer space out even with /proc/sys/vm/swappiness =0. You can lock MySQL in memory by using –memlock option…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… you are using LVM, you want to make sure it does not introduce misalignment. On the other hand it can be used to fix… 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 1738 145649 1155959808 83 Linux Partition 3 does not end on… 82 Linux swap / Solaris Partition 2 does not end on cylinder boundary. /dev/sda3 27920384 2339839999 1155959808 83 Linux Partition 3 does not end on…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… keeping in touch with what the lead consultant does. We want two sets of eyes on things …s using swap.) There are a lot of combinations of possible things you can see here, so I will not … every query.) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… data we can comfortably put in MySQL Instance without getting in too much …few rows to show search results which does not require too much IO capacity or … this makes it very easy to use LVM for backups while assuming you …) – you do not want your database box to swap actively – if it does your’re …
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
… MySQL starting to swap aggressively. This is where connection pooling would be extremely helpful but with default Processed based PHP installations it does not… have read-only page and everything on your site uses same charset and does not use per session variables in some tricky way it…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…_size and MySQL could crash or go swapping. Second – table will be locked while repair is going. If this is frequently used table… rename them back to MySQL database directory. This way accesses to non-checked tables fail with table does not exist error rather than wait forever. Hidden corruptions. If could be bad memory OS or MySQL bugs but…
