[nzlug] MySQL performance

[Robin Sheat]

On Friday 06 October 2006 13:15, Daniel Pittman wrote:
> If you have any indexing on the data, turn it off during the insert
> process.  IIRC there are some MySQL specific commands to suspend index
> updates, but simply removing the index and creating it at the end should
> help.
Now that is a good idea, it does indeed have a couple of indicies on it.

> What sort of wait -- I/O wait, I presume?
I'm not sure. I assume so, but the disk doesn't appear to be doing much.

> Look at bumping up the {key,sort,read,read_rnd}_buffer_size settings;
> if you are using innodb look at the innodb_buffer_pool_size as well.
OK.

> Really?  Have you measured your I/O performance and verified that is
> actually the case?
I haven't stress-tested it, no. I'm just basing that on the specifications.

> The MySQL documentation has some extra information on performance
> tuning.  If you have not read that yet I suggest you do.
Cheers, I'll take a look at that. It's about time I learnt it. I've been doing 
a fair bit of DB work lately (although I prefer postgresql usually)

-- 
Robin <robin at kallisti.net.nz> JabberID: <eythian at jabber.kallisti.net.nz>

Hostes alienigeni me abduxerunt. Qui annus est?

PGP Key 0xA99CEB6D = 5957 6D23 8B16 EFAB FEF8  7175 14D3 6485 A99C EB6D
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 191 bytes
Desc: not available
Url : http://www.linux.net.nz/pipermail/nzlug/attachments/20061006/8bd267a8/attachment.pgp