I'm indexing [currently] about a couple gig of information or so.
What should I add to my MySQL config file to make it go faster? I've looked
through the old archives, but I can't find anything specific...
I know it's not what you mean but you could try sorting the ndict*
tables by word-crc
You can also take a look into MySQL documentation. Tuning to improve
MySQL speed is described well enough there.
I tried to find a guide for parameter tuning on the MySQL site and there
is quite a lot of info but it's difficult to decide what's relevant and
what's not, do you have any general
Joe Frost wrote:
You can also take a look into MySQL documentation. Tuning to improve
MySQL speed is described well enough there.
I tried to find a guide for parameter tuning on the MySQL site and there
is quite a lot of info but it's difficult to decide what's relevant and
what's not,
Currently my MySQL config looks something like:
---
[client]
port= 54000
[mysqld]
port= 54000
socket = /tmp/mysql.sock
log
-
Which, I feel, isn't as fast as it could be.
I'm using crc-multi to store stuff.
The box