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
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
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
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
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
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
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
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
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.
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
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:
11 matches
Mail list logo