In the last day I set up a second MySQL installation with its own innodb RAM buffers for Firestats, and that alone increased the performance of the gallery tremendously. With the Firestats database reaching 300MB (compressed), it was eating up valuable RAM that the Gallery uses for its 1.5GB database. Thanks to I was able to discover how to configure chkservd to monitor the second mysql process. I used mysqld_safe’s version option to run a copy of mysqld named mysqld-2. Until this problem was fixed, if one MySQL daemon died such as the most important one that runs most of the sites on the server, since there was a second process in existance chkservd would consider it still running. The final piece of the puzzle was solved by this that let me know that the last two parameters are “process name” and “users who should be running the process.”
I will post in this or a related blog any helpful info so that someday it may help another person. For now I need to see how tuning certain parameters changes performance over about a week of time.
Lastly, I was able to automate my sitemaps thanks to a . Google does not like it when there are more than 50,000 links in a sitemap, and my site has almost 200,000.
In the background, I’ve also recompiled Apache, PHP, all of its modules, and Cpanel’s PHP so everyone can enjoy faster speed on the server. I found some disk i/o enhancements that will also help.
Post a Comment