Craig, this is the right place, but performance is a pretty broad topic.
I personally highly recommend Jeremy Zawodny's book, 'High Performance
MySQL'. It's based on 4.1, so the info will be well suited to your
install (I don't know if it will be updated for 5 ... anyone?).
You can also glea
Hi All,
Hope this is the right list to post to, excuse if it is not ;-)
Server scenario:
Dedicated server running MySQL 4 and secondary process inserting data into
MySQL
How does one calculate what the values should be for the following areas in
the my.cfg file to give optimal performance:
hi everyone,
I've got a mysql server, a quad xeon 700MHz, with 8 gigs of ram, and a
raid 50 disk array running as two 50 GB partitions, shared over 8 15,000
RPM disks, on a hardware raid card, with 128Mb Cache.
Running RedHat Linux 7.2, with Ext3 FS, and Kernel 2.4.9-21 Enterprise
(SMP)
I'm try
I have developed a ftp searchengine, which uses a database for backend data
storage.
While mysql is indeed the fastest db for my needs, I wish to improve the
searchtime a bit further. A typical query would be
SELECT id, field FROM table WHERE field LIKE '%query%'
I understand that the use of
