-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Christian Hammers wrote:
| If you need the data, contact MySQL support for a quick answer. I'm right back | from holidays and currently have not too much time :) But will try to | reproduce it. The data is not important, it's a copy of our database taken from backups, for the purpose of testing InnoDB's crash recovery. | If possible attach your "CREATE" statement and your my.cnf so that we can see | which options you used to create the database. Probably it's just a single | option that makes problems) Here is the my.cnf: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking bind-address = 127.0.0.1 # # * Fine Tuning # key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K # # * Query Cache Configuration # query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 log-bin = /var/log/mysql/mysql-bin.log max_binlog_size = 104857600 skip-bdb [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M And (some of) the CREATE statements: DROP TABLE IF EXISTS `accountnotes`; CREATE TABLE `accountnotes` ( ~ `noteid` int(11) NOT NULL auto_increment, ~ `clientid` int(11) NOT NULL default '0', ~ `stamp` timestamp(14) NOT NULL, ~ `author` tinytext NOT NULL, ~ `note` text NOT NULL, ~ PRIMARY KEY (`noteid`), ~ KEY `clientid` (`clientid`,`stamp`) ) TYPE=InnoDB; DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( ~ `clientid` int(11) NOT NULL auto_increment, ~ `listlimit` int(11) default NULL, ~ `sublimit` int(11) default NULL, ~ `forward` int(11) default NULL, ~ `flist` int(11) default NULL, ~ `arclimit` int(11) default '0', ~ `tref` int(11) default NULL, ~ `expire` varchar(14) default NULL, ~ `login` varchar(50) default NULL, ~ `pass` varchar(50) default NULL, ~ `active` int(11) default '1', ~ `reason` varchar(100) default NULL, ~ `demo` int(11) default '0', ~ `mode` int(11) default '0', ~ `fname` varchar(50) default NULL, ~ `lname` varchar(50) default NULL, ~ `businessname` varchar(100) default NULL, ~ `title` varchar(75) default NULL, ~ `url` varchar(250) default NULL, ~ `email` varchar(100) default NULL, ~ `street` varchar(250) NOT NULL default '', ~ `city` varchar(50) NOT NULL default '', ~ `state` char(2) NOT NULL default '', ~ `zip` varchar(10) NOT NULL default '', ~ `phone` varchar(25) default NULL, ~ `tollfree` varchar(25) default NULL, ~ `fax` varchar(25) default NULL, ~ `ref` int(11) default NULL, ~ `setdate` varchar(14) default NULL, ~ `cu` int(11) default NULL, ~ `bstreet` varchar(250) default NULL, ~ `bcity` varchar(50) default NULL, ~ `bstate` char(2) default NULL, ~ `bzip` varchar(10) default NULL, ~ `phone2` varchar(25) default NULL, ~ `perc` float default NULL, ~ `refer` int(11) default NULL, ~ `refer2` int(11) default NULL, ~ `perc2` float default NULL, ~ `rate` float default NULL, ~ `term` int(11) default '0', ~ `planid` int(11) default NULL, ~ `country` varchar(100) default NULL, ~ `affiliate` int(11) default '0', ~ `autorunerror` varchar(255) default NULL, ~ `bcountry` varchar(100) default NULL, ~ `logoid` int(11) default NULL, ~ `imagelimit` int(11) NOT NULL default '500', ~ `brand` varchar(30) NOT NULL default '', ~ `footer` varchar(30) NOT NULL default 'footer1', ~ `multiplier` decimal(6,5) NOT NULL default '1.00000', ~ `affiliatemultiplier` decimal(6,5) NOT NULL default '1.00000', ~ `referrer` int(11) default NULL, ~ `stopdate` date default NULL, ~ `startdate` date default NULL, ~ `poweredby` tinyint(4) NOT NULL default '1', ~ `enable_sbt` tinyint(4) NOT NULL default '0', ~ `verified` tinyint(4) NOT NULL default '0', ~ `editor` tinyint(1) NOT NULL default '0', ~ `site_tracking` tinyint(1) NOT NULL default '0', ~ `enable_tour` int(1) NOT NULL default '1', ~ UNIQUE KEY `clientid` (`clientid`), ~ UNIQUE KEY `login` (`login`) ) TYPE=InnoDB; DROP TABLE IF EXISTS `accountvalue`; CREATE TABLE `accountvalue` ( ~ `clientid` int(11) NOT NULL default '0', ~ `name` char(50) NOT NULL default '', ~ `value` char(100) NOT NULL default '', ~ PRIMARY KEY (`clientid`,`name`) ) TYPE=InnoDB; DROP TABLE IF EXISTS `auto_responder_event`; CREATE TABLE `auto_responder_event` ( ~ `auto_responder_event_id` int(11) NOT NULL auto_increment, ~ `auto_responder_id` int(20) NOT NULL default '0', ~ `client_id` int(20) NOT NULL default '0', ~ `message_id` int(20) NOT NULL default '0', ~ `event_type` varchar(100) default NULL, ~ `event_key` varchar(200) default NULL, ~ `event_value` varchar(200) default NULL, ~ `last_modified_date` timestamp(14) NOT NULL, ~ `send_date_string` varchar(100) default NULL, ~ `group_id` int(10) default '0', ~ PRIMARY KEY (`auto_responder_event_id`) ) TYPE=InnoDB; DROP TABLE IF EXISTS `auto_responder_log`; CREATE TABLE `auto_responder_log` ( ~ `auto_responder_id` int(11) NOT NULL default '0', ~ `event_id` int(11) NOT NULL default '0', ~ `subscriberid` int(11) NOT NULL default '0', ~ `send_date` datetime NOT NULL default '0000-00-00 00:00:00', ~ PRIMARY KEY (`auto_responder_id`,`event_id`,`subscriberid`) ) TYPE=InnoDB; DROP TABLE IF EXISTS `auto_responder`; CREATE TABLE `auto_responder` ( ~ `auto_responder_id` int(11) NOT NULL auto_increment, ~ `auto_responder_name` varchar(100) NOT NULL default '', ~ `auto_responder_desc` text, ~ `auto_responder_from_name` varchar(100) NOT NULL default '', ~ `auto_responder_from_address` varchar(100) NOT NULL default '', ~ `group_id` int(10) NOT NULL default '0', ~ `auto_responder_type` varchar(40) NOT NULL default '', ~ `client_id` int(20) NOT NULL default '0', ~ `create_date` int(20) NOT NULL default '0', ~ `last_modified_date` timestamp(14) NOT NULL, ~ `list_id` int(20) NOT NULL default '0', ~ PRIMARY KEY (`auto_responder_id`) ) TYPE=InnoDB; And so on. The database is ~19GB of text files, ~42 when its all stored in the InnoDB tablespace. | | bye, | | -christian- | Thanks, Ian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFDKYEGwsRpgTiXSOERAu5AAJ44uSrhJlvrdf55btI2mjkMKZlkTgCeIk3f Q/he+Gi44YyTvBuubnZ0sWs= =4bp1 -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
