Active
Project:
Droptor
Version:
7.x-3.x-dev
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Unassigned
Reporter:
Created:
5 Sep 2011 at 20:11 UTC
Updated:
17 Sep 2011 at 10:32 UTC
Some ideas:
1. Use insert delayed
To increase performance for MyISAM tables, for both LOAD DATA INFILE and INSERT, enlarge the key cache by increasing the key_buffer_size system variable. See Section 7.9.2, “Tuning Server Parameters”.
2. Write memory logs to cache, then when the cache gets to 100, do a single line 100 insert. This reduces connection time.
3. Lock the table before the insert
Comments
Comment #1
vacilando commented#1 Insert delayed sounds interesting. Will it increase performance for InnoDB tables as well?
#2 This is a very good idea, IMO.
Comment #2
wim leersSubscribing.