Does this happen with a mysqladmin shutdown command as well? -----Original Message----- From: TO To: [EMAIL PROTECTED] Sent: 4/14/04 5:23 AM Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding INNODB space
Help! We're running MySQl on Win2000 server. The other day our INNODB database filled up, so we stopped the server, backed up the data, and adjusted the innodb_data_file_path from ibdata1:500M;ibdata2:500M;ibdata3:500M; to ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M; Late each night, a scheduled task shuts down the server (NET STOP mysql) so our tape backup can back it all up, and a few hours later another scheduled task restarts the server (NET START mysql). Since we've extended the DB, the "stop" doesn't seem to work -- the database stops, but somehow (perhaps) still holds the port. That is, when we try to restart the server from the command line, we get an error about the port already being in use. (However when we run openports, however, 3306 is not seen as being used.) *Rebooting* the server frees everything up and mysql will restart happily. What have we done wrong? Why might NET STOP MYSQL not be completely closing the process cleanly, so that NET START MYSQL can later start it? Rebooting each morning is not an option, clearly. Thanks for your advice! ----- Here's our my.ini file: # generic params for all sql clients [client] port=3306 # The MySQL server [mysqld] port=3306 skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # log updates log-bin=e:/data/mysql/binarylog # nonstandard locations of MySQL bin and data basedir = e:/apps/mysql/ datadir = e:/data/mysql/data # NOT using BDB tables so skip skip-bdb # INNODB STUFF ref manual p 557 innodb_data_home_dir = e:\data\mysql\ibdata innodb_data_file_path = ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M; set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = e:\data\mysql\iblogs innodb_log_arch_dir = e:\data\mysql\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=75M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=4M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 # MYSQLDUMP ref manual p. 347 [mysqldump] quick add-locks add-drop-table all-databases extended-insert allow-keywords lock-tables set-variable = max_allowed_packet=16M # MYSQL ref manual p. 336 [mysql] no-auto-rehash # maybe remove this later... see ref manual p. 340 safe-updates # IASMCHK [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout # for the admin tool [WinMySQLAdmin] Server=E:/apps/mysql/bin/mysqld-max-nt.exe QueryInterval=10 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
