ALTER TABLE guest_cpu_memory CHANGE COLUMN memory_unused memory_rate TINYINT UNSIGNED NOT NULL DEFAULT 0; ALTER TABLE guest_cpu_memory ADD INDEX (memory_available); ALTER TABLE guest_cpu_memory ADD INDEX (memory_rate); UPDATE snapshot SET status=status+1 WHERE status BETWEEN 1 AND 200;