My application needs to insert between 200-500k rows about once a day...
When using MyISAM tables I determined the best way to get this done (while
still allowing users to perform select statements from the table) was to use
mysqlimport with --low-priority. This way all the inserts get bundled up
into large groups, and the low-proriorty allows select statements to
continue. However I switched the table type to Innodb now and I am not sure
what the best way to insert these rows would be. There is:
a) continue using mysqlimport (without low-priority??)... the question about
this is will mysqlimport group the inserts into one large begin/commit
block, or will each insert have its own block?
b) create the begin/insert..../commit statements myself
What way would be the fastest and least abrasive on the server?
Another question I have is reguarding memory usage... Will innobase use any
of the key-buffer memory Mysql is using for MyISAM tables or is the only
memory innobase uses defined with innodb_buffer_pool_size?
Thanks!!
ryan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
