… explain their content. Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE INDEX_ID = 1679; +———-+—–+———-+ …index_id> 4. Load dumps of the dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… max_allowed_packet (33554432). MasterB: masterB> mysqlbinlog data/mysql-bin.000004 | grep block_len #Begin_load_query: file_id: 1 block_len: 33555308… example is best than words. These are the new values: max_allowed_packet = 32M read_buffer_size = 16M We run the LOAD DATA INFILE…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… ways and types of aggregation (by-ad by-day, for example). Sometimes I ask a customer “what kinds of queries do… it write out a CSV file and import that with LOAD DATA INFILE. Keep those big fat log files out of the… MySQL 5.0 and earlier, doing the work on a slave, then piping the results back up to the master with LOAD DATA INFILE…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…loaded data longer rows are faster. Indexes The more indexes you have the longer load would take. Details depend on storage engines, for example…ways to load data in MySQL you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA …
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… we can run out of space. Let’s see one example. We’re running a typical master-slave replication with ROW… just recycle old connections. The application starts to load data into the database with “LOAD DATA INFILE“. After some minutes the server runs out of… ML* files? When you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… need to download Percona Data Recovery Tool and compile all the tools using the “make” command. In this example I’m going… the data you need to recover and save it in another file. This is the output of our example: ~/data-recovery# cat data/salaries… With the data in our hands the last step is to import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… 3 million “words” by duplicating the entire set multiple times. mysql> load data infile ‘/tmp/words’ into table words (chars); Query OK, 6033 rows…’ll operate in only one dimension for the first example, just like the MySQL client. This will be a linear operation because… that this data set can achieve with my method. Likely current network technologies can not support such a degree. mysql> select min…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is… TABLE, for example). The benefit is that you have another server with all the same data, up and …-contents.txt’; I loaded this file into a table on my laptop with LOAD DATA INFILE and kept it for later…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… which I do not yet know answer for – for example will LOAD DATA INFILE be optimized same way as for MyISAM tables by separate… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see… MySQL 5.1 It also should be possible to start unlocking rows if they do not match where clause (think for example…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… example. I used default tuning, out of the box, for all three databases. The first thing I tried doing was loading the data…. I used LOAD DATA INFILE instead (MonetDB’s version of that is COPY INTO). This is the only way to get data into Infobright… plugged into MySQL. It’s a complete server with a different optimizer, etc. This point was hammered home during the LOAD DATA INFILE, when…
