…to add one row to your my.ini file. # =0 is traditional lock mode == > …what it do innodb_autoinc_lock_mode=0 2. restart mysql server now is working perfectly id – is primary key name – is unique varchar insert into tab (name) values (‘Peter‘),(‘Oto…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…This has a lot of costs. To name a few: the big LOAD DATA… file mentioned in LOAD DATA INFILE is /tmp/my-fifo, not infile.txt! After …how the curves are roughly logarithmic, which is what you should expect for B-Tree …speculate that this is the undo log entries being written to disk. (Peter arrived at…
Comment: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… Peter, I am new to MySQL optimization, but I ran into a problem which seems very similar to what you were benchmarking. My query is almost exactly like yours: SELECT id, name FROM users WHERE id IN (10000126213392676,206123495,10320001228994311,100001241345384504,10000176754237888,100002163455062416,1000017033535841276,1); where users table is 300 000 entries. id is…
