Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.17
-
None
-
debian 7.8 x64
Description
i have a script that insert about 200 records/s to a table
about every 10min the server freeze for 30 seconds, almost all queries freeze, the cpu usage in top drops to 100%
there's no crash, no error in log
there's a lot of queries in slow log but i guess that's because of the freeze
the table:
CREATE TABLE IF NOT EXISTS `firm_db` (
|
`id` int(11) NOT NULL,
|
`name_ti` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
|
`id_number` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
|
`firm_db_id` int(11) NOT NULL,
|
`country_id` int(11) NOT NULL,
|
`name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
|
`uid` varchar(10) CHARACTER SET utf8 NOT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
|
|
ALTER TABLE `firm_db`
|
ADD PRIMARY KEY (`id`),
|
ADD UNIQUE KEY `country_firm_id` (`country_id`,`firm_db_id`),
|
ADD KEY `name_ti` (`name_ti`),
|
ADD KEY `id_number` (`id_number`),
|
ADD KEY `firm_db_id` (`firm_db_id`),
|
ADD KEY `country_id` (`country_id`),
|
ADD KEY `uid` (`uid`),
|
ADD FULLTEXT KEY `name_ft` (`name`);
|
|
|
ALTER TABLE `firm_db`
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
|