I'm doing some reading on INSERT DELAYED
http://dev.mysql.com/doc/refman/5.0/en/insert.html
I have a user_log table:
CREATE TABLE `user_log` (
`id_user_log` bigint(20) unsigned NOT NULL auto_increment,
`id_user` int(10) unsigned default '0',
`created_on` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
`type`
enum('View','Action','Admin','Search','Login','Logout','Access','General','
API') NULL,
`source` enum('web','mobile') character set latin1 collate
latin1_general_ci default 'web',
`body` text character set latin1 collate latin1_general_ci,
) ENGINE=InnoDB
We are noticing a lot of these in the logs however:
Sep 29 03:05:02 pse05 mysqld[14640]: TRANSACTION 0 62715480, ACTIVE 0 sec,
process no 14639, OS thread id 2904791952 inserting
Sep 29 03:05:02 pse05 mysqld[14640]: mysql tables in use 1, locked 1
Sep 29 03:05:02 pse05 mysqld[14640]: LOCK WAIT 4 lock struct(s), heap size
320, undo log entries 1
Sep 29 03:05:02 pse05 mysqld[14640]: MySQL thread id 8330, query id 799424
10.10.10.46 OMT_Master update
Sep 29 03:05:02 pse05 mysqld[14640]: INSERT INTO user_log (`id_user`,
`type`, `source`, `body`) VALUES ...)
Sep 29 03:05:02 pse05 mysqld[14640]: *** (1) WAITING FOR THIS LOCK TO BE
GRANTED:
So I'm thinking we could use the DELAYED or LOW_PRIORITY.
My concern is the created_on time.
Is there any difference in the actual timestamp recorded in the database if
I use:
INSERT INTO user_log (id_user) VALUES (3);
INSERT DELAYED INTO user_log (id_user) VALUES (3);
INSERT LOW_PRIORITY INTO user_log (id_user) VALUES (3);
INSERT INTO user_log (id_user, created_on) VALUES (3, NOW());
INSERT DELAYED INTO user_log (id_user, created_on) VALUES (3, NOW());
(or set the date via PHP):
'INSERT INTO user_log (id_user, created_on) VALUES (3, '.gmdate().')';
'INSERT DELAYED INTO user_log (id_user, created_on) VALUES (3,
'.gmdate().')';
My point is, is mySQL smart enough to know what the time WAS when the
INSERT was supposed to be written by default, or if I DELAY it will it
process the NOW() at INSERT time or DELAYED time or what time is NOW() and
lastly if I set it with gmdate() in PHP, then that seems like it's the
exact server time at the right moment??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
