• Welcome to PHPVIBE Forums. Please log in.
avatar_Marius P.

[ Video Sharing CMS v4 ] Solving the mySQL high load

Started by Marius P.,

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Marius P.Topic starter

When renting a server I see most don't know how to configure it, or don't give any interest into documenting it  :-[  but instead complain they have an bad load when they have so much machine power.


To know: You power is 0 if you services are not properly configured! And by default they are not.

Here are some tuning tips:


https://rudd-o.com/linux-and-free-software/tuning-a-mysql-server-in-5-minutes
http://www.codingpedia.org/ama/optimizing-mysql-server-settings/
http://stackoverflow.com/questions/10905226/mysql-my-cnf-performance-tuning-recommendations


And one from me: always enable mysql cache http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/



Happy with my help? Buy me a coffee.
Please, always use the search before opening a new topic! We're all here on our (limited) free time! Make sure you help yourself too!
  •  

 

Similar topics (7)

Important Announcement: PHPVibe Video Sharing CMS End of Life

Started by Marius P.


Replies: 1
Views: 46528

The problem of video viewing PHPVibe 5.0

Started by Nayn


Replies: 25
Views: 75027

embed video does not work on v5

Started by neospider69


Replies: 6
Views: 56835

when slecting to unpublish music mp3 - next page says unpublished video ?

Started by spirog


Replies: 2
Views: 5152

insite ads issue when selecting above/below video player location

Started by georgepanaitescu


Replies: 3
Views: 26879

Video that I've uploaded needs to have that value in admin to upload

Started by spirog


Replies: 4
Views: 10034

video,playlist,images, etc. (frontend) select all deselect all reselect all

Started by spirog


Replies: 3
Views: 9665