Closed Bug 697472 Opened 14 years ago Closed 14 years ago

Make sure MySQL runs the database on the InnoDB engine

Categories

(Pancake Graveyard :: Back-end, defect)

Product:
Pancake Graveyard
Component:
Back-end
Platform:
x86
macOS
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: oyiptong, Assigned: st3fan)

Details

(Whiteboard: [golive])

The pancake app currently uses MyISAM as db engine. MyISAM is great for reads, but does not perform well when there are both reads and writes; MyISAM locks the whole table whenever there is a write. We should specify InnoDB as the engine to use.
Fixed with the following changes: https://bitbucket.org/st3fan/fxhome/changeset/d37c533b741d https://bitbucket.org/st3fan/fxhome/changeset/ec75ddc1b364
Assignee: nobody → sarentz
Status: NEW → RESOLVED
Closed: 14 years ago
Resolution: --- → FIXED
Deployed to staging.
You need to log in before you can comment on or make changes to this bug.