There is a known issue in Windows, that when you push a large file to another server all the memory ends up getting allocated to the System cache instead of the user processes. You can look in the Physical Memory (MB) section of task manager to see how much memory is allocated to the system cache.
This can be solved by backing up to a local disk, then having the remote machine pull that file.
Your only hope in this scenario is to have the PROCESS privilege.
The SUPER privilege allows you to kill processes. Naturally, you don't want that. On the other hand, the PROCESS privilege allows you to see the processlist.
According to the MySQL Documentation on the PROCESS Privilege
The PROCESS privilege pertains to display of information about the
threads executing within the server (that is, information about the
statements being executed by sessions). The privilege enables use of
SHOW PROCESSLIST or mysqladmin processlist to see threads belonging to
other accounts; you can always see your own threads.
OK, Big Deal. The PROCESS Privilege lets you see the Process List. How does that help?
You can quickly detect a mysqldump in progress when you run SHOW PROCESSLIST;
and see a pattern like this in the Info field:
SELECT /*!40001 SQL_NO_CACHE */ * FROM
If you have the PROCESS Privilege and are running MySQL 5.1+, you can run this query:
select COUNT(1) mysqldumpThreads
from information_schema.processlist
where info like 'SELECT /*!40001 SQL_NO_CACHE */%';
Here is a sample output:
mysql> select COUNT(1) mysqldumpThreads
-> from information_schema.processlist
-> where info like 'SELECT /*!40001 SQL_NO_CACHE */%';
+------------------+
| mysqldumpThreads |
+------------------+
| 1 |
+------------------+
1 row in set (0.00 sec)
All you need to do is query for that number. If you get a nonzero, mysqldump must be running.
Give it a Try !!!
Best Answer
OBSERVATION #1
It is not recognized because of a typo
You have
It should be
Please change the
additional_mysqldump_params1
toadditional_mysqldump_params
OBSERVATION #2
You have
It should read
Please remove
additional_mysqldump_params1
from that line of codeOBSERVATION #3
There is no need to mysqldump information_schema or performance_schema databases