i have a database accessed by 100 machines at the same time, inserting a record every second.
How best can i optimize my buffer size and cache, knowing that am running the database on a win2k server machine P3 1Ghz, 512 Ram.?
Another thing is that my engine is live 24/7 (MySQL 3.23.24- beta).
How best can i optimize my buffer size and cache, knowing that am running the database on a win2k server machine P3 1Ghz, 512 Ram.?
Another thing is that my engine is live 24/7 (MySQL 3.23.24- beta).