Repair & Optimize all Mysql Databases one liner

BySumGuy 2013-07-172024-09-27

Linux

Mysql tuner telling you to optimize your tables? or you just happen to be bored? Mysql optimize Reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that table. This statement does not work with views. You should use OPTIMIZE TABLE in these cases, depending on the type of table:

After doing substantial insert, update, or delete operations on an InnoDB table that has its own .ibd file because it was created with the innodb_file_per_table option enabled. The table and indexes are reorganized, and disk space can be reclaimed for use by the operating system.
After deleting a large part of a MyISAM or ARCHIVE table, or making many changes to a MyISAM or ARCHIVE table with variable-length rows (tables that have VARCHAR, VARBINARY, BLOB, or TEXT columns). Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file. After extensive changes to a table, this statement may also improve performance of statements that use the table, sometimes significantly.

This statement requires SELECT and INSERT privileges for the table. well use this one liner to repair/optimize all your DBs in one go.

mysqlcheck --auto-repair --optimize --all-databases

voila!

SumGuy

Linux | nginx | Virtualization

Nginx ProxMox Proxy using Letsencrypt SSL cert

BySumGuy 2019-08-032024-09-27

Linux

Tmux for Streamlining Dev Workflow

BySumGuy 2024-06-222024-06-23

In this advanced tmux guide, we delve into enhanced productivity techniques: automate your setup using scriptable commands to establish a pre-configured development environment, efficiently manage multiple sessions, and reshape your workspace by rotating or zooming panes. Learn how to link windows across sessions for a unified workflow, and use hooks to trigger actions post specific events. Master these tmux skills to streamline your command-line operations, elevating both your efficiency and control over terminal sessions.

PHP | tuts | Virtualization | Web

Install a php script in PHP-FPM & Caddy via Docker

BySumGuy 2023-02-252023-02-25

Install docker Either regular docker install or rootless. Create a new directory Create a new directory where you will store your Docker Compose file and PHP/html etc files. For example, you can create a directory called “phpapp” in your home directory: write a docker compose file paste the below code in a new file called…

General | Linux

SumGuy’s Guide to Linux Log Analysis

BySumGuy 2024-02-212024-02-19

Linux log files hold a wealth of information on system health, security, and performance. This guide demystifies log analysis, explaining where to find essential logs and how to use tools like ‘grep’ and ‘awk’ to pinpoint problems. Discover practical examples for spotting errors, investigating security concerns, and monitoring system behavior. Mastering log analysis transforms these data-rich files into an invaluable toolkit for any Linux administrator.

Linux | shell

Screen start issues

BySumGuy 2013-05-272024-09-27

General | Linux

Linux System Monitoring: Tools and Techniques

BySumGuy 2024-02-222024-02-20

Optimize your Linux systems for peak performance and prevent downtime. This expert guide explores must-have tools and strategies for effective Linux monitoring, covering CPU, memory, disk, network, and process insights.