Re: processlist results
Posted by: Rick James
Date: October 15, 2014 12:18PM

Test #2 B does not seem to support your claim. I see the "Sleep(60)" running.
Please explain what I am missing.

"root" does not have PROCESS on information_schema, which is where the data is kept. (I do not know whether this omission is relevant.)

BTW, by convention, each application should have its own login, restricted to the database(s) it uses and with only the PRIVILEGES it needs. This is also good for security.

Considering the complex privs for "root", it might be better to summarize the "N" values in
SELECT * FROM mysql.user WHERE user = "root".
SELECT * FROM mysql.db WHERE user = "root".

Options: ReplyQuote

Written By
October 03, 2014 10:09AM
October 04, 2014 09:31AM
October 04, 2014 10:21AM
October 05, 2014 11:23AM
October 13, 2014 10:42AM
Re: processlist results
October 15, 2014 12:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.