Best Configuratuion ( my.cnf ) for a DB with many users and large columns ( Images in BLOB Columns ) on a Website
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best Configuratuion ( my.cnf ) for a DB with many users and large columns ( Images in BLOB Columns ) on a Website]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]