here I talk
Posts tagged optimization
MySQL: mysqltunner.pl and why to use it.
1Most of us who run a server, use the basic stuff, Apache, PHP, MySQL, to provide a web site, a blog, a forum and so on. I also use MySQL on all of my server, but when it comes to a proper optimization, not just table optimization, I’m just dump. I don’t know MySQL server as I should, to be able to provide for my web site and users the speed, stability and security which they would need.
MySQL: automatic table optimization
2A lot of you may have a server and may run MySQL. That’s not something out of the ordinary, also having 1-2 and even more databases, again its something normal. Having tables in those databases, again is quite normal, sometimes even 50-100 tables, in some case. The problem starts when you wanna make sure that those tables in those databases are working properly and they are fully optimized.
Here my problem started also, having 50-100 databases and God knows how many tables, as this aren’t my databases, are my users databases. This became an issue, how to keep them clean or optimized?
