# Problem backing up/streaming 2000+ databases, waiting for global read lock **URL:** \ **Category:** Percona XtraBackup\ **Created:** [January 6, 2015, 9:11am UTC](https://forums.percona.com/t/problem-backing-up-streaming-2000-databases-waiting-for-global-read-lock/3978 "2015-01-06T09:11:35Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![chad\_imh](https://avatars.discourse-cdn.com/v4/letter/c/a587f6/32.png) [@chad\_imh](https://forums.percona.com/u/chad_imh)\ **Post date:** [January 6, 2015, 9:11am UTC](https://forums.percona.com/t/problem-backing-up-streaming-2000-databases-waiting-for-global-read-lock/3978/1 "2015-01-06T09:11:35Z")
Happy New Year everyone, I’m hoping someone can help me out. I’m trying to use Xtrabackup to stream about 2500 production databases from the server to a backup storage server (i.e. not a MySQL server, just storage). We’ve been doing this for a while using NFS and it’s no longer a viable solution because of the write speed to NFS and the load NFS imposses on the system. So I’m attempting to switch from using xtrabackup\_56 directly to innobackupex and streaming with xbstream to my storage server. On my development box it works great. On production, not so much. After a few hours of running MySQL stops accepting connections and when I do a processlist on it every query is in a state of “Waiting for global read lock” adn the process that I think is from xtrabackup is in a sleep state. Any suggestions on fixing this? From what I’ve read I’m thinking that --lock-wait-quiry-type=update would be the way to go? If I kill off the root process that’s sleeping in MySQL, things are all good again. Any thoughts? I’m running xtrabackup 2.1.9 (yes, I need to upgrade it, but I can’t right now unless it’s absolutely required). this is the xtrabackup command that’s running on the system. xtrabackup\_56 --defaults-group=mysqld --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --throttle=16 --parallel=4 --stream=xbstream Thanks Chad