CREATE TABLE audit_archive (
id INT AUTO_INCREMENT PRIMARY KEY,
event_name VARCHAR(64),
logged_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FULLTEXT (event_name)
) ENGINE = MyISAM;
-- Table-level locking: a write lock blocks all other readers/writers
LOCK TABLES audit_archive WRITE;
INSERT INTO audit_archive (event_name) VALUES ('server_start');
UNLOCK TABLES;
-- Maintenance specific to MyISAM
CHECK TABLE audit_archive;
REPAIR TABLE audit_archive;
OPTIMIZE TABLE audit_archive;
CREATE TABLE audit_archive (
id INT AUTO_INCREMENT PRIMARY KEY,
event_name VARCHAR(64),
logged_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FULLTEXT (event_name)
) ENGINE = MyISAM;
-- Table-level locking: a write lock blocks all other readers/writers
LOCK TABLES audit_archive WRITE;
INSERT INTO audit_archive (event_name) VALUES ('server_start');
UNLOCK TABLES;
-- Maintenance specific to MyISAM
CHECK TABLE audit_archive;
REPAIR TABLE audit_archive;
OPTIMIZE TABLE audit_archive;