* Zoong PHAM <[EMAIL PROTECTED]> [2006-09-08 18:04]: > On Thursday, 7 September 2006 at 17:03:55 +0200, Henning Brauer wrote: > > > > as said before, our mysqlds on sparc64, mp- & up-i386, and sparc are > > very stable; some see more than 400 queries/s sometimes. > > Do you mind to share your /etc/sysctl.conf > and /etc/my.cnf ?
we just run with increaeed maxfiles (kern.maxfiles=4096). the mysql config mysqld section: [mysqld] port = 3306 socket = /var/run/mysql/mysql.sock skip-locking key_buffer = 256M max_allowed_packet = 1M table_cache = 256 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size= 16M thread_concurrency = 8 log-bin server-id = 1 skip-innodb open_files_limit=2048 max_connections = 500 -- Henning Brauer, [EMAIL PROTECTED], [EMAIL PROTECTED] BS Web Services, http://bsws.de Full-Service ISP - Secure Hosting, Mail and DNS Services Dedicated Servers, Rootservers, Application Hosting - Hamburg & Amsterdam
