Originally posted by Michael
View Post
Announcement
Collapse
No announcement yet.
Phoronix Been Loading Slow? It Is Hopefully Better Now
Collapse
X
-
-
Originally posted by Oden View PostYou should start to defrag the database everyday when you takes the backup.
Defrag the DB once every 24h should speed up this site very much.
Michael should be seriously considering moving away from LAMP stack and go to something more interactive performance-wise like MEAN stack that can handle traffic without too much fuss.
Comment
-
Originally posted by stephen82 View Post
If that was the case, then other bigger websites if they were implementing this idea would have been suffering from corrupted database entries more than you can imagine having as a result developing a bad reputation for their slow performance.
Michael should be seriously considering moving away from LAMP stack and go to something more interactive performance-wise like MEAN stack that can handle traffic without too much fuss.
Comparing to a totally different scenario only makes you look less knowledgeable.
And no it wouldn't and many bigger sites do this every day and it's actually needed if they use INNODB a lot.
Phoronix is pretty small and might not need to defrag so often but that can be checked by checking the fragmentation in the DB.
The defrag locks the table but it shouldn't take that long to perform a defrag if it's done regularly.
Combining defrag and optimize can do wonders on a site like phoronix.
Comment
-
Originally posted by Oden View PostI need to use tor to use phoronix, otherwise this article is the last and i still get "The forums are disabled while migrating to a new server. Back shortly!"
Comment
Comment