Speed up MySQL for inserts (for testing purposes)
Posted
by Alex N
on Server Fault
See other posts from Server Fault
or by Alex N
Published on 2010-06-08T03:53:04Z
Indexed on
2010/06/08
4:02 UTC
Read the original article
Hit count: 131
mysql
|optimization
I have a bit of software that needs to do a lot of INSERTs. In production environment there'll be some serious tweaking and testing and stuff like that, but now when I need to test it I'd like to speed up inserts as much as possible. Hence my question - is there a way to tweak mysql such that it doesn't do much disk I/O but keeps everything in RAM and syncs with disk rarely(like once n-seconds say?)
© Server Fault or respective owner