I need some help with improving INSERT performance. I am using JDBC. I have minimized my indices as much as I can, changed to use batching, and setup a thread pool for each transacted batch. Note that I am only using InnoDB.
Now I am wondering what can be tweaked in the server properties. Right now I have two log files, the log file size 512M and my buffer pool is 1.2G. 6 threads seems to work best for a single CPU. As an aside, even though I have minimized index usage as much as I can, I still notice that every subsequent set of inserts I do takes a little longer each time. For example, the fourth set of 1 million inserts takes at least twice as long as the first set of inserts. Do we have the ability to play with the Btree page depth or anything like that? TIA, R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
