On Tue, 21 Jun 2011 17:18:30 -0400, Dave Wreski wrote:
I'll try the suggested my.cnf changes and restart the process.
since so many have problems i share my mysql shemas :=)
please note that i expire som data not default done in current
spamassassin
-- phpMyAdmin SQL Dump
-- version 3.4.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 22, 2011 at 01:20 AM
-- Server version: 5.1.56
-- PHP Version: 5.3.6-pl0-gentoo
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
--
-- Database: `spamassassin`
--
-- --------------------------------------------------------
--
-- Table structure for table `awl`
--
CREATE TABLE IF NOT EXISTS `awl` (
`username` varchar(100) COLLATE utf8_bin NOT NULL,
`email` varchar(255) COLLATE utf8_bin NOT NULL,
`ip` varchar(40) COLLATE utf8_bin NOT NULL,
`count` int(11) NOT NULL DEFAULT '0',
`totscore` float NOT NULL DEFAULT '0',
`signedby` varchar(255) COLLATE utf8_bin NOT NULL,
`lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`username`,`email`,`signedby`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `bayes_expire`
--
CREATE TABLE IF NOT EXISTS `bayes_expire` (
`id` int(11) NOT NULL DEFAULT '0',
`runtime` int(11) NOT NULL DEFAULT '0',
KEY `bayes_expire_idx1` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `bayes_global_vars`
--
CREATE TABLE IF NOT EXISTS `bayes_global_vars` (
`variable` varbinary(30) NOT NULL,
`value` varbinary(200) NOT NULL,
PRIMARY KEY (`variable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `bayes_seen`
--
CREATE TABLE IF NOT EXISTS `bayes_seen` (
`id` int(11) NOT NULL DEFAULT '0',
`msgid` varbinary(200) NOT NULL,
`flag` binary(1) NOT NULL,
PRIMARY KEY (`id`,`msgid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `bayes_token`
--
CREATE TABLE IF NOT EXISTS `bayes_token` (
`id` int(11) NOT NULL DEFAULT '0',
`token` binary(5) NOT NULL,
`spam_count` int(11) NOT NULL DEFAULT '0',
`ham_count` int(11) NOT NULL DEFAULT '0',
`atime` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`,`token`),
KEY `bayes_token_idx1` (`id`,`atime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- --------------------------------------------------------
--
-- Table structure for table `bayes_vars`
--
CREATE TABLE IF NOT EXISTS `bayes_vars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varbinary(200) NOT NULL,
`spam_count` int(11) NOT NULL DEFAULT '0',
`ham_count` int(11) NOT NULL DEFAULT '0',
`token_count` int(11) NOT NULL DEFAULT '0',
`last_expire` int(11) NOT NULL DEFAULT '0',
`last_atime_delta` int(11) NOT NULL DEFAULT '0',
`last_expire_reduce` int(11) NOT NULL DEFAULT '0',
`oldest_token_age` int(11) NOT NULL,
`newest_token_age` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `bayes_vars_idx1` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3
;
-- --------------------------------------------------------
--
-- Table structure for table `userpref`
--
CREATE TABLE IF NOT EXISTS `userpref` (
`username` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`preference` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
`value` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`prefid` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`prefid`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1
;