Geia sou Giwrgo ;-) Hello George, May i suggest a site with usefull information on how to optimise MySQL's several issues
http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html there are many pages there, you can navigate and discover many things, u couldn't think before. Good luck, John Galanopoulos -----Original Message----- From: George I. Develekos [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 10:30 AM To: [EMAIL PROTECTED] Subject: Tuning advice, please Hi to all from a novice, We run a database with roughly 200 tables and a total of 10,000 rows, on Solaris, 1G RAM, 440MHz CPU, about 300 CPU-intensive queries per hour (some math calculations are carried out with each query) all from a web-server via JDBC. Since the database is really small compared to the RAM, what settings would you recommend to ensure optimal performance? Thanks in advance, GID --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
