…safe bet that MySQL is up and running. That said, there are plenty of other MySQL…file descriptor” errors. I was able to get the server up with –skip-grant-tables and insert a few rows into an InnoDB table…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers without putting it into the binary… mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile.txt’ into table load…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL …table data ether in storage engine caches or in OS cache. You can save these into .sql file and use –init-file…returning error to others) and gradually increase the load as server warms up. This may sound …
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… load the 4 million rows with LOAD DATA INFILE: MasterA (test) > LOAD DATA INFILE ‘/tmp/data’ INTO TABLE…binary logs of both masters. MasterA: masterA> mysqlbinlog data/mysql-bin.000004 | grep block_len #Begin_load_query: file… than the safe value. Then, MasterA tries to read again the binary log from…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… with caution. Note disabling binary logs is not enough to… replication. So what are safe workarounds if you’re using …LOAD DATA INFILE ‘/tmp/tbl1.txt’ INTO TABLE tbl2; instead of: INSERT INTO tbl2 SELECT * from tbl1; INSERT … INTO…file after it is loaded back (it has to be done outside of MySQL…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…MySQL AB has even adopted it into the official database distribution starting 5.1.21 release. Below you will find the files…tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql‘ ‘–with-unix-socket-path=/var/lib/mysql/mysql…binary, which can be safely done even with MySQL…load…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql…a patched binary, we can use MySQL Proxy… the greatest load on the server…table. Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken into…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…file system Why snapshot based MySQL… safe and …run into …load it, which is done by running modprobe dm-snapshot 3) Now you have created logical volume and can unlock the tables…binary log position which is done by running SHOW MASTER STATUS – This is binary log position you’ll need to point your MySQL…
Post: Living with backups
November 6, 2008 By 28 Comments
… that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways… more sphisticated or include things like processlist information, CPU load avergages, I/O load, etc. In this case tar is actually launched…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…load. Idle connections for example will consume significantly less memory than connections doing work with huge temporary tables…tables but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary… the safe side, having…will get into …
