broken slow log, no show patches on Percona Server 5.5.15-55-log

[DaneXA]

Hi All,

I'm having problems setting up the slow query log in Percona Server
5.5.15-55-log for Ubuntu 10.04 (installed via percona's repo).
Additionally, 'show patches;' returns an error.

Here's my.cnf:
slow_query_log_use_global_control = all
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 0

But the output of SHOW GLOBAL VARIABLES is different:
mysql> show global variables like '%long_query%';
| long_query_time | 2.000000 |


And this is worrisome...
mysql> show patches;
ERROR 1064 (42000): You have an error in your SQL syntax...

What am I doing wrong?

Dane

[Baron Schwartz]

Dane,

Are you sure you've actually installed Percona Server and it's actually
reading your my.cnf file?  It looks to me like you might be connecting
to a different server than you think. Verify with @@hostname and
@@port, and of course show variables like "%version%";

- Baron

[Oleg Tsarev]

Hi,

If you don't touch slow-query-log, just run:
show patches;

All works fine?

> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.
> To post to this group, send email to percona-d...@googlegroups.com.
> To unsubscribe from this group, send email to percona-discuss...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/percona-discussion?hl=en.
>
>

--
Oleg Tsarev, Software Engineer, Percona Inc.

[Oleg Tsarev]

If I right remembered, we removed "show patches" syntax...
But I want first confirm, what "show patches" syntax doesn't work

> --
> You received this message because you are subscribed to the Google Groups
> "Percona Discussion" group.

> To view this discussion on the web visit
> https://groups.google.com/d/msg/percona-discussion/-/tW66NId_4MQJ.

[DaneXA]

On Sep 9, 3:13 pm, Oleg Tsarev <oleg.tsa...@percona.com> wrote:
> If I right remembered, we removed "show patches" syntax...
> But I want first confirm, what "show patches" syntax doesn't work

Hi Oleg, I removed all slow_* and long_query_time from my.cnf,
restarted mysqld, and verified. 'show patches' does not work. Same
error as my original post. But it sounds like you removed this
functionality, so it's not a symptom of a larger problem. Good to
know.

> On Fri, Sep 9, 2011 at 11:37 PM, Baron Schwartz <ba...@percona.com> wrote:
> > Are you sure you've actually installed Percona Server and it's actually
> > reading your my.cnf file?  It looks to me like you might be connecting
> > to a different server than you think. Verify with @@hostname and
> > @@port, and of course show variables like "%version%";

Hi Baron, Good point, but indeed I am connecting to Percona Server
5.5. Transcript follows...


root@myhost-on-ec2:~# mysqld -V
mysqld Ver 5.5.15-55-log for Linux on i686 (Percona Server (GPL),
Release 21.0)

root@myhost-on-ec2:~# mysql -uroot
[...snip...]

mysql> select @@hostname,@@port;
+------------------------------------------+--------+
| @@hostname | @@port |
+------------------------------------------+--------+
| myhost-on-ec2.amazonaws.com | 3306 |
+------------------------------------------+--------+
1 row in set (0.00 sec)


mysql> show variables like "%version%";
+-------------------------+------------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------------+
| innodb_version | 1.1.8-20.1 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.15-55-log |
| version_comment | Percona Server (GPL), Release 21.0 |
| version_compile_machine | i686 |
| version_compile_os | Linux |
+-------------------------+------------------------------------+
7 rows in set (0.00 sec)



And here's some good news... SOLVED! While I was writing this reply I
investigated further. The behavior was just too weird. It turns out
I had an additional my.cnf in mysql's datadir (/var/lib/mysql) that
was overriding /etc/mysql/my.cnf. I removed the extra my.cnf and
everything works as expected.

Thanks for your suggestions. Hope this didn't waste too much of your
time. And I even learned a couple of things: 1) 'show patches' is
gone, 2) don't put my.cnf in the datadir.

Dane

Dane

[Oleg Tsarev]

On Sat, Sep 10, 2011 at 3:08 AM, DaneXA <danet...@gmail.com> wrote:
> On Sep 9, 3:13 pm, Oleg Tsarev <oleg.tsa...@percona.com> wrote:
>> If I right remembered, we removed "show patches" syntax...
>> But I want first confirm, what "show patches" syntax doesn't work
>
> Hi Oleg, I removed all slow_* and long_query_time from my.cnf,
> restarted mysqld, and verified.  'show patches' does not work.  Same
> error as my original post.  But it sounds like you removed this
> functionality, so it's not a symptom of a larger problem.  Good to
> know.

Glad to help you :)

> --
> You received this message because you are subscribed to the Google Groups "Percona Discussion" group.