2013/6/6 Reindl Harald
>
> Am 06.06.2013 15:39, schrieb Manuel Arostegui:
> > Once that problem has been found...you can use either /etc/init.d/mysql
> > stop or mysqladmin. Both should work in the same way
>
> > You should never use kill
>
> and why? what do you think does any stop command?
>
I
Join the rapidly growing Quicken Loans IT team today!
To apply, click here:
https://careers-quickenloans.icims.com/jobs/6027/mysql-dba/job
Who We Are
Quicken Loans is the #1 online mortgage lender in America, closing loans in all
50 states and has grown to be one of the largest full-service re
Hi,
First of all I discourage you to use --processlist, I don't think it is
enough an accurate method to analyse queries.
You can dynamically enable the Slow Query Log with long_query_time=0 and
get a way better data.
Check the syntax for SET GLOBAL variables.
Remember to disable it afterwards.
N
Dear MySQL users,
MySQL Server 5.6.12, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.12 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.6, please see
http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.
- Original Message -
> From: "Claudio Nanni"
>
> You can dynamically enable the Slow Query Log with long_query_time=0
Except when you have persistent connections on a stock mysqld. The recent
Percona ones do have a way to change the settings of existing connections, iirc.
--
Unhappin
Am 06.06.2013 16:01, schrieb h...@tbbs.net:
> 2013/06/06 09:28 -0400, Mike Franon
> Long story short, 50% of the time the command /etc/init.d/mysqld stop will
> fail
>
> Don't see why it anywhen succeeds. My version of "mysqld" doesn't know "stop"
/etc/init.d/mysqld has *noth
2013/06/06 09:28 -0400, Mike Franon
Long story short, 50% of the time the command /etc/init.d/mysqld stop will
fail
Don't see why it anywhen succeeds. My version of "mysqld" doesn't know "stop".
As for "mysqladmin", it knows "stop", but, since that means "stop-slave", I
doubt
2013/06/03 21:43 +, Rick James
Soundex is the 'right' approach, but it needs improvement. So, find an
improvement, then do something like this...
Hashing involves somekind normalizing, and in my case I see no means to it;
otherwise I would not have considered something so
Hi Claudio,
Thanks for reply. Great. I was sure you can't enable slow log
dynamically on 5.0 and 5.1.
That solves my issue for 5.1 at least.
Many thanks,
Igor
On 06/06/13 13:06, Claudio Nanni wrote:
Hi,
First of all I discourage you to use --processlist, I don't think it
is enough an accur
Am 06.06.2013 15:39, schrieb Manuel Arostegui:
> Once that problem has been found...you can use either /etc/init.d/mysql
> stop or mysqladmin. Both should work in the same way
> You should never use kill
and why? what do you think does any stop command?
hint: it sends a SIGTERM
what do you thin
Dear MySQL users,
MySQL Server 5.5.32 is a new version of the 5.5 production release of the
world's most popular open source database. MySQL 5.5.32 is recommended
for use on production systems.
MySQL 5.5 includes several high-impact enhancements to improve the
performance and scalability of the
2013/6/6 Mike Franon
> I am running mysql 5.0 for now, and I have a script that I wrote at 12 am,
> that stops mysql server, unmounts the disk that has mysql, and takes a
> different snapshot from amazon as the new disk.
>
>
> Long story short, 50% of the time the command /etc/init.d/mysqld stop
Hi guys,
I'm trying to use pt-query-digest on one of our Prod servers.
The problem our slow log is disabled, no tcpdump is installed and I
decided to use --processlist parameter which I never tried before.
pt-query-digest version 2.2.2
I run to connect to remote node:
pt-query-digest --process
13 matches
Mail list logo
