← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-updates

« back to all changes in this revision

Viewing changes to man/myisampack.1

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-07-16 13:59:34 UTC
  • mfrom: (1.1.18)
  • Revision ID: package-import@ubuntu.com-20150716135934-plzpylrt211i3se4
Tags: 5.5.44-0ubuntu0.12.04.1
https://launchpad.net/bugs/1475294
* SECURITY UPDATE: Update to 5.5.44 to fix security issues (LP: #1475294)
  - http://www.oracle.com/technetwork/topics/security/cpujul2015-2367936.html
  - CVE-2015-2582
  - CVE-2015-2620
  - CVE-2015-2643
  - CVE-2015-2648
  - CVE-2015-4737
  - CVE-2015-4752
  - CVE-2015-4757

Show diffs side-by-side

added added

removed removed

Lines of Context:
man/myisampack.1
2
2
.\"     Title: \fBmyisampack\fR
3
3
.\"    Author: [FIXME: author] [see http://docbook.sf.net/el/author]
4
4
.\" Generator: DocBook XSL Stylesheets v1.78.1 <http://docbook.sf.net/>
5
 
.\"      Date: 02/26/2015
 
5
.\"      Date: 05/02/2015
6
6
.\"    Manual: MySQL Database System
7
7
.\"    Source: MySQL 5.5
8
8
.\"  Language: English
9
9
.\"
10
 
.TH "\FBMYISAMPACK\FR" "1" "02/26/2015" "MySQL 5\&.5" "MySQL Database System"
 
10
.TH "\FBMYISAMPACK\FR" "1" "05/02/2015" "MySQL 5\&.5" "MySQL Database System"
11
11
.\" -----------------------------------------------------------------
12
12
.\" * Define some portability stuff
13
13
.\" -----------------------------------------------------------------
115
115
extension\&.
116
116
.PP
117
117
After you compress a table with
118
 
\fBmyisampack\fR, you should use
 
118
\fBmyisampack\fR, use
119
119
\fBmyisamchk \-rq\fR
120
120
to rebuild its indexes\&.
121
121
\fBmyisamchk\fR(1)\&.
449
449
\- Compressing file
450
450
87\&.14%
451
451
Remember to run myisamchk \-rq on compressed tables
 
452
shell> \fBmyisamchk \-rq station\fR
 
453
\- check record delete\-chain
 
454
\- recovering (with sort) MyISAM\-table \*(Aqstation\*(Aq
 
455
Data records: 1192
 
456
\- Fixing index 1
 
457
\- Fixing index 2
 
458
shell> \fBmysqladmin \-uroot flush\-tables\fR
452
459
shell> \fBls \-l station\&.*\fR
453
460
\-rw\-rw\-r\-\-   1 monty    my         127874 Apr 17 19:00 station\&.MYD
454
461
\-rw\-rw\-r\-\-   1 monty    my          55296 Apr 17 19:04 station\&.MYI
826
833
.RE
827
834
.PP
828
835
After you run
829
 
\fBmyisampack\fR, you must run
 
836
\fBmyisampack\fR, use
830
837
\fBmyisamchk\fR
831
838
to re\-create any indexes\&. At this time, you can also sort the index blocks and create statistics needed for the MySQL optimizer to work more efficiently:
832
839
.sp