linux – 运行OPTIMIZE TABLE对表进行碎片整理以获得更好的性能

概述我正在运行 Linux 64位 *** 作系统.我的mysql调谐器说的是以下内容： -------- General Statistics --------------------------------------------------[--] Skipped version check for MySQLTuner script[OK] Currently running supported 我正在运行 Linux 64位 *** 作系统.我的MysqL调谐器说的是以下内容：

-------- General Statistics --------------------------------------------------[--] Skipped version check for MysqLTuner script[OK] Currently running supported MysqL version 5.1.61-log[OK] Operating on 64-bit architecture-------- Storage Engine Statistics -------------------------------------------[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster[--] Data in MyISAM tables: 1G (tables: 1914)[--] Data in InnoDB tables: 4M (tables: 199)[!!] Total fragmented tables: 296-------- Security Recommendations  -------------------------------------------[OK] All database users have passwords assigned-------- Performance Metrics -------------------------------------------------[--] Up for: 6s (7K q [1K qps],142 conn,TX: 8M,RX: 701K)[--] Reads / Writes: 97% / 3%[--] Total buffers: 1.7G global + 13.2M per thread (384 max threads)[OK] Maximum possible memory usage: 6.6G (42% of installed RAM)[OK] Slow querIEs: 0% (0/7K)[OK] Highest usage of available connections: 5% (20/384)[OK] Key buffer size / total MyISAM indexes: 1.5G/2.7G[OK] Key buffer hit rate: 97.4% (553K cached / 14K reads)[OK] query cache efficIEncy: 64.6% (4K cached / 6K selects)[OK] query cache prunes per day: 0[OK] Sorts requiring temporary tables: 0% (2 temp sorts / 337 sorts)[OK] Temporary tables created on disk: 8% (17 on disk / 198 total)[OK] Thread cache hit rate: 85% (20 created / 142 connections)[OK] table cache hit rate: 98% (438 open / 445 opened)[OK] Open file limit used: 10% (856/8K)[OK] table locks acquired immediately: 99% (2K immediate / 2K locks)[OK] InnoDB data size / buffer pool: 4.2M/8.0M-------- Recommendations -----------------------------------------------------General recommendations:    Run OPTIMIZE table to defragment tables for better performance    MysqL started within last 24 hours - recommendations may be inaccurate

他们的建议是运行OPTIMIZE table来对表进行碎片整理以获得更好的性能;但我不知道如何通过Putty运行它.

是否有人可以给我代码如何通过Putty运行它？

解决方法 OPTIMIZE table是一个SQL语句 – 在MysqL客户端中运行它.

在服务器的命令行上,您应该安装命令行客户端;您可以使用MysqL -u username -p连接到客户端中的数据库.

有关更多信息,请参见documentation on OPTIMIZE TABLE.

总结

以上是内存溢出为你收集整理的linux – 运行OPTIMIZE TABLE对表进行碎片整理以获得更好的性能全部内容，希望文章能够帮你解决linux – 运行OPTIMIZE TABLE对表进行碎片整理以获得更好的性能所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。