FireStick 1.1 (Performance logging add-on library)

[eluser]Wible[/eluser]
I found that in MySQL 4.X I had to change the engine type from Archive to MyISAM... now it works perfectly... so, in my case, this insert works better (if you're using MySQL 4.x this might help)

CREATE DATABASE IF NOT EXISTS logs;

DROP TABLE IF EXISTS logs.firestick_log_template;
CREATE TABLE logs.firestick_log_template (
ip INT NOT NULL,
page VARCHAR(255) NOT NULL,
user_agent VARCHAR(255) NOT NULL,
referrer VARCHAR(255) NOT NULL,
logged TIMESTAMP NOT NULL
default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
memory INT UNSIGNED NOT NULL,
render_elapsed FLOAT NOT NULL,
ci_elapsed FLOAT NOT NULL,
controller_elapsed FLOAT NOT NULL,
mysql_elapsed FLOAT NOT NULL,
mysql_count_queries TINYINT UNSIGNED NOT NULL,
mysql_queries TEXT NOT NULL
) ENGINE=MyISAM;