[EMAIL PROTECTED] wrote: > We have installed a mysql database on our our server. The data and log > files are stored on an external SCSI disk array which is connected to > our server using FC cable connected to SCSI port. The mysql process is > running on the local machine but the data and logs are stored on the > disk array. > =20 > When there is an accidental communication breakdown between disk array > and server on which mysql process is running (e.g, pulling out FC > cable), this is being detected by our scripts and then we are trying to > shutdown the mysql process by using mysqladmin shutdown option. However > this command hangs and does not complete. =20
What is the kind of the communication breakdown: a temporary one or the array goes offline forever? In the later case MySQL will hang until disk is available to flush data. You can killall -9 mysqld then but it's brute force. In the first case there is no need to restart MySQL (and theoreticly it should flush and shutdown with no problems). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
