New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
mysqlmymonlite - MySQL optimization tool (by eva2000)
I've just found this gem...
Official link: http://mysqlmymon.com/
--
What is mysqlmymonlite.sh ?
mysqlmymonlite.sh is a MySQL optimization tool - a lite version of more extensive featured mysqlmymon.sh - a MySQL and system monitoring script written by George Liu (eva2000) for quick stats check for apache, nginx, litespeed web server and mysql stats for the following operating systems:
CentOS WHM/Cpanel
CentOS
Debian 6.x systems
Thank you @eva2000 for being part of this community.
I known you from Centminmod, and now I see you've done this as well.
You are, basically, a hero. :-)
+1 kudos for you.
This discussion has been closed.
Comments
"Thus mysqlmymonlite.sh was born and is used mainly for vBulletin server optimisation requests on public forums providing nginx, apache, litespeed web server, openlitespeed web server, mysql, cpu, memory, disk usage stats and general overview of server status in order to understand a vB client's server environment and loads. All this info takes less than <12 seconds to gather once the script is run."
So is this primarily a "thank you for contacting support/posting in the help forum, to better help you, please post the output of mysqlmymonlite.sh"?
I'm trying to place it in my mind compared to mysqltuner.pl.
Glad you like. The script was created back in 2011 so it's been 6+ yrs now. I just got tired of back and forth questions I see and experienced with new clients or unknown systems for troubleshooting or optimisation advice - what server specs? server config ? server stats ? they have etc.
Especially on a public forum when someone asks for optimisation or troubleshooting advice i.e. I have high cpu usage please help etc etc. It shouldn't take several posts or back and forth to get a basic idea of a server setup. Just run mysqlmymonlite.sh and usually within less than <12 seconds you'd have enough info to go off of
Centmin Mod users are also encouraged to use it as I have a dedicated thread for discussing mysqlmymonlite.sh at https://community.centminmod.com/threads/mysqlmymonlite-sh-addon.65/
Yeah that's essentially why mysqlmymonlite.sh was created. It provides an actual and more detailed context to the statistics and output gathered as opposed to mysqltuner.pl which is just mysql specific. The mysqlmymonlite.sh also bundles a slightly modified version of mysqltuner.pl in there too for folks use to using it. Modified just to elaborate and expand on some of the recommendations that it outputs.
You can also extend mysqlmymonlite.sh with your own commands specific to your systems too via
This option allows you to create a separate includes file name it incopt.inc and place it in same directory mysqlmymonlite.sh is located in. You can add your own custom SSH bash shell commands to this incopt.inc file to further extend mysqlmymonlite.sh's functionality and usefulness
I've used this script and works pretty well, helped a bit tunning MySQL, good job, will be using it many times.
Glad to hear
There's also a mysqlreport tool command tool to complement mysqltuner command
Where can I get a copy of this or where can I buy a copy of mysqlmon.sh ?
Just use your nearest time travel machine
holy necro batman
Maybe @eva2000 can update us?
I noticed the website is experiencing an SSL redirect issue, albeit, I don't think the project is dead yet. I am in fact interested in giving it another try.
Re-opened the thread, waiting for @eva2000 to update us here
https://web.archive.org/web/20220518153621/https://mysqlmymon.com/download/mysqlmymonlite.zip
the wayback machine is kinda like time travel 😉
To me, seems eva is inactive and abandoned his/her projects. Centmin was updated in May (beta version). Stable release is insanely old.
He posted here recently. I hope all is well
Edit: https://github.com/centminmod/centminmod
Last change, June 9th.
@eva2000
@MikePT fixed the mysqlmymon.com redirect issue but that mysqlmymonlite script hasn't been updated in years lol
If you're unsure, ask on official Centmin Mod forums https://community.centminmod.com/
Make sure you're tracking the right branches as Centmin Mod has stable 124.00stable https://github.com/centminmod/centminmod/tree/124.00stable and beta branches https://community.centminmod.com/threads/centmin-mod-124-00stable-130-00beta01-releases.22673/. All active development updates go into beta https://github.com/centminmod/centminmod/tree/130.00beta01
124.00stable Commit history was June 10, 2023.
130.00beta01 Commit history https://github.com/centminmod/centminmod/commits/130.00beta01 where last commit was made July 12, 2023 so ~3 days ago
Also all commits get posted on official Centmin Mod Githut commits forum too https://community.centminmod.com/forums/centmin-mod-github-commits.41/ so folks who are not comfortable using Github, can discuss commits on the forums too so you can take the forum RSS feed for tracking too if you need to follow Centmin Mod changes
Basically, the flow of commits goes, 130.00beta01 for latest, 124.00stable and then 124.00stable to master merges usually done once a week.
Centmin Mod is far from inactive
I believe the script won't work with MariaDB?
You mean mysqlmymonlite.sh, it did work with MariaDB on cPanel way back but as I said I haven't tested or updated it in years for cPanel.
Thank you for bringing the website back online! It saddens me to know that the project is no longer active. The friendly way it worked overall made it excellent.
Yeah the script evolved to one built into my Centmin Mod LEMP stack for cminfo command https://community.centminmod.com/threads/cminfo-command-explained.11399/
Interesting. Thank you. I guess we can close this for now. Glad to see you here!