Hi Mike, Thanks for the reply. 1. Currently the hardware is P4 2.8 on Slackware 12 with 1GB of DDR Memory (we plan to upgrade it) 2. The table type is MyISAM 3. There is no slow query, because all of the queries are a simple type 4. The table's size is increasing dynamically with at least 10 thousands new records / minute 5. Here is the current my.cnf .... key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 max_connections = 1000 query_cache_limit = 1M query_cache_size = 16M tmp_table_size = 64M max_heap_table_size = 32M log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 2 log-queries-not-using-indexes log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [isamchk] key_buffer = 16M
TIA Regards, Willy On Sat, 2008-07-19 at 15:45 -0500, mos wrote: > At 12:11 PM 7/19/2008, sangprabv wrote: > >Hi, > >I have situation where a MySQL server processes about 10-20 thousands > >requests per minute. I need suggestions from you for tuning up this > >server to get optimized setting. TIA > > > > > >Willy > > Willy, > You will need post more information: > > 1) What type of hardware are you running this on? (OS, Drives, Memory etc.) > 2) What table engine are you using (MyISAM or InnoDb?) > 3) What do the slow queries look like? Updates? Table joins? Inserts? > Simple selects? > 4) How large are the tables? > 5) What does your My.Cnf file look like? > > Mike > > -- ----------------------------------------------------------- SMS SERVER, SMS BULK, SMS PREMIUM, WEB DESIGN, NETWORKING Contact [EMAIL PROTECTED], 62 811 923 464, 62 21 944 8282 4 http://www.binbit.co.id -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]