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:
http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_open_files_limit_openfileslimit_vs_openfileslimi
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 O
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 wrote:
> In this case the solution is much easier outside of MySQL than inside.
> http://ocaoimh.ie/wp-super-cache/ i
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
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
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 wrote:
> Is it safe to kill a mysqldump while it's in process ?
> i mean aside loosing the dumped file, would it affect the running D
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
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
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 have
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
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 server
11 matches
Mail list logo
