I made a mistake in the database schema files. (Yes, I am human.)
Certain database tables use LONGTEXT fields and this can cause a the database to become quite slow over time with massive overhead. This also increases the CPU load.
I have included an update-database.zip file to correct this problem. Un-zip the file, upload the single PHP program, execute it and then delete the file.
This will convert all tables that use LONGTEXT fields to TEXT fields or VARCHAR fields based upon MySql version. This will reduce the overhead problem. A game reset is NOT needed.
We will also be making another update to the game that will take advantage of the VARCHAR update in MySql 5.0.3 and higher. These newer versions of MySql increase the maximum number from 255 to 65k characters. We will be checking on the version of MySql and using VARCHAR instead of TEXT fields in future versions. By using VARCHAR the database will be faster and use less CPU.
Attachments: |
File comment: Update Database PHP File
update-database.zip [1.27 KiB]
Downloaded 1197 times
|
_________________ PJ's Annoyingly Useless Blog
ADOdb Lite
Template Lite
|