How do you optimize a MySQL database for writes?

Re:How do you optimize a MySQL database for writes? by carbocation on Tuesday December 21, 2010 @05:09PM (#2029591)

What you say is true; indexing does not make writes faster. In fact, it makes writing to the DB slower, which is why I suggested to turn it off. Now, there may be extenuating circumstances (e.g., you also read from this DB) which make this decision more difficult.

[ Parent | on HN ]

Re:How do you optimize a MySQL database for writes? by jongs on Tuesday December 21, 2010 @06:48PM (#2029900)

Why would it make it slower?

[ Parent | on HN ]

Re:How do you optimize a MySQL database for writes? by carbocation on Tuesday December 21, 2010 @06:53PM (#2029913)

Instead of just inserting a record, it now has to do something else, too (update the index).

Try taking a look at http://kevin.vanzonneveld.net/techblog/article/improve_mysql... , which suggests some things you can try. This might be a question better suited for StackOverflow, by the way.

[ Parent | on HN ]

Re:How do you optimize a MySQL database for writes? by jongs on Tuesday December 21, 2010 @07:16PM (#2029970)

thanks

[ Parent | on HN ]