… for the optimal production deployment you want two identical physical boxes with at least 4 NIC ports. Why 4? Two of…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… be made to display if you tag the Implied relationships box, but this generally only works if you have used the…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…, we recently deployed a pair on servers for backup purpose, boxes with 64 300GB SAS drives, 3 raid controllers and 192GB…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… differences between results we have rerun tests on several our boxes. You can find setup/config details at the very end… from the equation. We ran tests on Dell PowerEdge R720 box and varied cpu combinations with taskset. The following chart shows… the results difference. We then compared results across all 3 boxes to see if different hardware has any notable impact: Still…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql started PHP script Zend…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…-bound cases. For this test we used a PowerEdge R720 box with a fast PCI-e flash card as storage. By…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… understand from documentation TokuDB comes with good settings out-of-box, but I am ready to tune something if there are…
Comment: Percona Server for MySQL 5.5.30-30.2 now available
April 30, 2013 By 10 Comments
… => /lib64/libselinux.so.1 (0x0000003ad4c00000) This breaks out of the box compatibility with fedora 17 x86_64 if using the binary…
Comment: Is your MySQL buffer pool warm? Make it sweat!
April 25, 2013 By 6 Comments
… system, and gets around the IO issues on the server box. may help… may not… Peter C
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
Hi,Peter Boros Thanks for your good idea ! I have a security misgivings with use mysql -e,which need user and password because procedure box must be setted.
