Temporarily Disabled MySQL Update for Man Pages Post: 303040463

Sponsored Content

The Lounge What is on Your Mind? Temporarily Disabled MySQL Update for Man Pages Post 303040463 by Neo on Wednesday 30th of October 2019 12:42:59 AM

10-30-2019

Administrator

Temporarily Disabled MySQL Update for Man Pages

I had some code in place to update the MySQL man page DB 'on the fly' but this database has grown so big over time (now over 7 GB, 7.1 GB to be exact) that the update query was causing the man page rendering to slow down to a crawl.

So, I just disabled updating the table 'on the fly' so the pages will load fast again.

It was not the number of rows causing the problem but something else:

Code:

mysql> select count(*) from `neo_man_page_entry`;
+----------+
| count(*) |
+----------+
|   347938 |
+----------+
1 row in set (0.00 sec)

Which I think is related to indexing in that table and the update query.

So, I'll revisit and fix this at a later time.

For now, I man pages are loading fast again.

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

4 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Man pages

Hello , I just installed openssh in my system . I actually tried to man sshd but it says no entry , though there is a man directory in the installation which have the man pages for sshd . Can anyone tell me how should i install these man pages . DP

2. UNIX for Dummies Questions & Answers

man pages

Hi, I've written now a man pages, but I don't knwo how to get 'man' to view them. Where have I to put this files, which directories are allowed?? THX Bensky

3. Programming

Man pages for C API for MySql

Hi, I am on Ubuntu 9.04 tweaking some programs demanding MySql queries. I got the program working by installing following package: sudo apt-get install libmysqlclient-dev and using proper include and library folder However I was unable to access any man pages for these C api's (Strangely...

4. HP-UX

Looking for some man pages.

Can anyone supply me with the man pages for: omnidatalist omnibarlist omnisap.exe I prefer the source man pages in nroff format. A clue about the software bundles which supply these man pages is fine as well. OS: HP-UX TIA

LEARN ABOUT OPENSOLARIS

isamlog

isamlog(1)							  MySQL database							isamlog(1)

NAME

       isamlog - Write info about whats in a nisam log file.

USAGE

       isamlog [-?iruvIV] [-c #] [-f #] [-F filepath/] [-o #] [-R file recordpos] [-w write_file] [log-filename [table ...]]

SYNOPSIS

       isamlog [-?|-I] [-V] [-c] [-f] [-F] [-i] [-o] [-p #] [-r] [-R] [-u] [-v] [-w]

DESCRIPTION

       isamlog

       -?|-I  info

       -V     version

       -c     do only # commands

       -f     max open files

       -F     file path

       -i     extra info

       -o     offset

       -p #   remove # components from path

       -r     recover

       -R     file recordposition

       -u     update

       -v     verbose

       -w     write file

NOTE

       If  no  file name is given isam.log is used One can give a second and a third '-v' for more verbose.  Normaly one does a update (-u).  If a
       recover is done all writes and all possibly updates and deletes is done and errors are only counted.  If one gives table names as arguments
       only these tables will be updated

SEE ALSO

       isamchk(1),   mysql(1),	 mysqlaccess(1),   mysqladmin(1),   mysqld(1),	mysqld_multi(1),  mysqld_safe(1),  mysqldump(1),  mysql_fix_privi-
       lege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1)

       For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available  online
       at http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.com)

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES

       Source for mysql is available on http://opensolaris.org.

MySQL 4.0							 19 December 2000							isamlog(1)