Sunday, January 29, 2012

Re: LOG_FATAL_DEATH

instance: gbsupportemails:rekby-test-0
database: gb_support2
steps: execute DELETE FROM email;
schema:
CREATE TABLE IF NOT EXISTS `email` (
  `id` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `time` datetime NOT NULL,
  `from` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `time` (`time`),
  FULLTEXT KEY `email_full_text` (`text`,`from`,`to`,`subject`,`comment`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Table have 76514 items.
Size of instance  662 MB.
Instance have only one database with one table.


No comments:

Post a Comment