I don't think any other than > show full processlist. In which state query
is locked or not.
I/O related things you check at OS level.
On Thu, Sep 22, 2011 at 11:07 PM, jiangwen jiang wrote:
> Hi,
>
> Is there any performance toolds about UPDATE/INSERT querys?
> I want to monitor the UPDATE/INSE
correct. mysqldump by default has --lock-tables enabled, which means it
tries to lock all tables to be dumped before starting the dump. And doing
LOCK TABLES t1, t2, ... for really big number of tables will inevitably
exhaust all available file descriptors, as LOCK needs all tables to be
opened.
2011/09/23 12:56 +0200, Johan De Meersman
What it says, is "If you are going to run many operations". You are updating
many rows, but you are only doing ONE operation: a single update statement.
For what it's worth, the downloading HTML help claims this only for MyISAM
tables,
Hello Johan,
Just an update. Using the "load index into cache" statement for the
200 million row indexed "source" table, my correlated update statement
ran in 1 hour, 45 minutes to update 144 million rows. A 50% increase
in performance!
Thank you very much,
-Hank
On Fri, Sep 23, 2011 at 6:
In the last episode (Sep 23), Shafi AHMED said:
> I have a mysql database of 200G size and the backup fails due to the foll.
> Issue.
>
> mysqldump: Got error: 1017: Can't find file:
> './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
>
> Can someone assist pls.?
$ perror 24
Hello Johan,
 Thanks for your comprehensive reply. I'll try to answer each of your
questions below.
-Hank
> > But if seeing some SQL will make you happy, here is just one example:
> >
> > UPDATE dest d straight_join source s set d.seq=s.seq WHERE d.key=s.key;
>
> See, this is why people ask to se
Someone seems to have deleted that file, which contains the description of the
corresponding table. Recreate the exact same table (EXACT, including keys,
indices, datatypes, encoding, the lot) and copy that tables's .frm file to
replace the lost one. Then pray to the elder gods and restart your
Folks
I have a mysql database of 200G size and the backup fails due to the foll.
Issue.
mysqldump: Got error: 1017: Can't find file:
'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
Can someone assist pls.?
Best Rgs,
Shafi AHMED
- Original Message -
> From: "Hank"
>
> (please read my ORIGINAL post with all this information).
Welcome on the Internet, where everyone will tell you everything you need to
know, except for what you want to know :-)
> I am trying to find a logical or reasonable explanation WHY this
