How to optimize your database using the mysql-tuning tool

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

How to optimize your database using the mysql-tuning tool

Postby carpenox » Thu Aug 03, 2023 8:43 pm

A few of you have asked me about this so I finally wrote up an article for it. This will go over how to optimize your database for vicidial or any database really.

https://dialer.one/how-to-optimize-your ... ning-tool/

Chris
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2250
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: How to optimize your database using the mysql-tuning too

Postby johnstamos » Fri Aug 04, 2023 11:44 am

This is great. Thank you Chris!
johnstamos
 
Posts: 1
Joined: Thu Jun 22, 2023 12:45 pm

Re: How to optimize your database using the mysql-tuning too

Postby carpenox » Fri Aug 04, 2023 1:04 pm

No problem, I'm taking requests this weekend. Anyone have a topic they want be to write an article on?
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2250
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: How to optimize your database using the mysql-tuning too

Postby martinch » Fri Aug 04, 2023 4:04 pm

I didn't know this tool even existed but I'm liking what I see! Thanks Chris.

Is it worth adding this to the Admin Panel to run it on demand? Maybe in System Settings?

Cheers Martin.
Project Lead @ mDial -> https://github.com/TheBlode/mDial
martinch
 
Posts: 273
Joined: Thu Nov 15, 2018 9:14 am
Location: England, UK

Re: How to optimize your database using the mysql-tuning too

Postby carpenox » Fri Aug 04, 2023 6:32 pm

No problem, ya I think it would be useful in maybe the admin utils.
Alma Linux 9.3 | SVN Version: 3822 | DB Schema Version: 1711 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3 | Discord: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2250
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 189 guests