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]