Below is the list of changes that have just been committed into a local
5.0 repository of mtaylor. When mtaylor does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet@stripped, 2007-03-02 14:39:01-08:00, mtaylor@qualinost.(none) +116 -0
Adding Debian build scripts.
debian/README.Maintainer@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +117 -0
Adding Debian build scripts.
debian/README.Maintainer@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/Docs__Images__Makefile.in@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +6 -0
Adding Debian build scripts.
debian/additions/Docs__Images__Makefile.in@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/Docs__Makefile.in@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +6 -0
Adding Debian build scripts.
debian/additions/Docs__Makefile.in@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/comp_err.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/comp_err.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/debian-start@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +29 -0
Adding Debian build scripts.
debian/additions/debian-start@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/debian-start.inc.sh@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +52 -0
Adding Debian build scripts.
debian/additions/debian-start.inc.sh@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/echo_stderr@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/additions/echo_stderr@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/msql2mysql.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/msql2mysql.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/my.cnf@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +134 -0
Adding Debian build scripts.
debian/additions/my.cnf@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/my_print_defaults.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/my_print_defaults.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/myisam_ftdump.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/myisam_ftdump.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/myisamchk.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +17 -0
Adding Debian build scripts.
debian/additions/myisamchk.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/myisamlog.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/myisamlog.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/myisampack.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +19 -0
Adding Debian build scripts.
debian/additions/myisampack.1@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql-server.lintian-overrides@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/additions/mysql-server.lintian-overrides@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_config.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +17 -0
Adding Debian build scripts.
debian/additions/mysql_config.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_convert_table_format.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +17 -0
Adding Debian build scripts.
debian/additions/mysql_convert_table_format.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_explain_log.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/mysql_explain_log.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_find_rows.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +18 -0
Adding Debian build scripts.
debian/additions/mysql_find_rows.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_fix_extensions.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +18 -0
Adding Debian build scripts.
debian/additions/mysql_fix_extensions.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_install_db.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/mysql_install_db.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_secure_installation.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +17 -0
Adding Debian build scripts.
debian/additions/mysql_secure_installation.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_setpermission.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +23 -0
Adding Debian build scripts.
debian/additions/mysql_setpermission.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_tableinfo.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +322 -0
Adding Debian build scripts.
debian/additions/mysql_tableinfo.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysql_waitpid.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +20 -0
Adding Debian build scripts.
debian/additions/mysql_waitpid.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlbinlog.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +17 -0
Adding Debian build scripts.
debian/additions/mysqlbinlog.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlbug.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +14 -0
Adding Debian build scripts.
debian/additions/mysqlbug.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlcheck.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +28 -0
Adding Debian build scripts.
debian/additions/mysqlcheck.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqldumpslow.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +50 -0
Adding Debian build scripts.
debian/additions/mysqldumpslow.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlimport.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +20 -0
Adding Debian build scripts.
debian/additions/mysqlimport.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlmanager.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +49 -0
Adding Debian build scripts.
debian/additions/mysqlmanager.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlreport@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +630 -0
Adding Debian build scripts.
debian/additions/mysqlreport@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqlreport.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +180 -0
Adding Debian build scripts.
debian/additions/mysqlreport.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/mysqltest.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/mysqltest.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/ndb_mgmd.cnf@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +35 -0
Adding Debian build scripts.
debian/additions/ndb_mgmd.cnf@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/pack_isam.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +19 -0
Adding Debian build scripts.
debian/additions/pack_isam.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/resolve_stack_dump.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/resolve_stack_dump.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/additions/resolveip.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +16 -0
Adding Debian build scripts.
debian/additions/resolveip.1@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/changelog@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +3267 -0
Adding Debian build scripts.
debian/changelog@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/compat@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/compat@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/control@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +355 -0
Adding Debian build scripts.
debian/control@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/copyright@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +139 -0
Adding Debian build scripts.
debian/copyright@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/copyright.more@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +60 -0
Adding Debian build scripts.
debian/copyright.more@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.README.Maintainer@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +4 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.README.Maintainer@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.dirs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.dirs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.docs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.docs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.examples@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.examples@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.files@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +7 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.files@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15-dev.links@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/libmysqlclient15-dev.links@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15.README.Debian@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +30 -0
Adding Debian build scripts.
debian/libmysqlclient15.README.Debian@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15.dirs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libmysqlclient15.dirs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15.docs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libmysqlclient15.docs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15.files@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libmysqlclient15.files@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libmysqlclient15.postinst@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +12 -0
Adding Debian build scripts.
debian/libmysqlclient15.postinst@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libndbclient2-dev.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +3 -0
Adding Debian build scripts.
debian/libndbclient2-dev.dirs@stripped, 2007-03-02 14:38:37-08:00, mtaylor@qualinost.(none) +0 -0
debian/libndbclient2-dev.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +3 -0
Adding Debian build scripts.
debian/libndbclient2-dev.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/libndbclient2.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libndbclient2.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/libndbclient2.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/libndbclient2.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/libndbclient2.postinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +12 -0
Adding Debian build scripts.
debian/libndbclient2.postinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.NEWS@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +6 -0
Adding Debian build scripts.
debian/mysql-client-5.0.NEWS@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +4 -0
Adding Debian build scripts.
debian/mysql-client-5.0.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/mysql-client-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.docs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/mysql-client-5.0.docs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +20 -0
Adding Debian build scripts.
debian/mysql-client-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-client-5.0.lintian-overrides@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/mysql-client-5.0.lintian-overrides@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-common.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +20 -0
Adding Debian build scripts.
debian/mysql-common.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-common.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/mysql-common.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-4.1.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +191 -0
Adding Debian build scripts.
debian/mysql-server-4.1.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.NEWS@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +10 -0
Adding Debian build scripts.
debian/mysql-server-5.0.NEWS@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +125 -0
Adding Debian build scripts.
debian/mysql-server-5.0.README.Debian@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.config@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +39 -0
Adding Debian build scripts.
debian/mysql-server-5.0.config@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +12 -0
Adding Debian build scripts.
debian/mysql-server-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.docs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/mysql-server-5.0.docs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +55 -0
Adding Debian build scripts.
debian/mysql-server-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.links@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/mysql-server-5.0.links@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.lintian-overrides@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +4 -0
Adding Debian build scripts.
debian/mysql-server-5.0.lintian-overrides@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.logcheck.ignore.paranoid@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +11 -0
Adding Debian build scripts.
debian/mysql-server-5.0.logcheck.ignore.paranoid@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.logcheck.ignore.server@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +32 -0
Adding Debian build scripts.
debian/mysql-server-5.0.logcheck.ignore.server@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.logcheck.ignore.workstation@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +32 -0
Adding Debian build scripts.
debian/mysql-server-5.0.logcheck.ignore.workstation@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.mysql-server.logrotate@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +28 -0
Adding Debian build scripts.
debian/mysql-server-5.0.mysql-server.logrotate@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.postinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +276 -0
Adding Debian build scripts.
debian/mysql-server-5.0.postinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.postrm@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +92 -0
Adding Debian build scripts.
debian/mysql-server-5.0.postrm@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +168 -0
Adding Debian build scripts.
debian/mysql-server-5.0.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.prerm@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +8 -0
Adding Debian build scripts.
debian/mysql-server-5.0.prerm@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server-5.0.templates@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +71 -0
Adding Debian build scripts.
debian/mysql-server-5.0.templates@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-server.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +191 -0
Adding Debian build scripts.
debian/mysql-server.preinst@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-storage-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/mysql-storage-5.0.dirs@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-storage-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/mysql-storage-5.0.files@stripped, 2007-03-02 14:38:38-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-storage-5.0.mysql-storage.init@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +85 -0
Adding Debian build scripts.
debian/mysql-storage-5.0.mysql-storage.init@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-test-5.0.dirs@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/mysql-test-5.0.dirs@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-test-5.0.files@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +6 -0
Adding Debian build scripts.
debian/mysql-test-5.0.files@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-tools-5.0.dirs@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +2 -0
Adding Debian build scripts.
debian/mysql-tools-5.0.dirs@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/mysql-tools-5.0.files@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +14 -0
Adding Debian build scripts.
debian/mysql-tools-5.0.files@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/POTFILES.in@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +1 -0
Adding Debian build scripts.
debian/po/POTFILES.in@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/ca.po@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +290 -0
Adding Debian build scripts.
debian/po/ca.po@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/cs.po@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +259 -0
Adding Debian build scripts.
debian/po/cs.po@stripped, 2007-03-02 14:38:40-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/da.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +283 -0
Adding Debian build scripts.
debian/po/da.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/de.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +195 -0
Adding Debian build scripts.
debian/po/de.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/es.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +288 -0
Adding Debian build scripts.
debian/po/es.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/eu.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +163 -0
Adding Debian build scripts.
debian/po/eu.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/fr.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +204 -0
Adding Debian build scripts.
debian/po/fr.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/gl.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +279 -0
Adding Debian build scripts.
debian/po/gl.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/it.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +184 -0
Adding Debian build scripts.
debian/po/it.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/ja.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +278 -0
Adding Debian build scripts.
debian/po/ja.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/nb.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +179 -0
Adding Debian build scripts.
debian/po/nb.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/nl.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +187 -0
Adding Debian build scripts.
debian/po/nl.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/pt.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +198 -0
Adding Debian build scripts.
debian/po/pt.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/pt_BR.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +339 -0
Adding Debian build scripts.
debian/po/pt_BR.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/ro.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +193 -0
Adding Debian build scripts.
debian/po/ro.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/ru.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +172 -0
Adding Debian build scripts.
debian/po/ru.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/sv.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +225 -0
Adding Debian build scripts.
debian/po/sv.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/templates.pot@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +155 -0
Adding Debian build scripts.
debian/po/templates.pot@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/po/tr.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +290 -0
Adding Debian build scripts.
debian/po/tr.po@stripped, 2007-03-02 14:38:41-08:00, mtaylor@qualinost.(none) +0 -0
debian/rules@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +330 -0
Adding Debian build scripts.
debian/rules@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/source.lintian-overrides@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +4 -0
Adding Debian build scripts.
debian/source.lintian-overrides@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
debian/watch@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +3 -0
Adding Debian build scripts.
debian/watch@stripped, 2007-03-02 14:38:39-08:00, mtaylor@qualinost.(none) +0 -0
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: mtaylor
# Host: qualinost.(none)
# Root: /home/mtaylor/src/mysql-5.0-debian
--- New file ---
+++ debian/README.Maintainer 07/03/02 14:38:37
###########################################################################
# Here are some information that are only of interest for the current and #
# following Debian maintainers of MySQL. #
###########################################################################
The debian/ directory is under SVN control at
svn+ssh://svn.debian.org/svn/mysql-dfsg-41/branches/sid-5.0/debian
#
# Preparing a new version
#
NEW=5.0.7
tar xzf mysql-$NEW.tar.gz
mv mysql-$NEW mysql-dfsg-5.0-$NEW.orig
rm -rf mysql-dfsg-5.0-$NEW.orig/Docs/
tar czf mysql-dfsg-5.0_$NEW.orig.tar.gz mysql-dfsg-5.0-$NEW.orig
rm -rf mysql-dfsg-5.0-$NEW.orig
#
# mysqlreport
#
The authors e-mail address is <public@stripped>.
#
# Remarks to dependencies
#
libwrap0-dev (>= 7.6-8.3)
According to bug report 114582 where where build problems on
IA-64/sid with at least two prior versions.
psmisc
/usr/bin/killall in the initscript
zlib1g in libmysqlclient-dev:
"mysql_config --libs" ads "-lz"
Build-Dep:
debhelper (>=4.1.16):
See po-debconf(7).
autoconf (>= 2.13-20), automake1.7
Try to get rid of them.
doxygen, tetex-bin, tetex-extra, gs
for ndb/docs/*tex
mysql-server-5.0: Pre-Depends: mysql-common
This was necessary as mysql-server-5.0.preinst checks for unmodified
conffiles from mysql-server-4.1 and copies 5.0 ones over them to avoid
unnecessary dpkg questions. As mysql-server-5.0 is not unpacked at its
pre-inst stage, it had to copy those files from a package that is
definetly already unpacked which does not have to be the case with Depends.
#
# Remarks to the start scripts
#
## initscripts rely on mysqladmin from a different package
We have the problem that "/etc/init.d/mysql stop" relies on mysqladmin which
is in another package (mysql-client) and a passwordless access that's maybe
only available if the user configured his /root/.my.cnf. Can this be a problem?
* normal mode: not because the user is required to have it. Else:
* purge/remove: not, same as normal mode
* upgrade: not, same as normal mode
* first install: not, it depends on mysql-client which at least is unpacked
so mysqladmin is there (to ping). It is not yet configured
passwordles but if there's a server running then there's a
/root/.my.cnf. Anyways, we simply kill anything that's mysqld.
## Passwordless access for the maintainer scripts
Another issue is that the scripts needs passwordless access. To ensure this
a debian-sys-maint user is configured which has process and shutdown privs.
The file with the randomly (that's important!) generated password must be
present as long as the databases remain installed because else a new install
would have no access. This file should be used like:
mysqladmin --defaults-file=/etc/mysql/debian.cnf restart
to avoid providing the password in plaintext on a commandline where it would
be visible to any user via the "ps" command.
## When to start the daemon?
We aim to give the admin full control on when MySQL is running.
Issues to be faced here:
OLD:
1. Debconf asks whether MySQL should be started on boot so update-rc.d is
only run if the answer has been yes. The admin is likely to forget
this decision but update-rc.d checks for an existing line in
/etc/runlevel.conf and leaves it intact.
2. On initial install, if the answer is yes, the daemon has to be started.
3. On upgrades it should only be started if it was already running, everything
else is confusing. Especiall relying on an debconf decision made month ago
is considered suboptimal. See bug #274264
Implementation so far:
prerm (called on upgrade before stopping the server):
check for a running server and set flag if necessary
preinst (called on initial install and before unpacking when upgrading):
check for the debconf variable and set flag if necessary
postinst (called on initial install and after each upgrade after unpacking):
call update-rc.d if debconf says yes
call invoce-rc.d if the flag has been set
Problems remaining:
dpkg-reconfigure and setting mysql start on boot to yes did not start mysql
(ok "start on boot" literally does not mean "start now" so that might have been ok)
NEW:
1. --- no debconf anymore for the sake of simplicity. We have runlevel.conf,
the admin should use it
2. On initial install the server is started.
3. On upgrades the server is started exactly if it was running before so the
runlevel configuration is irrelevant. It will be preserved by the mean of
update-rc.d's builtin check.
Implementation:
prerm (called on upgrade before stopping the server):
check for a running server and set flag if necessary
preinst (called on initial install and before unpacking when upgrading):
check for $1 beeing (initial) "install" and set flag
postinst (called on initial install and after each upgrade after unpacking):
call update-rc.d
call invoce-rc.d if the flag has been set
--- New file ---
+++ debian/additions/Docs__Images__Makefile.in 07/03/02 14:38:39
all:
distclean:
-rm -f Makefile
.PHONY: all distclean clean install check
--- New file ---
+++ debian/additions/Docs__Makefile.in 07/03/02 14:38:39
all:
distclean:
-rm -f Makefile
.PHONY: all distclean clean install check
--- New file ---
+++ debian/additions/comp_err.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlerr \- MySQL helper program to compile error messages.
.SH SYNOPSIS
mysqlerr [options]
.SH DESCRIPTION
This program compiles some kind of error messages.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/debian-start.inc.sh 07/03/02 14:38:39
#!/bin/bash
#
# This file is included by /etc/mysql/debian-start
#
## Check all unclosed tables.
# - Requires the server to be up.
# - Is supposed to run silently in background.
function check_for_crashed_tables() {
set -e
set -u
# But do it in the background to not stall the boot process.
logger -p daemon.info -i -t$0 "Checking for crashed MySQL tables."
# Checking for $? is unreliable so the size of the output is checked.
# Some table handlers like HEAP do not support CHECK TABLE.
tempfile=`tempfile`
LC_ALL=C $MYCHECK $MYCHECK_PARAMS \
2>&1 \
| perl -e '$_=join("", <>); s/^[^\n]+\n(error|note)\s+: The (handler|storage engine) for the table doesn.t support check\n//smg;print;' \
> $tempfile
if [ -s $tempfile ]; then
(
/bin/echo -e "\n" \
"Improperly closed tables are also reported if clients are accessing\n" \
"the tables *now*. A list of current connections is below.\n";
$MYADMIN processlist status
) >> $tempfile
# Check for presence as a dependency on mailx would require an MTA.
if [ -x /usr/bin/mailx ]; then mailx -e -s"$MYCHECK_SUBJECT" $MYCHECK_RCPT < $tempfile; fi
(echo "$MYCHECK_SUBJECT"; cat $tempfile) | logger -p daemon.warn -i -t$0
fi
rm $tempfile
}
## Check for tables needing an upgrade.
# - Requires the server to be up.
# - Is supposed to run silently in background.
function upgrade_system_tables_if_necessary() {
set -e
set -u
logger -p daemon.info -i -t$0 "Upgrading MySQL tables if necessary."
# Filter all "duplicate column", "duplicate key" and "unknown column"
# errors as the script is designed to be idempotent.
LC_ALL=C $MYUPGRADE \
2>&1 \
| egrep -v '^(1|@had|ERROR (1054|1060|1061))' \
| logger -p daemon.warn -i -t$0
}
--- New file ---
+++ debian/additions/debian-start 07/03/02 14:38:39
#!/bin/bash
#
# This script is executed by "/etc/init.d/mysql" on every (re)start.
#
# Changes to this file will be preserved when updating the Debian package.
#
source /usr/share/mysql/debian-start.inc.sh
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf"
MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="root"
# The following commands should be run when the server is up but in background
# where they do not block the server start and in one shell instance so that
# they run sequentially. They are supposed not to echo anything to stdout.
# If you want to disable the check for crashed tables comment
# "check_for_crashed_tables" out.
# (There may be no output to stdout inside the background process!)
echo "Checking for corrupt, not cleanly closed and upgrade needing tables."
(
upgrade_system_tables_if_necessary;
check_for_crashed_tables;
) >&2 &
exit 0
--- New file ---
+++ debian/additions/echo_stderr 07/03/02 14:38:39
#!/bin/bash
echo "$*" 1>&2
--- New file ---
+++ debian/additions/msql2mysql.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
msql2mysql \- MySQL importer for msql style data.
.SH SYNOPSIS
msql2mysql [options]
.SH DESCRIPTION
This program imports old msql database files.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/my.cnf 07/03/02 14:38:39
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
#
# * Fine Tuning
#
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
#
# * Query Cache Configuration
#
query_cache_limit = 1048576
query_cache_size = 16777216
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
# WARNING: Using expire_logs_days without bin_log crashes the server! See README.Debian!
expire_logs_days = 10
max_binlog_size = 100M
#binlog_do_db = include_database_name
#binlog_ignore_db = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completition
[isamchk]
key_buffer = 16M
#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1
#
# * IMPORTANT: Additional settings that can override those from this file!
#
!includedir /etc/mysql/conf.d/
--- New file ---
+++ debian/additions/my_print_defaults.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
my_print_defaults \- MySQL helper script that prints defaults.
.SH SYNOPSIS
my_print_defaults [options]
.SH DESCRIPTION
Prints all arguments that is give to some program using the default files.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/myisam_ftdump.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
myisam_ftdump \- Dumps full text tables.
.SH SYNOPSIS
myisam_ftdump [options]
.SH DESCRIPTION
Dumps information and contents of full text tables.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/myisamchk.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
myisamchk \- Checks MySQL myisam type databases.
.SH SYNOPSIS
myisamchk [options]
.SH DESCRIPTION
Description, check and repair of ISAM tables.
Used without options all tables on the command will be checked for errors
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/myisamlog.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
myisamlog \- MySQL helper script.
.SH SYNOPSIS
myisamlog [options]
.SH DESCRIPTION
Function unknown. Mail to ch@stripped.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/myisampack.1 07/03/02 14:38:39
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
myisampack \- Compresses MySQL database files.
.SH SYNOPSIS
myisampack [options]
.SH DESCRIPTION
Pack a MyISAM-table to take much less space.
Keys are not updated, you must run myisamchk -rq on the datafile
afterwards to update the keys.
You should give the .MYI file as the filename argument.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql-server.lintian-overrides 07/03/02 14:38:39
W: mysql-dfsg source: maintainer-script-lacks-debhelper-token debian/mysql-server.postinst
W: mysql-server: possible-bashism-in-maintainer-script postinst:68 'p{("a".."z","A".."Z",0..9)[int(rand(62))]}'
--- New file ---
+++ debian/additions/mysql_config.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlconfig \- MySQL compile settings.
.SH SYNOPSIS
mysqlconfig [options]
.SH DESCRIPTION
This program is only useful for people who want to compile agains
libmysqlclient.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_convert_table_format.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_convert_table_format \- MySQL table converter.
.SH SYNOPSIS
mysql_convert_table_format [options]
.SH DESCRIPTION
Conversion of a MySQL tables to other table types.
If no tables has been specifed, all tables in the database will be converted.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_explain_log.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_explain_log \- Explains queries from binary logs.
.SH SYNOPSIS
mysql_explain_log [options]
.SH DESCRIPTION
Read logfile from STDIN an try to EXPLAIN all SELECT statements. All UPDATE statements are rewritten to an EXPLAIN SELECT statement. The results of the EXPLAIN statement are collected and counted. All results with type=ALL are collected in an separete list. Results are printed to STDOUT.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_find_rows.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_find_rows \- MySQL shell skript for searching in update logs.
.SH SYNOPSIS
mysql_find_rows [options]
.SH DESCRIPTION
Prints all SQL queries that matches a regexp or contains a 'use
database' or 'set ..' command to stdout. A SQL query may contain
newlines. This is useful to find things in a MySQL update log.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_fix_extensions.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_fix_extensions \- Corrects MySQL database file names.
.SH SYNOPSIS
mysql_fix_extensions <datadir>
.SH DESCRIPTION
Makes .frm lowercase and .MYI/MYD/ISM/ISD uppercase
useful when datafiles are copied from windows.
Does not work with RAID, with InnoDB or BDB tables.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (8)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_install_db.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_install_db \- MySQL helper program.
.SH SYNOPSIS
mysql_install_db [options]
.SH DESCRIPTION
This program is normally not needed by any user.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_secure_installation.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_secure_installation \- Secures the MySQL access control lists.
.SH SYNOPSIS
mysql_secure_installation [options]
.SH DESCRIPTION
This interactive programm suggests changes like removing anonymous users that
are supposed to make your installation more secure.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (8)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_setpermission.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_setpermission \- Adds MySQL users or changes passwords.
.SH SYNOPSIS
mysql_setpermission [options]
.SH DESCRIPTION
The permission setter is a little program which can help you add users
or databases or change passwords in MySQL. Keep in mind that we don't
check permissions which already been set in MySQL. So if you can't
connect to MySQL using the permission you just added, take a look at
the permissions which have already been set in MySQL.
The permission setter first reads your .my.cnf file in your Home
directory if it exists.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysql_tableinfo.1 07/03/02 14:38:40
.\" Automatically generated by Pod::Man v1.34, Pod::Parser v1.13
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sh \" Subsection heading
.br
.if t .Sp
.ne 5
.PP
\fB\\$1\fR
.PP
..
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings. \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote. | will give a
.\" real vertical bar. \*(C+ will give a nicer C++. Capital omega is used to
.\" do unbreakable dashes and therefore won't be available. \*(C` and \*(C'
.\" expand to `' in nroff, nothing in troff, for use with C<>.
.tr \(*W-|\(bv\*(Tr
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
. ds -- \(*W-
. ds PI pi
. if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
. if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\" diablo 12 pitch
. ds L" ""
. ds R" ""
. ds C` ""
. ds C' ""
'br\}
.el\{\
. ds -- \|\(em\|
. ds PI \(*p
. ds L" ``
. ds R" ''
'br\}
.\"
.\" If the F register is turned on, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.Sh), items (.Ip), and index
.\" entries marked with X<> in POD. Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.if \nF \{\
. de IX
. tm Index:\\$1\t\\n%\t"\\$2"
..
. nr % 0
. rr F
.\}
.\"
.\" For nroff, turn off justification. Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.hy 0
.if n .na
.\"
.\" Accent mark definitions (@(#)ms.acc 1.5 88/02/08 SMI; from UCB 4.2).
.\" Fear. Run. Save yourself. No user-serviceable parts.
. \" fudge factors for nroff and troff
.if n \{\
. ds #H 0
. ds #V .8m
. ds #F .3m
. ds #[ \f1
. ds #] \fP
.\}
.if t \{\
. ds #H ((1u-(\\\\n(.fu%2u))*.13m)
. ds #V .6m
. ds #F 0
. ds #[ \&
. ds #] \&
.\}
. \" simple accents for nroff and troff
.if n \{\
. ds ' \&
. ds ` \&
. ds ^ \&
. ds , \&
. ds ~ ~
. ds /
.\}
.if t \{\
. ds ' \\k:\h'-(\\n(.wu*8/10-\*(#H)'\'\h"|\\n:u"
. ds ` \\k:\h'-(\\n(.wu*8/10-\*(#H)'\`\h'|\\n:u'
. ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'^\h'|\\n:u'
. ds , \\k:\h'-(\\n(.wu*8/10)',\h'|\\n:u'
. ds ~ \\k:\h'-(\\n(.wu-\*(#H-.1m)'~\h'|\\n:u'
. ds / \\k:\h'-(\\n(.wu*8/10-\*(#H)'\z\(sl\h'|\\n:u'
.\}
. \" troff and (daisy-wheel) nroff accents
.ds : \\k:\h'-(\\n(.wu*8/10-\*(#H+.1m+\*(#F)'\v'-\*(#V'\z.\h'.2m+\*(#F'.\h'|\\n:u'\v'\*(#V'
.ds 8 \h'\*(#H'\(*b\h'-\*(#H'
.ds o \\k:\h'-(\\n(.wu+\w'\(de'u-\*(#H)/2u'\v'-.3n'\*(#[\z\(de\v'.3n'\h'|\\n:u'\*(#]
.ds d- \h'\*(#H'\(pd\h'-\w'~'u'\v'-.25m'\f2\(hy\fP\v'.25m'\h'-\*(#H'
.ds D- D\\k:\h'-\w'D'u'\v'-.11m'\z\(hy\v'.11m'\h'|\\n:u'
.ds th \*(#[\v'.3m'\s+1I\s-1\v'-.3m'\h'-(\w'I'u*2/3)'\s-1o\s+1\*(#]
.ds Th \*(#[\s+2I\s-2\h'-\w'I'u*3/5'\v'-.3m'o\v'.3m'\*(#]
.ds ae a\h'-(\w'a'u*4/10)'e
.ds Ae A\h'-(\w'A'u*4/10)'E
. \" corrections for vroff
.if v .ds ~ \\k:\h'-(\\n(.wu*9/10-\*(#H)'\s-2\u~\d\s+2\h'|\\n:u'
.if v .ds ^ \\k:\h'-(\\n(.wu*10/11-\*(#H)'\v'-.4m'^\v'.4m'\h'|\\n:u'
. \" for low resolution devices (crt and lpr)
.if \n(.H>23 .if \n(.V>19 \
\{\
. ds : e
. ds 8 ss
. ds o a
. ds d- d\h'-1'\(ga
. ds D- D\h'-1'\(hy
. ds th \o'bp'
. ds Th \o'LP'
. ds ae ae
. ds Ae AE
.\}
.rm #[ #] #H #V #F C
.\" ========================================================================
.\"
.IX Title "MYSQL_TABLEINFO 1"
.TH MYSQL_TABLEINFO 1 "2003-04-05" "perl v5.8.0" "User Contributed Perl Documentation"
.SH "NAME"
mysql_tableinfo \- creates and populates information tables with
the output of SHOW DATABASES, SHOW TABLES (or SHOW TABLE STATUS),
SHOW COLUMNS and SHOW INDEX.
.PP
This is version 1.1.
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 1
\& mysql_tableinfo [OPTIONS] database_to_write [database_like_wild] [table_like_wild]
.Ve
.PP
.Vb 2
\& Do not backquote (``) database_to_write,
\& and do not quote ('') database_like_wild or table_like_wild
.Ve
.PP
.Vb 1
\& Examples:
.Ve
.PP
.Vb 1
\& mysql_tableinfo info
.Ve
.PP
.Vb 1
\& mysql_tableinfo info this_db
.Ve
.PP
.Vb 1
\& mysql_tableinfo info %a% b%
.Ve
.PP
.Vb 1
\& mysql_tableinfo info --clear-only
.Ve
.PP
.Vb 1
\& mysql_tableinfo info --col --idx --table-status
.Ve
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
mysql_tableinfo asks a MySQL server information about its
databases, tables, table columns and index, and stores this
in tables called `db`, `tbl` (or `tbl_status`), `col`, `idx`
(with an optional prefix specified with \-\-prefix).
After that, you can query these information tables, for example
to build your admin scripts with \s-1SQL\s0 queries, like
.PP
\&\s-1SELECT\s0 \s-1CONCAT\s0(\*(L"\s-1CHECK\s0 \s-1TABLE\s0 \*(R",`database`,\*(L".\*(R",`table`,\*(L" \s-1EXTENDED\s0;\*(R")
\&\s-1FROM\s0 info.tbl \s-1WHERE\s0 ... ;
.PP
as people usually do with some other \s-1RDBMS\s0
(note: to increase the speed of your queries on the info tables,
you may add some index on them).
.PP
The database_like_wild and table_like_wild instructs the program
to gather information only about databases and tables
whose names match these patterns. If the info
tables already exist, their rows matching the patterns are simply
deleted and replaced by the new ones. That is,
old rows not matching the patterns are not touched.
If the database_like_wild and table_like_wild arguments
are not specified on the command-line they default to \*(L"%\*(R".
.PP
The program :
.PP
\&\- does \s-1CREATE\s0 \s-1DATABASE\s0 \s-1IF\s0 \s-1NOT\s0 \s-1EXISTS\s0 database_to_write
where database_to_write is the database name specified on the command\-line.
.PP
\&\- does \s-1CREATE\s0 \s-1TABLE\s0 \s-1IF\s0 \s-1NOT\s0 \s-1EXISTS\s0 database_to_write.`db`
.PP
\&\- fills database_to_write.`db` with the output of
\&\s-1SHOW\s0 \s-1DATABASES\s0 \s-1LIKE\s0 database_like_wild
.PP
\&\- does \s-1CREATE\s0 \s-1TABLE\s0 \s-1IF\s0 \s-1NOT\s0 \s-1EXISTS\s0 database_to_write.`tbl`
(respectively database_to_write.`tbl_status`
if the \-\-tbl\-status option is on)
.PP
\&\- for every found database,
fills database_to_write.`tbl` (respectively database_to_write.`tbl_status`)
with the output of
\&\s-1SHOW\s0 \s-1TABLES\s0 \s-1FROM\s0 found_db \s-1LIKE\s0 table_like_wild
(respectively \s-1SHOW\s0 \s-1TABLE\s0 \s-1STATUS\s0 \s-1FROM\s0 found_db \s-1LIKE\s0 table_like_wild)
.PP
\&\- if the \-\-col option is on,
* does \s-1CREATE\s0 \s-1TABLE\s0 \s-1IF\s0 \s-1NOT\s0 \s-1EXISTS\s0 database_to_write.`col`
* for every found table,
fills database_to_write.`col` with the output of
\s-1SHOW\s0 \s-1COLUMNS\s0 \s-1FROM\s0 found_tbl \s-1FROM\s0 found_db
.PP
\&\- if the \-\-idx option is on,
* does \s-1CREATE\s0 \s-1TABLE\s0 \s-1IF\s0 \s-1NOT\s0 \s-1EXISTS\s0 database_to_write.`idx`
* for every found table,
fills database_to_write.`idx` with the output of
\s-1SHOW\s0 \s-1INDEX\s0 \s-1FROM\s0 found_tbl \s-1FROM\s0 found_db
.PP
Some options may modify this general scheme (see below).
.PP
As mentioned, the contents of the info tables are the output of
\&\s-1SHOW\s0 commands. In fact the contents are slightly more complete :
.PP
\&\- the `tbl` (or `tbl_status`) info table
has an extra column which contains the database name,
.PP
\&\- the `col` info table
has an extra column which contains the table name,
and an extra column which contains, for each described column,
the number of this column in the table owning it (this extra column
is called `Seq_in_table`). `Seq_in_table` makes it possible for you
to retrieve your columns in sorted order, when you are querying
the `col` table.
.PP
\&\- the `index` info table
has an extra column which contains the database name.
.PP
Caution: info tables contain certain columns (e.g.
Database, Table, Null...) whose names, as they are MySQL reserved words,
need to be backquoted (`...`) when used in \s-1SQL\s0 statements.
.PP
Caution: as information fetching and info tables filling happen at the
same time, info tables may contain inaccurate information about
themselves.
.SH "OPTIONS"
.IX Header "OPTIONS"
.IP "\-\-clear" 4
.IX Item "--clear"
Does \s-1DROP\s0 \s-1TABLE\s0 on the info tables (only those that the program is
going to fill, for example if you do not use \-\-col it won't drop
the `col` table) and processes normally. Does not drop database_to_write.
.IP "\-\-clear\-only" 4
.IX Item "--clear-only"
Same as \-\-clear but exits after the DROPs.
.IP "\-\-col" 4
.IX Item "--col"
Adds columns information (into table `col`).
.IP "\-\-idx" 4
.IX Item "--idx"
Adds index information (into table `idx`).
.IP "\-\-prefix prefix" 4
.IX Item "--prefix prefix"
The info tables are named from the concatenation of prefix and,
respectively, db, tbl (or tbl_status), col, idx. Do not quote ('')
or backquote (``) prefix.
.IP "\-q, \-\-quiet" 4
.IX Item "-q, --quiet"
Does not warn you about what the script is going to do (\s-1DROP\s0 \s-1TABLE\s0 etc)
and does not ask for a confirmation before starting.
.IP "\-\-tbl\-status" 4
.IX Item "--tbl-status"
Instead of using \s-1SHOW\s0 \s-1TABLES\s0, uses \s-1SHOW\s0 \s-1TABLE\s0 \s-1STATUS\s0
(much more complete information, but slower).
.IP "\-\-help" 4
.IX Item "--help"
Display helpscreen and exit
.IP "\-u, \-\-user=#" 4
.IX Item "-u, --user=#"
user for database login if not current user. Give a user
who has sufficient privileges (\s-1CREATE\s0, ...).
.IP "\-p, \-\-password=# (INSECURE)" 4
.IX Item "-p, --password=# (INSECURE)"
password to use when connecting to server.
WARNING: Providing a password on command line is insecure as it is visible through /proc to anyone for a short time.
.IP "\-h, \-\-host=#" 4
.IX Item "-h, --host=#"
host to connect to
.IP "\-P, \-\-port=#" 4
.IX Item "-P, --port=#"
port to use when connecting to server
.IP "\-S, \-\-socket=#" 4
.IX Item "-S, --socket=#"
\&\s-1UNIX\s0 domain socket to use when connecting to server
.SH "WARRANTY"
.IX Header "WARRANTY"
This software is free and comes without warranty of any kind. You
should never trust backup software without studying the code yourself.
Study the code inside this script and only rely on it if \fIyou\fR believe
that it does the right thing for you.
.Sp
Patches adding bug fixes, documentation and new features are welcome.
.SH "TO DO"
.IX Header "TO DO"
Use extended inserts to be faster (for servers with many databases
or tables). But to do that, must care about net\-buffer\-length.
.SH "AUTHOR"
.IX Header "AUTHOR"
2002\-06\-18 Guilhem Bichot (guilhem.bichot@mines\-paris.org)
.Sp
And all the authors of mysqlhotcopy, which served as a model for
the structure of the program.
--- New file ---
+++ debian/additions/mysql_waitpid.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysql_waitpid \- Waits a specified amount of seconds for a PID to terminate.
.SH SYNOPSIS
mysql_waitpid [options] <pid> <seconds>
.SH DESCRIPTION
Description: Waits for a program, which program id is #pid, to
terminate within #time seconds. If the program terminates within
this time, or if the #pid no longer exists, value 0 is returned.
Otherwise 1 is returned. Both #pid and #time must be positive
integer arguments.
See mysql_waitpid for options.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqlbinlog.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlbinlog \- Dumps MySQL binary logs.
.SH SYNOPSIS
mysqlbinlog [options]
.SH DESCRIPTION
Dumps a MySQL binary log in a format usable for viewing or for pipeing to
the mysql command line client
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqlbug.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlbug \- MySQL bug reporting tool.
.SH SYNOPSIS
mysqlbug [options]
.SH DESCRIPTION
Interactive bug reporting tool. Use reportbug on Debian systems.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqlcheck.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlcheck \- MySQL program for repairing, checking and optimizing tables.
.SH SYNOPSIS
mysqlcheck | mysqlanalyze | mysqloptimize [options]
.SH DESCRIPTION
This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a)
or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be
used same time. It works on MyISAM and in some cases on BDB tables.
Please consult the MySQL manual for latest information about the
above. The options -c,-r,-a and -o are exclusive to each other, which
means that the last option will be used, if several was specified.
The option -c will be used by default, if none was specified. You
can change the default behavior by making a symbolic link, or
copying this file somewhere with another name, the alternatives are:
mysqlrepair: The default option will be -r
mysqlanalyze: The default option will be -a
mysqloptimize: The default option will be -o
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (8)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqldumpslow.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqldumpslow \- Parse and summarize the MySQL slow query log.
.SH SYNOPSIS
mysqldumpslow [options]
.SH DESCRIPTION
This program parses and summarizes a 'slow query log'.
.TP
\fB\-v\fR
verbose
.TP
\fB\-d\fR
debug
.TP
\fB\-s=WORD\fR
what to sort by (t, at, l, al, r, ar etc)
.TP
\fB\-r\fR
reverse the sort order (largest last instead of first)
.TP
\fB\-t=NUMBER\fR
just show the top n queries
.TP
\fB\-a\fR
don't abstract all numbers to N and strings to 'S'
.TP
\fB\-n=NUMBER\fR
abstract numbers with at least n digits within names
.TP
\fB\-g=WORD\fR
grep: only consider stmts that include this string
.TP
\fB\-h=WORD\fR
hostname of db server for *-slow.log filename (can be wildcard)
.TP
\fB\-i=WORD\fR
name of server instance (if using mysql.server startup script)
.TP
\fB\-l\fR
don't subtract lock time from total time
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped> based on
the commends in the code.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqlimport.1 07/03/02 14:38:40
.TH mysql 1 "17 March 2003" "MySQL 3.23" "MySQL database"
.SH NAME
mysqlimport \- Imports text files with MySQL database queries.
.SH SYNOPSIS
mysqlimport [options]
.SH DESCRIPTION
Loads tables from text files in various formats. The base name of the
text file must be the name of the table that should be used.
If one uses sockets to connect to the MySQL server, the server will open and
read the text file directly. In other cases the client will open the text
file. The SQL command 'LOAD DATA INFILE' is used to import the rows.
For more information start the program with '--help'.
.SH "SEE ALSO"
mysql (1), mysqld (1)
.SH AUTHOR
This manpage was written by Christian Hammers <ch@stripped>.
MySQL is available at http://www.mysql.com/.
.\" end of man page
--- New file ---
+++ debian/additions/mysqlmanager.1 07/03/02 14:38:40
.TH mysql 1 "March 2005" "MySQL 4.1" "MySQL database"
.SH NAME
mysqlmanager \- Manages instances of MySQL server.
.SH SYNOPSIS
.B mysqlmanager
[\fIOPTIONS\fR]
.SH DESCRIPTION
Manages instances of MySQL server.
.TP
\-?, \fB\-\-help\fR
Display this help and exit.
.TP
\fB\-P\fR, \fB\-\-port=\fR#
Port number to listen on.
.TP
\fB\-l\fR, \fB\-\-log\fR=\fIname\fR
Path to log file.
.TP
\fB\-b\fR, \fB\-\-bind\-address=\fR#
Address to listen on.
.HP
\fB\-B\fR, \fB\-\-tcp\-backlog=\fR# Size of TCP/IP listen queue.
.HP
\fB\-g\fR, \fB\-\-greeting\fR=\fIname\fR Set greeting on connect.
.TP
\fB\-m\fR, \fB\-\-max\-command\-len=\fR#
Maximum command length.
.TP
\fB\-d\fR, \fB\-\-one\-thread\fR
Use one thread ( for debugging).
.TP
\fB\-C\fR, \fB\-\-connect\-retries=\fR#
Number of attempts to establish MySQL connection.
.TP
\fB\-p\fR, \fB\-\-password\-file\fR=\fIname\fR
Password file for manager.
.HP
\fB\-f\fR, \fB\-\-pid\-file\fR=\fIname\fR Pid file to use.
.TP
\fB\-V\fR, \fB\-\-version\fR
Output version information and exit.
.SH "SEE ALSO"
The full documentation for
.B mysqlmanager
is available in the package mysql-doc-4.1 or on the MySQL
homepage www.mysql.com.
.SH AUTHOR
This manpage was created by Christian Hammers <ch@stripped>
using help2man.
--- New file ---
+++ debian/additions/mysqlreport.1 07/03/02 14:38:40
.TH "mysqlreport" "1" "2.5 2006-09-01 (docrev 2006-05-19)" "Daniel Nichter" "MYSQL"
.SH "NAME"
.LP
mysqlreport \- Makes a friendly report of important MySQL status values
.SH "SYNTAX"
.LP
mysqlreport [\fIoptions\fP]
.SH "DESCRIPTION"
.LP
mysqlreport makes a friendly report of important MySQL status values. Actually,
it makes a friendly report of nearly every status value from SHOW STATUS.
Unlike SHOW STATUS which simply dumps over 100 values to screen in one long
list, mysqlreport interprets and formats the values and presents the basic
values and many more inferred values in a human\-readable format. Numerous
example reports are available at the mysqlreport web page at
http://hackmysql.com/mysqlreport.
The benefit of mysqlreport is that it allows you to very quickly see a wide
array of performance indicators for your MySQL server which would otherwise
need to be calculated by hand from all the various SHOW STATUS values. For
example, the Index Read Ratio is an important value but it's not present in
SHOW STATUS; it's an inferred value (the ratio of Key_reads to
Key_read_requests).
This documentation outlines all the command line options in mysqlreport, most
of which control which reports are printed. This document does not address
how to interpret these reports; that topic is covered in the document Guide
To Understanding mysqlreport at http://hackmysql.com/mysqlreportguide.
.SH "OPTIONS"
Technically, command line options are in the form \-\-option, but \-option works
too. All options can be abbreviated if the abbreviation is unique. For example,
option \-\-host can be abbreviated \-\-ho but not \-\-h because \-\-h is ambiguous: it
could mean \-\-host or \-\-help.
.LP
.TP
\fB\-\-help\fR
Output help information and exit.
.TP
\fB\-\-user USER\fR
.TP
\fB\-\-password\fR
As of version 2.3 \-\-password can take the password on the
command line like "\-\-password FOO". Using \-\-password
alone without giving a password on the command line
causes mysqlreport to prompt for a password.
.TP
\fB\-\-host ADDRESS\fR
.TP
\fB\-\-port PORT\fR
.TP
\fB\-\-socket SOCKET\fR
.TP
\fB\-\-no\-mycnf\fR
\-\-no\-mycnf makes mysqlreport not read ~/.my.cnf which it does by default
otherwise. \-\-user and \-\-password always override values from ~/.my.cnf.
.TP
\fB\-\-dtq\fR
Print Distribution of Total Queries (DTQ) report (under
Total in Questions report). Queries (or Questions) can
be divided into four main areas: DMS (see \-\-dms below),
Com_ (see \-\-com below), COM_QUIT (see COM_QUIT and
Questions at http://hackmysql.com/com_quit), and
Unknown. \-\-dtq lists the number of queries in each of
these areas in descending order.
.TP
\fB\-\-dms\fR
Print Data Manipulation Statements (DMS) report (under
DMS in Questions report). DMS are those from the MySQL
manual section 13.2. Data Manipulation Statements.
(Currently, mysqlreport considers only SELECT, INSERT,
REPLACE, UPDATE, and DELETE.) Each DMS is listed in
descending order by count.
.TP
\fB\-\-com N\fR
Print top N number of non\-DMS Com_ status values in
descending order (after DMS in Questions report). If N
is not given, default is 3. Such non\-DMS Com_ values
include Com_change_db, Com_show_tables, Com_rollback,
etc.
.TP
\fB\-\-sas\fR
Print report for Select_ and Sort_ status values (after
Questions report). See MySQL Select and Sort Status
Variables at http://hackmysql.com/selectandsort.
.TP
\fB\-\-tab\fR
Print Threads, Aborted, and Bytes status reports (after
Created temp report). As of mysqlreport v2.3 the
Threads report reports on all Threads_ status values.
.TP
\fB\-\-qcache\fR
Print Query Cache report.
.TP
\fB\-\-all\fR
Equivalent to "\-\-dtq \-\-dms \-\-com 3 \-\-sas \-\-qcache".
(Notice \-\-tab is not invoked by \-\-all.)
.TP
\fB\-\-infile FILE\fR
Instead of getting SHOW STATUS values from MySQL, read
values from FILE. FILE is often a copy of the output of
SHOW STATUS including formatting characters (|, +, \-).
mysqlreport expects FILE to have the format
" value number " where value is only alpha and
underscore characters (A\-Z and _) and number is a
positive integer. Anything before, between, or after
value and number is ignored. mysqlreport also needs
the following MySQL server variables: version,
table_cache, max_connections, key_buffer_size,
query_cache_size. These values can be specified in
INFILE in the format "name = value" where name is one
of the aforementioned server variables and value is a
positive integer with or without a trailing M and
possible periods (for version). For example, to specify
an 18M key_buffer_size: key_buffer_size = 18M. Or, a
256 table_cache: table_cache = 256. The M implies
Megabytes not million, so 18M means 18,874,368 not
18,000,000. If these server variables are not specified
the following defaults are used (respectively) which
may cause strange values to be reported: 0.0.0, 64,
100, 8M, 0.
.TP
\fB\-\-outfile FILE\fR
After printing the report to screen, print the report
to FILE too. Internally, mysqlreport always writes the
report to a temp file first: /tmp/mysqlreport.PID on
*nix, c:\mysqlreport.PID on Windows (PID is the
script's process ID). Then it prints the temp file to
screen. Then if \-\-outfile is specified, the temp file
is copied to OUTFILE. After \-\-email (below), the temp
file is deleted.
.TP
\fB\-\-email ADDRESS\fR
After printing the report to screen, email the report
to ADDRESS. This option requires sendmail in
/usr/sbin/, therefore it does not work on Windows.
/usr/sbin/sendmail can be a sym link to qmail, for
example, or any MTA that emulates sendmail's \-t
command line option and operation. The FROM: field is
"mysqlreport", SUBJECT: is "MySQL status report".
.TP
\fB\-\-flush\-status\fR
Execute a "FLUSH STATUS;" after generating the reports.
If you do not have permissions in MySQL to do this an
error from DBD::mysql::st will be printed after the
reports.
.SH "AUTHORS"
.LP
Daniel Nichter
If mysqlreport breaks, send me a message from
http://hackmysql.com/feedback
with the error.
.SH "SEE ALSO"
.LP
mytop(1)
.LP
The comprehensive Guide To Understanding mysqlreport at
http://hackmysql.com/mysqlreportguide.
--- New file ---
+++ debian/additions/mysqlreport 07/03/02 14:38:40
#!/usr/bin/perl -w
# mysqlreport v2.5 Sep 1 2006
# http://hackmysql.com/mysqlreport
# mysqlreport makes a friendly report of important MySQL status values.
# Copyright (C) 2006 Daniel Nichter
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# The GNU General Public License is available at:
# http://www.gnu.org/copyleft/gpl.html
use strict;
use File::Temp qw(tempfile);
use DBI;
use Getopt::Long;
eval { require Term::ReadKey; };
my $RK = ($@ ? 0 : 1);
sub have_op;
my $WIN = ($^O eq 'MSWin32' ? 1 : 0);
my %op;
my %mycnf; # ~/.my.cnf
$mycnf{'user'} = $ENV{USER};
$mycnf{'pass'} = '';
my ($tmpfile_fh, $tmpfile);
my ($stat_name, $stat_val, $stat_label);
my ($major, $minor, $patch, $x); # MySQL version
my (%stats, %vars); # SHOW STATUS, SHOW VARIABLES
my (%DMS_vals, %Com_vals);
my ($dbh, $query);
my ($questions, $key_read_ratio, $key_write_ratio, $dms);
my ($key_cache_block_size, $key_buffer_used, $key_buffer_usage);
my ($qc_mem_used, $qc_hi_r, $qc_ip_r); # Query Cache
GetOptions (
\%op,
"user=s",
"password:s",
"host=s",
"port=s",
"socket=s",
"no-mycnf",
"dtq|tdq|dq",
"dms",
"com:i",
"sas",
"tab",
"qcache",
"all",
"infile=s",
"outfile=s",
"flush-status",
"email=s",
"help|?"
);
show_help_and_exit() if $op{'help'};
$op{'host'} = 'localhost' if !have_op 'host';
$op{'port'} ||= 3306;
$op{'socket'} ||= '/var/run/mysqld/mysqld.sock';
get_user_mycnf() unless $op{'no-mycnf'};
$mycnf{'user'} = $op{'user'} if have_op 'user';
if(exists $op{'password'})
{
if($op{'password'} eq '') # Prompt for password
{
Term::ReadKey::ReadMode(2) if $RK;
print "Password for database user $mycnf{'user'}: ";
chomp($mycnf{'pass'} = <STDIN>);
Term::ReadKey::ReadMode(0), print "\n" if $RK;
}
else { $mycnf{'pass'} = $op{'password'}; } # Use password given on command line
}
if($op{'all'} and not defined $op{'com'}) { $op{'com'} = 3; };
if(defined $op{'com'} and $op{'com'} == 0) { $op{'com'} = 3; }
# Connect to MySQL
if(!have_op 'infile') {
$dbh = DBI->connect("dbi:mysql::$op{host};port=$op{port};mysql_socket=$op{socket}", $mycnf{'user'}, $mycnf{'pass'}) or die;
}
# The report is written to a tmp file first.
# Later it will be moved to $op{'outfile'} or emailed $op{'email'} if needed.
($tmpfile_fh, $tmpfile) = tempfile() or die("Can't open temporary file for writing: $!\n");
# Get status values and server system variables from MySQL or -infile
get_vals_vars();
$questions = $stats{'Questions'};
$key_read_ratio = sprintf "%.2f", ($stats{'Key_read_requests'} ? $stats{'Key_reads'} / $stats{'Key_read_requests'} : 0);
$key_write_ratio = sprintf "%.2f", ($stats{'Key_write_requests'} ? $stats{'Key_writes'} / $stats{'Key_write_requests'} : 0);
$key_cache_block_size = (defined $vars{'key_cache_block_size'} ? $vars{'key_cache_block_size'} : 1024);
$key_buffer_used = $stats{'Key_blocks_used'} * $key_cache_block_size;
if(defined $stats{'Key_blocks_unused'}) { # MySQL 4.1.2+
$key_buffer_usage = $vars{'key_buffer_size'} - ($stats{'Key_blocks_unused'} * $key_cache_block_size);
}
else { $key_buffer_usage = -1; }
# Data Manipulation Statements: http://dev.mysql.com/doc/mysql/en/Data_Manipulation.html
%DMS_vals = (
SELECT => $stats{'Com_select'},
INSERT => $stats{'Com_insert'} + $stats{'Com_insert_select'},
REPLACE => $stats{'Com_replace'} + $stats{'Com_replace_select'},
UPDATE => $stats{'Com_update'} + (exists $stats{'Com_update_multi'} ? $stats{'Com_update_multi'} : 0),
DELETE => $stats{'Com_delete'} + (exists $stats{'Com_delete_multi'} ? $stats{'Com_delete_multi'} : 0)
);
$dms = $DMS_vals{SELECT} + $DMS_vals{INSERT} + $DMS_vals{REPLACE} + $DMS_vals{UPDATE} + $DMS_vals{DELETE};
# Write the report
select $tmpfile_fh;
$~ = 'KEY_BUFF_MAX', write;
if($key_buffer_usage != -1) { $~ = 'KEY_BUFF_USAGE', write }
$~ = 'KEY_RATIOS', write;
if($op{'dtq'} or $op{'all'}) { write_DTQ(); }
$~ = 'SLOW_DMS', write;
if($op{'dms'} or $op{'all'}) { write_DMS(); }
if($op{'com'} or $op{'all'}) { write_Com(); }
if($op{'sas'} or $op{'all'}) { $~ = 'SAS', write; }
if($op{'qcache'} or $op{'all'}) { write_qcache(); }
$~ = 'REPORT_END', write;
$~ = 'TAB', write if $op{'tab'};
close $tmpfile_fh and select STDOUT;
email_report($tmpfile) if have_op 'email';
cat_report($tmpfile);
if(have_op 'outfile')
{
if($WIN) { `move $tmpfile $op{outfile}`; }
else { `mv $tmpfile $op{outfile}`; }
}
else
{
if($WIN) { `del $tmpfile`; }
else { `rm -f $tmpfile`; }
}
if(!have_op 'infile')
{
if($op{'flush-status'})
{
$query = $dbh->prepare("FLUSH STATUS;");
$query->execute();
}
$query->finish();
$dbh->disconnect();
}
exit;
#
# Subroutines
#
sub show_help_and_exit
{
print <<"HELP";
mysqlreport v2.5 Sep 1 2006
mysqlreport makes a friendly report of important MySQL status values.
Command line options (abbreviations work):
--user USER Connect to MySQL as USER
--password PASS Use PASS or prompt for MySQL user's password
--host ADDRESS Connect to MySQL at ADDRESS
--port PORT Connect to MySQL at PORT
--socket SOCKET Connect to MySQL at SOCKET
--no-mycnf Don't read ~/.my.cnf
--dtq Show Distribution of Total Questions
--dms Show DMS details
--com N Show top N number of non-DMS questions
--sas Show SELECT and Sort report
--tab Show Thread, Aborts, and Bytes reports
--qcache Show Query Cache report
--all Show --dms --com 3 --sas --qcache
--infile FILE Read status values from FILE instead of MySQL
--outfile FILE Write report to FILE
--email ADDRESS Email report to ADDRESS (doesn't work on Windows)
--flush-status Issue FLUSH STATUS; after getting current values
--help Prints this
Visit http://hackmysql.com/mysqlreport for more information.
HELP
exit;
}
sub get_user_mycnf
{
return if $WIN;
open MYCNF, "$ENV{HOME}/.my.cnf" or return;
while(<MYCNF>) { $mycnf{$1} = $2 if /^(.+?)\s*=\s*"?(.+?)"?\s*$/; }
close MYCNF;
}
sub get_vals_vars
{
if(not defined $op{'infile'})
{
my @row;
# Determine MySQL version
$query = $dbh->prepare("SHOW VARIABLES LIKE 'version';");
$query->execute();
@row = $query->fetchrow_array();
($major, $minor, $patch) = ($row[1] =~ /(\d{1,2})\.(\d{1,2})\.(\d{1,2})/);
if($major == 5 && (($minor == 0 && $patch >= 2) || $minor > 0))
{
$query = $dbh->prepare("SHOW GLOBAL STATUS;");
}
else { $query = $dbh->prepare("SHOW STATUS;"); }
# Get status values
$query->execute();
while(@row = $query->fetchrow_array()) { $stats{$row[0]} = $row[1]; }
# Get server system variables
$query = $dbh->prepare("SHOW VARIABLES;");
$query->execute();
while(@row = $query->fetchrow_array()) { $vars{$row[0]} = $row[1]; }
}
else
{
# Default values if not set in INFILE
$vars{'version'} = "0.0.0";
$vars{'table_cache'} = 64;
$vars{'max_connections'} = 100;
# key_cache_block_size
$vars{'key_buffer_size'} = 8388600; # 8M
# query_cache_size
open INFILE, "< $op{infile}" or die;
while(<INFILE>)
{
next if /^\+\-/;
next if /^$/;
chomp;
if(/([A-Za-z_]+)[\s|]+(\d+)/)
{
$stats{$1} = $2;
next;
}
# Explicit var = val (e.g. key_buffer_size = 128M)
$vars{$1} = ($3 ? $2 * 1024 * 1024 : $2) and next if(/^\s*(\w+)\s*=\s*([0-9.]+)(M*)\s*$/);
# print "Unrecognized line in infile: $_\n";
}
close INFILE;
}
}
sub sec_to_dhms # Seconds to days hours:minutes:seconds
{
my $s = shift;
my ($d, $h, $m) = (0, 0, 0);
return '0 0:0:0' if $s <= 0;
if($s >= 86400)
{
$d = int $s / 86400;
$s -= $d * 86400;
}
if($s >= 3600)
{
$h = int $s / 3600;
$s -= $h * 3600;
}
$m = int $s / 60;
$s -= $m * 60;
return "$d $h:$m:$s";
}
# Copied from mytop (http://jeremy.zawodny.com/mysql/mytop/) and modified a little
sub make_short
{
my ($number, $kb) = @_;
my $n = 0;
my $short;
if(defined $kb) { while ($number > 1023) { $number /= 1024; $n++; }; }
else { while ($number > 999) { $number /= 1000; $n++; }; }
$short = sprintf "%.2f%s", $number, ('','k','M','G','T')[$n];
if($short =~ /^(.+)\.(00)$/) { return $1; } # 12.00 -> 12 but not 12.00k -> 12k
return $short;
}
sub perc # Percentage
{
my($is, $of) = @_;
return sprintf "%.2f", ($is * 100) / ($of ||= 1);
}
sub t # Time average per second
{
my $val = shift;
return sprintf "%.2f", $val / $stats{'Uptime'};
}
sub email_report # Email given report to $op{'email'}
{
return if $WIN;
my $report = shift;
open SENDMAIL, "|/usr/sbin/sendmail -t";
print SENDMAIL "From: mysqlreport\n";
print SENDMAIL "To: $op{email}\n";
print SENDMAIL "Subject: MySQL status report\n\n";
print SENDMAIL `cat $report`;
close SENDMAIL;
}
sub cat_report # Print given report to screen
{
my $report = shift;
my @report;
open REPORT, "< $report";
@report = <REPORT>;
close REPORT;
print @report;
}
sub get_Com_values
{
# Make copy of just the Com_ values
for(keys %stats)
{
if(grep /^Com_/, $_ and $stats{$_} > 0)
{
/^Com_(.*)/;
$Com_vals{$1} = $stats{$_};
}
}
# Remove DMS values
delete $Com_vals{'select'};
delete $Com_vals{'insert'};
delete $Com_vals{'insert_select'};
delete $Com_vals{'replace'};
delete $Com_vals{'replace_select'};
delete $Com_vals{'update'};
delete $Com_vals{'update_multi'} if exists $Com_vals{'update_multi'};
delete $Com_vals{'delete'};
delete $Com_vals{'delete_multi'} if exists $Com_vals{'delete_multi'};
}
sub write_DTQ # Write DTQ report in descending order by values
{
$~ = 'DTQ';
my %DTQ;
my $first = 1;
get_Com_values();
# Total Com values
$stat_val = 0;
for(values %Com_vals) { $stat_val += $_; }
$DTQ{'Com_'} = $stat_val;
$DTQ{'DMS'} = $dms;
$DTQ{'QC Hits'} = $stats{'Qcache_hits'} if $stats{'Qcache_hits'} != 0;
$DTQ{'COM_QUIT'} = int (($stats{'Connections'} - 2) - ($stats{'Aborted_clients'} / 2));
$stat_val = 0;
for(values %DTQ) { $stat_val += $_; }
if($questions != $stat_val) {
$DTQ{($questions > $stat_val ? '+Unknown' : '-Unknown')} = abs $questions - $stat_val;
}
for(sort { $DTQ{$b} <=> $DTQ{$a} } keys(%DTQ))
{
if($first) { $stat_label = '%Total:'; $first = 0; }
else { $stat_label = ''; }
$stat_name = $_;
$stat_val = $DTQ{$_};
write;
}
}
sub write_DMS # Write DMS report in descending order by values
{
$~ = 'DMS';
for(sort { $DMS_vals{$b} <=> $DMS_vals{$a} } keys(%DMS_vals))
{
$stat_name = $_;
$stat_val = $DMS_vals{$_};
write;
}
}
sub write_Com # Write COM report in descending order by values
{
$~ = 'COM_1';
get_Com_values() if !$op{'dtq'};
# Total Com values and write first line of COM report
$stat_label = '%Total:' unless $op{'dtq'};
$stat_val = 0;
for(values %Com_vals) { $stat_val += $_; }
write;
$~ = 'COM_2';
# Sort remaining Com values, print only the top $op{'com'} number of values
for(sort { $Com_vals{$b} <=> $Com_vals{$a} } keys(%Com_vals))
{
$stat_name = $_;
$stat_val = $Com_vals{$_};
write;
last if !(--$op{'com'});
}
}
sub write_qcache
{
# Query cache was added in 4.0.1, but have_query_cache was added in 4.0.2,
# ergo this method is slightly more reliable
return if not exists $vars{'query_cache_size'};
return if $vars{'query_cache_size'} == 0;
$qc_mem_used = $vars{'query_cache_size'} - $stats{'Qcache_free_memory'};
$qc_hi_r = sprintf "%.2f", $stats{'Qcache_hits'} / ($stats{'Qcache_inserts'} ||= 1);
$qc_ip_r = sprintf "%.2f", $stats{'Qcache_inserts'} / ($stats{'Qcache_lowmem_prunes'} ||= 1);
$~ = 'QCACHE';
write;
}
sub have_op
{
my $key = shift;
return 1 if (exists $op{$key} && $op{$key} ne '');
return 0;
}
#
# Formats
#
# First part of main report
format KEY_BUFF_MAX =
MySQL @<<<<<<<<<<<<<<<< uptime @<<<<<<<<<<< @>>>>>>>>>>>>>>>>>>>>>>>>
$vars{'version'}, sec_to_dhms($stats{'Uptime'}), scalar localtime
__ Key _________________________________________________________________
Buffer used @>>>>>> of @>>>>>> %Used: @>>>>>
make_short($key_buffer_used, 1), make_short($vars{'key_buffer_size'}, 1), perc($key_buffer_used, $vars{'key_buffer_size'})
| Thread |
|---|
| • bk commit into 5.0 tree (mtaylor:1.2459) | Monty Taylor | 2 Mar |
