[DOC] "help kill" on 5.5 references 5.1 page on MySQL documentation site

Bug #1049286 reported by Michael Coburn
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Invalid
Undecided
Unassigned

Bug Description

In Percona Server 5.5.24, typing "help kill" provides useful text description of command but the URL referenced is for version 5.1, and should probably link to 5.5 doc page.

URL: http://dev.mysql.com/doc/refman/5.1/en/kill.html

Thanks,

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Checked on PS 5.5.27:

[root@archie ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.27-rel28.0-debug-log Built by raghavendra at Wed Aug 29 20:51:42 IST 2012

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> help kill
Name: 'KILL'
Description:
Syntax:
KILL [CONNECTION | QUERY] thread_id

Each connection to mysqld runs in a separate thread. You can see which
threads are running with the SHOW PROCESSLIST statement and kill a
thread with the KILL thread_id statement.

KILL permits an optional CONNECTION or QUERY modifier:

o KILL CONNECTION is the same as KILL with no modifier: It terminates
  the connection associated with the given thread_id.

o KILL QUERY terminates the statement that the connection is currently
  executing, but leaves the connection itself intact.

If you have the PROCESS privilege, you can see all threads. If you have
the SUPER privilege, you can kill all threads and statements.
Otherwise, you can see and kill only your own threads and statements.

You can also use the mysqladmin processlist and mysqladmin kill
commands to examine and kill threads.

*Note*: You cannot use KILL with the Embedded MySQL Server library
because the embedded server merely runs inside the threads of the host
application. It does not create any connection threads of its own.

URL: http://dev.mysql.com/doc/refman/5.5/en/kill.html

Changed in percona-server:
status: New → Invalid
Revision history for this message
Alexey Kopytov (akopytov) wrote :

I don't think we even ship help tables (i.e. fill_help_tables.sql) with Percona Server release binaries. It might be that MySQL 5.1 has been upgraded to PS 5.5, so the contents of mysql.help_* tables is still from a MySQL 5.1 release.

Revision history for this message
Michael Coburn (michaelcoburn) wrote :

My apologies guys, next time I'll check in latest release before reporting bug.
--
Michael COburn

Revision history for this message
Raghavendra D Prabhu (raghavendra-prabhu) wrote :

Apologies from my end too. The release binaries (RPM) don't contain any help files. I presume it must have been from previous help versions or some other way as Alexey mentioned.

The one I pasted in #1 is from PS 5.5 build I have.

There is already a bug open for missing help sql files here lp:1041981

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.