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
How to optimize your database using the mysql-tuning tool
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
5 posts
• Page 1 of 1
How to optimize your database using the mysql-tuning tool
by carpenox » Thu Aug 03, 2023 8:43 pm
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
- carpenox
- Posts: 2423
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
Re: How to optimize your database using the mysql-tuning too
by 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
by 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.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
- carpenox
- Posts: 2423
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
Re: How to optimize your database using the mysql-tuning too
by 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.
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
by 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.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
- carpenox
- Posts: 2423
- Joined: Wed Apr 08, 2020 2:02 am
- Location: St Petersburg, FL
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 45 guests