please check the my.cnf parameters with recommended values given in my_huge.cnf file in support files. to my knowledge For 2 GB RAM values you set are very high. I think system is going for heavy swapping that might be the reason it is going very slowly.
Anil -----Original Message----- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 12:11 AM To: Anil Doppalapudi Cc: [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks Anil Doppalapudi wrote: >it is not normal. i have restored 90 GB database in 2 days on dell server >with 2 GB RAM. >Are you able to connect to mysql. if so at mysql prompt type the below >command and check what processes are running > >mysql>show processlist; > >if any insert statements are running then restoration process is going on >then check your my.cnf parameters. > > > This is a dell with 2 gig of ram set-variable= key_buffer_size=1500M set-variable=join_buffer_size=512M set-variable= max_allowed_packet=384M set-variable=delay_key_write=ALL set-variable= table_cache=512 set-variable= sort_buffer_size=256M set-variable= record_buffer=384M set-variable= thread_cache=8 set-variable=myisam_sort_buffer_size=384M myisam-recover=BACKUP,FORCE set-variable=read_buffer_size=384M set-variable=interactive_timeout=7200 set-variable=wait_timeout=7200 set-variable=thread_concurrency=4 mysql> show processlist; +----+--------+----------------+--------+---------+------+--------+--------- ---------------------------------------------------------------------------- -----------------+ | Id | User | Host | db | Command | Time | State | Info | +----+--------+----------------+--------+---------+------+--------+--------- ---------------------------------------------------------------------------- -----------------+ | 2 | xotech | localhost:1810 | finlog | Query | 75 | update | INSERT INTO `321st_stat` VALUES ('AE1','AF4','013000887','EA','1','W918AR42800179','R','04280','','B | | 6 | xotech | localhost:1634 | NULL | Query | 0 | NULL | show processlist | +----+--------+----------------+--------+---------+------+--------+--------- ---------------------------------------------------------------------------- -----------------+ 2 rows in set (0.00 sec) mysql> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
