View All Products
Compute
Storage
Networking
Databases
Services
Developer Tools
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ mysql performance
Log in to Ask a Question

mysql performance

performance

Hello

I host some databases on my linode 256 server. What happened is that one of my client's database grew a lot (its largest table has 150mb) and the performance is becoming far from acceptable.

I'm using mysql 4.0.21-7 on a debian [sarge] setup.

Do you people have any advice on how to improve this performance ? Do any of you recommend switching to postgresql ? Everything's written using php's PEAR::DB abstraction layer, so it won't be a problem

Thanks a lot for any advice

2 Replies

What are the current sizes of keybuffer and tablecache? Have you tried changing them? What is the memory usage like on your Linode - is there room for a really big key buffer?

I'm debugging the problem, I just found out my iorate (on /proc/iostatus) go as high as 6000 when I'm updating a large table on mysql … maybe there's something to remedy this ?

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct