Hi list. I have a server that is having a little MySQL load issue. I have done many hours of reading and can't quite get this worked out. I am asking for your help please. The server is to be a dedicated MySQL server only. The following is the current setup but currently is doing some apache aswell.( around 1gb total data out per day ) I would like the advice on setting this up purely for a dedicated MySQL server. There is a mix of both MyISAM and INNODB stuff. I am told by the programmers that they use the MyISAM stuff cause of the indexing power.:S Dont need transactions. My questions are: 1. Is this hardware going to be enough ? 2. What sort of gain is to be had if I linux software raid-1 the 2 x sata 150 drives ?? 3. If this is sufficient hardware then what can I do to improve my.cnf and the overall server performance. ????
The current live status of the server can be viewed at http://sql.kdwshosting.com/sql-stat.php DETAILS ========== The server is a : P4 3.0gb HT, 2gb dual channel corsair ram, sata150 80gb drives x 2. ( not raid ) OS: Slackware 10.0 with 2.6.9smp and most server progs compiled from source with: ---------------------------------------------------------------------- ARCH="i686" MYIN=lun SLKCFLAGS="-march=pentium4 -O3 -pipe -fomit-frame-pointer" ## CFLAGS we get these from the above settings CFLAGS="$SLKCFLAGS" CHOST="i686-pc-linux-gnu" #CXX=gcc ## CXXFLAGS same as the CFLAGS CXXFLAGS="$SLKCFLAGS" ----------------------------------------------------------------------- ---------------/etc/my.cnf-------------- # Example mysql config file for very large systems. # # This is for large system with memory of 1G-2G where the system runs # mainly MySQL. # The following options will be passed to all MySQL clients [client] port = 3306 socket = /var/run/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] skip-locking max_connections = 500 key_buffer = 512M myisam_sort_buffer_size = 64M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 3M table_cache = 128 thread_cache_size = 128 wait_timeout = 14400 connect_timeout = 10 max_allowed_packet = 16M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 thread_concurrency = 4 #log = /var/log/mysql/mysql.log ----------------------------------------------------------------- /usr/bin/top output is : ----------------------------------------------------------------------- top - 22:23:46 up 18 days, 7:30, 3 users, load average: 0.00, 0.00, 0.00 Tasks: 221 total, 1 running, 220 sleeping, 0 stopped, 0 zombie Cpu0 : 0.3% us, 0.3% sy, 0.0% ni, 99.3% id, 0.0% wa, 0.0% hi, 0.0% si Cpu1 : 0.0% us, 0.3% sy, 0.0% ni, 99.7% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 2075736k total, 2028972k used, 46764k free, 69268k buffers Swap: 2008116k total, 0k used, 2008116k free, 1533628k cached --------------------------------------------------------- ---- Regards Mick Pollard ( lunix ) ------------------------------------------------ BOFH Excuse of the day: Nonfatal Hardware Timeout Warning -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
