Hello. A lot of depends on the type of your queries. Find out which of them make the maximum load on the server and then tune your configuration.
ESV Media GmbH wrote: > Hey, > > what do you think is the best configuration ( my.cnf ) for running a > database, > which many users access at the same time ( Website - Portal ). > We´ve also saved our Pictures ( nearly 3.500 rows ) in our database. > Every coloumn is round about 60-70 Kbyte, so i had to use mediumblob > columns. > There are 116 Tables and we have a primary key and an index on every > table and use them > in ( i hope so ;-) ) every statement. > Here i´ve a my.cnf from another website. > Would that be an good configuration ? > Thanks in advance.... > > Marco > > My.cnf : > > # The MySQL server > [mysqld] > port = 3307 > socket = /tmp/mysql.sock > skip-locking > key_buffer_size = 256M > max_allowed_packet = 1M > table_cache = 500 > sort_buffer_size = 24M > net_buffer_length = 8K > read_buffer_size = 1M > read_rnd_buffer_size = 256K > myisam_sort_buffer_size = 24M > record_buffer=1M > log-slow-queries > long_query_time = 3 > query_cache_size = 512M > max_connections = 500 > join_buffer_size = 16M > > [mysqldump] > quick > max_allowed_packet = 16M > > [mysql] > no-auto-rehash > # Remove the next comment character if you are not familiar with SQL > #safe-updates > > [isamchk] > key_buffer = 25M > sort_buffer_size = 25M > read_buffer = 6M > write_buffer = 6M > > [myisamchk] > key_buffer = 25M > sort_buffer_size = 25M > read_buffer = 6M > write_buffer = 6M > > [mysqlhotcopy] > interactive-timeout > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
