By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,982 Members | 1,738 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,982 IT Pros & Developers. It's quick & easy.

How to optimize a big database with slow writes?

P: 1
I'd like to improve the speed of our database writes. They have slown down as our database has gotten larger.

What solutions are out there to improve performance of a growing database?
Apr 5 '12 #1
Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,364
I don't know if mysql supports it but you could partition the tables. One thing you could do is upgrade the hardware but that will cost money. You should delete any unnecessary indexes. And if push comes to shove, archive some of the older data.
Apr 6 '12 #2

Expert 100+
P: 1,035
I don't know if mysql supports it but you could partition the tables
see: http://dev.mysql.com/doc/refman/5.5/...titioning.html

so, it does support partitioning. ;)
Apr 6 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.