Re: UdmSearch: Optimal MySQL settings?
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 order (column 2). This took my search times down from 3 minutes to about 2 seconds. I wrote a script to automate this process, it's on the UDMSearch website now. Make sure you back up your index data before running the script though, just in case... Joe __ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]
Re: UdmSearch: Optimal MySQL settings?
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 tips based on experience? Joe __ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]
Re: UdmSearch: Optimal MySQL settings?
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, do you have any general tips based on experience? I tried to change different buffers size. Changing key_buffer helps best of all. When changing other buffers I couldn't see any results. Take also a look on how to optimize MySQL at compile time. It should definitly help. New things like MERGE tables and RAID I didn't test. When MySQL works over the top he can, cosider to sort *dict* tables in word order. __ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]
UdmSearch: Optimal MySQL settings?
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 is bleedingly fast. [dual 450 Sparc w/2G ram and 2G swap] It has 70G hdd or so available. The front-end is PHP. 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... Thanks, Gary (-; __ If you want to unsubscribe send "unsubscribe udmsearch" to [EMAIL PROTECTED]