… chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile… ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘/tmp… was done, I ran a quick Perl script on the vmstat and mysqladmin log files to grab out the disk activity and…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… fill up with logs. You can fix this by modifying shard-query/run_worker to contain the following: #!/bin/bash while [ 1… script will run one more more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. I have also provided a convenient script…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… storage engines or default paths): (garfield:~/work) % env VISUAL=/bin/cat mysqlbug | grep ‘Configure command’ Configure command: ./configure ‘–disable-… file scripts/mysqldumpslow.sh patching file sql-common/my_time.c patching file sql/filesort.cc patching file sql/log.cc patching file sql/log_…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…_flush_log_at_trx_commit=0, I ensured I was not benchmarking my disk. On the laptop, I ran the following script: #!/bin… $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep… of the Desktop. This script uses a PHP script, make_conn.php, to generate the idle connections. This script is the following: Before…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… data to backup. Normally you can skip slow query logs and error log while taking backup. You also can skip most of…=”master”, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart…_errors or sql_slave_skip_counter. Cloning master you’re starting from consistent copy. If you’re interested in ready script you…
Comment: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… on Flexviews. I’ll implement the following as an automated script. In the meantime, here is kind of a roadmap you…; And then delete the signal rows with the following: set sql_log_bin=0; delete from flexviews.mview_signal; Don’t do the…
