…. In the function is_slave() the test for an output to a tmpfile, not for the content “Slave_SQL_Running: Yes” is… later the test of “Slave_SQL_Running: Yes” fails, because the server is not running as a slave. So the 2nd start…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
… new Fusion-io ioDrive2 Duo card. So I decided to run the same series of tests I did for other Flash… RAID-0 over two drives. I should note that to run this card you need to have an external power, by… stable performance results comparing to previous generation ioDrive. Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… that both do not fully reflect my needs when I run benchmarks. Uniform is stupidly simple: for a table with 1… distribution on graphs, I took tables with 1mln rows and run row lookup 1 million times. There are histograms on how… sounds interesting. I am going to run couple incoming benchmarks with this distribution. Follow @VadimTk !function(d,s,id){var js,fjs…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
… behind.” Yes, I agree the command will take a long time to run at the source and it’s probably a good… chunks of data in the slave(s) first and then run it on master (BEWARE: you should make sure to delete…’ does not exist in any of the slaves when you run this on master LOAD DATA INFILE ‘/tmp/data.out’ INTO…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to …
Post: Testing Virident FlashMAX 1400
May 4, 2012 By 3 Comments
I still continue to run benchmarks of different SSD cards. This time I show numbers …-io ioDrive Intel 520 STEC MACH16 Samsung 830 Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… does it affect MySQL performance, and I am going to run some MySQL workloads on these cards to understand it better… talk – you are welcome to join the webinar. Follow @VadimTk !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
…_emp_attendance_register.jButton4ActionPerformed(rep_emp_attendance_register.java:311) at biopayroll.rep_emp_attendance_register.access$300(rep_emp_attendance_register.java:33…:101) at java.awt.EventQueue$3.run(EventQueue.java:666) at java.awt.EventQueue$3.run(EventQueue.java:664) at java.security…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…_log_at_trx_commit=1. I would also not recommend running on EBS with innodb_flush_log_at_trx_commit=1…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…’d like to note that this experiment isn’t really running the iiBench problem. The point of iiBench problem is to…
