search

aadl / summergame

Code that runs the AADL Summer Game
http://play.aadl.org
GNU General Public License v2.0
5 stars 2 forks source link

MyISAM Table Conversion #86

Open eby opened 1 year ago

eby commented 1 year ago

sg_badges and sg_game_codes still need to be converted to INNODB. Right now every select requires a table lock so if there are multiple selects at once on the database, the rest have to wait.

The tables themselves seem small so I can probably plan some quick downtown to alter the tables, but if someone wants to test on their local installs that would be great.

mswinehart commented 1 year ago

I didn't run into any issues locally after altering these tables to use the innodb engine once the prod db sg_ledger was mirrored. I created new badges, new codes, and completed those codes. Everything seemed to work fine.