Hello,
I have a website with a MySQL database and I have a table with ~2
millions row (usernames, filenames; ~120MB db data file and ~230MB db
index file) with I would like to search using the fulltext indeces.
Unfortunately the server get loaded pretty much. It always stays on
20 load average and often gets 50-60 load average.
I'm sure that this is because of slow mysql response (slow queries)
to the apache web server.
Can you give me some advice how to optimize the mysql server?
The server hardware is: 1GB RAM, 1.8GHz Celeron, 40GB HDD (currently
I have 512MB free memory)
Thanks,
Svilen Spasov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
