Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Roland RoLaNd
Dear all,I have a task to anonymize data in 82000 record (for the time being)i've tested my script against about 30 of them, and it takes about 2.4 sec for each query to be executed. i'm seeking help with the following: - what's the best way to run such a script without affecting the DB

Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Reindl Harald
Am 31.05.2012 09:13, schrieb Roland RoLaNd: Dear all,I have a task to anonymize data in 82000 record (for the time being)i've tested my script against about 30 of them, and it takes about 2.4 sec for each query to be executed. provide table structure and query example sounds like a bad

Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Roland Roland
i agree it wouldn't cause trouble, though it might lock mysql as there's a number of other databases running on the same server. so performance is an issue even if it's just a CPU/RAM peak. On 5/31/12 11:23 AM, Reindl Harald wrote: Am 31.05.2012 09:13, schrieb Roland RoLaNd: Dear all,I

Re: Best practice to minimize DB server performance effect (large query)

2012-05-31 Thread Reindl Harald
DO NOT TOP POST Am 31.05.2012 11:32, schrieb Roland Roland: On 5/31/12 11:23 AM, Reindl Harald wrote: Am 31.05.2012 09:13, schrieb Roland RoLaNd: Dear all,I have a task to anonymize data in 82000 record (for the time being)i've tested my script against about 30 of them, and it takes about

killing mysqldump

2012-05-31 Thread Roland Roland
Is it safe to kill a mysqldump while it's in process ? i mean aside loosing the dumped file, would it affect the running DB being dumped? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: killing mysqldump

2012-05-31 Thread Singer X.J. Wang
Yes, killing a mysqldump is perfectly safe. Caveat being that the dump file produced may be pretty useless. Singer On Thu, May 31, 2012 at 7:41 AM, Roland Roland r_o_l_a_...@hotmail.comwrote: Is it safe to kill a mysqldump while it's in process ? i mean aside loosing the dumped file, would it

Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
hi all, i have an issue with our db which hangs and the only way to recover from it is to restart mysql if you had console access or restart the box itself ( only if i can't wait ) show processlist result can be found here: http://pastebin.com/BYvZ5ZFR listed below are info about

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Baron Schwartz
In this case the solution is much easier outside of MySQL than inside. http://ocaoimh.ie/wp-super-cache/ is an excellent option. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread J M
Thank Baron, i want to see if there is something i can do from the DB end. and BTW, i've been using the plugin already. On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz ba...@xaprb.com wrote: In this case the solution is much easier outside of MySQL than inside.

RE: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Rick James
Find the queries that are not Locked. One of them is being naughty. Perhaps it is this one: | 20770707 | datadb | server1.domain.com:62606 | datadb | Query | 36 | removing tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships

Re: Mysql starts to die at 27 SQL processes

2012-05-31 Thread Andrés Tello
Don't you have any message? For the number of max connections, I suppose you are hitting the limit of file opened, there are no messages at error log? Check this: