Re: mysql got signal 6 and restarted twice in last 2 days
Thanks Peter,
Error same as first post (to reduce content here), create table , memory and innodb related parameter as below.
CREATE TABLE `tbl_c` (
`1` bigint(20) NOT NULL AUTO_INCREMENT,
`2` bigint(20) DEFAULT NULL,
`2` bigint(20) DEFAULT NULL,
`4` bigint(20) NOT NULL,
`5` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`6` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`7` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`8` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`9` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`10` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`11` bigint(20) DEFAULT NULL,
`12` bigint(20) DEFAULT NULL,
`13` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`14` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
`15` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`16` bigint(20) DEFAULT NULL
`17` bigint(20) DEFAULT NULL
`18` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`19` bigint(20) DEFAULT NULL,
`20` bigint(20) DEFAULT NULL
`21` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`22` bigint(20) DEFAULT NULL,
`23` bigint(20) DEFAULT NULL
`24` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`25` bigint(20) DEFAULT NULL,
`26` bigint(20) DEFAULT NULL
`27` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`28` bigint(20) DEFAULT NULL,
`29` bigint(20) DEFAULT NULL
`30` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`31` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`32` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`33` bigint(20) DEFAULT NULL,
`34` timestamp NULL DEFAULT NULL,
`35` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`36` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`37` bigint(20) DEFAULT NULL,
`38` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`39` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
`40` bigint(20) DEFAULT NULL,
`41` bigint(20) NOT NULL DEFAULT '0',
`42` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`43` tinyint(1) NOT NULL DEFAULT '0',
`44` bigint(20) NOT NULL DEFAULT '0',
`45` timestamp NOT NULL DEFAULT '1975-01-01 00:00:00',
PRIMARY KEY (`1`,`45`),
KEY `ind_1` (`11`),
KEY `idx_2` (`2`),
KEY `3` (`3`),
KEY `idx_3` (`3`),
KEY `comp` (`3`,`11`,`41`),
KEY `c_txn_id` (`1`),
KEY `c_bonus_close_time` (`45`),
KEY `c_updated_time` (`35`),
KEY `c_transaction_type` (`15`),
KEY `c_ecr_bonus_id` (`41 `)
) ENGINE=InnoDB AUTO_INCREMENT=269956900 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
/*!50100 PARTITION BY RANGE (UNIX_TIMESTAMP(45))
(PARTITION p01 VALUES LESS THAN (315529200) ENGINE = InnoDB,
PARTITION p02 VALUES LESS THAN (1451170800) ENGINE = InnoDB,
PARTITION p03 VALUES LESS THAN (1467496800) ENGINE = InnoDB,
PARTITION p04 VALUES LESS THAN (1468101600) ENGINE = InnoDB,
PARTITION p05 VALUES LESS THAN (1468706400) ENGINE = InnoDB,
PARTITION p06 VALUES LESS THAN (1469311200) ENGINE = InnoDB,
PARTITION p07 VALUES LESS THAN (1469916000) ENGINE = InnoDB,
PARTITION p08 VALUES LESS THAN (1470520800) ENGINE = InnoDB,
PARTITION p09 VALUES LESS THAN (1471125600) ENGINE = InnoDB,
PARTITION p10 VALUES LESS THAN (1471730400) ENGINE = InnoDB,
PARTITION p11 VALUES LESS THAN (1472335200) ENGINE = InnoDB,
PARTITION p12 VALUES LESS THAN (1472940000) ENGINE = InnoDB,
PARTITION p13 VALUES LESS THAN (1473544800) ENGINE = InnoDB,
PARTITION p14 VALUES LESS THAN (1474149600) ENGINE = InnoDB,
PARTITION p15 VALUES LESS THAN (1474754400) ENGINE = InnoDB,
PARTITION p16 VALUES LESS THAN (1475359200) ENGINE = InnoDB,
PARTITION p17 VALUES LESS THAN (1475964000) ENGINE = InnoDB,
PARTITION p18 VALUES LESS THAN (1476568800) ENGINE = InnoDB,
PARTITION p19 VALUES LESS THAN (1477173600) ENGINE = InnoDB,
PARTITION p20 VALUES LESS THAN (1477778400) ENGINE = InnoDB,
PARTITION p21 VALUES LESS THAN (1478386800) ENGINE = InnoDB,
PARTITION p22 VALUES LESS THAN (1478991600) ENGINE = InnoDB,
PARTITION p23 VALUES LESS THAN (1479596400) ENGINE = InnoDB,
PARTITION p24 VALUES LESS THAN (1480201200) ENGINE = InnoDB,
PARTITION p25 VALUES LESS THAN (1480806000) ENGINE = InnoDB,
PARTITION p26 VALUES LESS THAN (1481410800) ENGINE = InnoDB,
PARTITION p27 VALUES LESS THAN (1482015600) ENGINE = InnoDB,
PARTITION p28 VALUES LESS THAN (1482620400) ENGINE = InnoDB,
PARTITION p29 VALUES LESS THAN (1483225200) ENGINE = InnoDB,
PARTITION p30 VALUES LESS THAN (1483830000) ENGINE = InnoDB,
PARTITION p31 VALUES LESS THAN (1484434800) ENGINE = InnoDB,
PARTITION p32 VALUES LESS THAN (1485039600) ENGINE = InnoDB,
PARTITION p33 VALUES LESS THAN (1485644400) ENGINE = InnoDB,
PARTITION p34 VALUES LESS THAN (1486249200) ENGINE = InnoDB,
PARTITION p35 VALUES LESS THAN (1486854000) ENGINE = InnoDB,
PARTITION p36 VALUES LESS THAN (1487458800) ENGINE = InnoDB,
PARTITION p37 VALUES LESS THAN (1488063600) ENGINE = InnoDB,
PARTITION p38 VALUES LESS THAN (1488668400) ENGINE = InnoDB,
PARTITION p39 VALUES LESS THAN (1489273200) ENGINE = InnoDB,
PARTITION p40 VALUES LESS THAN (1489878000) ENGINE = InnoDB,
PARTITION p41 VALUES LESS THAN (1490482800) ENGINE = InnoDB,
PARTITION p42 VALUES LESS THAN (1491084000) ENGINE = InnoDB,
PARTITION p43 VALUES LESS THAN (1491688800) ENGINE = InnoDB,
PARTITION p44 VALUES LESS THAN (1492293600) ENGINE = InnoDB,
PARTITION p45 VALUES LESS THAN (1492898400) ENGINE = InnoDB,
PARTITION p46 VALUES LESS THAN (1493503200) ENGINE = InnoDB,
PARTITION p47 VALUES LESS THAN (1494108000) ENGINE = InnoDB,
PARTITION p48 VALUES LESS THAN (1494712800) ENGINE = InnoDB,
PARTITION p49 VALUES LESS THAN (1495317600) ENGINE = InnoDB,
PARTITION p50 VALUES LESS THAN (1495922400) ENGINE = InnoDB,
PARTITION p51 VALUES LESS THAN (1496527200) ENGINE = InnoDB,
PARTITION p52 VALUES LESS THAN (1497132000) ENGINE = InnoDB,
PARTITION p53 VALUES LESS THAN (1497736800) ENGINE = InnoDB,
PARTITION p54 VALUES LESS THAN (1498341600) ENGINE = InnoDB,
PARTITION p55 VALUES LESS THAN (1498946400) ENGINE = InnoDB,
PARTITION p56 VALUES LESS THAN (1499551200) ENGINE = InnoDB,
PARTITION p57 VALUES LESS THAN (1500156000) ENGINE = InnoDB,
PARTITION p58 VALUES LESS THAN (1500760800) ENGINE = InnoDB,
PARTITION p59 VALUES LESS THAN (1501365600) ENGINE = InnoDB,
PARTITION p60 VALUES LESS THAN (1501970400) ENGINE = InnoDB,
PARTITION p61 VALUES LESS THAN (1502575200) ENGINE = InnoDB,
PARTITION p62 VALUES LESS THAN (1503180000) ENGINE = InnoDB,
PARTITION p63 VALUES LESS THAN (1503784800) ENGINE = InnoDB,
PARTITION p64 VALUES LESS THAN (1504389600) ENGINE = InnoDB,
PARTITION p65 VALUES LESS THAN (1504994400) ENGINE = InnoDB,
PARTITION p66 VALUES LESS THAN (1505599200) ENGINE = InnoDB,
PARTITION p67 VALUES LESS THAN (1506204000) ENGINE = InnoDB,
PARTITION p68 VALUES LESS THAN (1506808800) ENGINE = InnoDB,
PARTITION p69 VALUES LESS THAN (1507413600) ENGINE = InnoDB,
PARTITION p70 VALUES LESS THAN (1508018400) ENGINE = InnoDB,
PARTITION p71 VALUES LESS THAN (1508623200) ENGINE = InnoDB,
PARTITION p72 VALUES LESS THAN (1509228000) ENGINE = InnoDB,
PARTITION p73 VALUES LESS THAN (1509836400) ENGINE = InnoDB,
PARTITION p74 VALUES LESS THAN (1510441200) ENGINE = InnoDB,
PARTITION p75 VALUES LESS THAN (1511046000) ENGINE = InnoDB,
PARTITION p76 VALUES LESS THAN (1511650800) ENGINE = InnoDB,
PARTITION p77 VALUES LESS THAN (1512255600) ENGINE = InnoDB,
PARTITION p78 VALUES LESS THAN (1512860400) ENGINE = InnoDB,
PARTITION p79 VALUES LESS THAN (1513465200) ENGINE = InnoDB,
PARTITION p80 VALUES LESS THAN (1514070000) ENGINE = InnoDB,
PARTITION p81 VALUES LESS THAN (1514674800) ENGINE = InnoDB,
PARTITION p82 VALUES LESS THAN (1515193200) ENGINE = InnoDB,
PARTITION p83 VALUES LESS THAN (1515798000) ENGINE = InnoDB,
PARTITION p84 VALUES LESS THAN (1516402800) ENGINE = InnoDB,
PARTITION p85 VALUES LESS THAN (1517007600) ENGINE = InnoDB,
PARTITION p86 VALUES LESS THAN (1517612400) ENGINE = InnoDB,
PARTITION p87 VALUES LESS THAN (1518217200) ENGINE = InnoDB,
PARTITION p88 VALUES LESS THAN (1518822000) ENGINE = InnoDB,
PARTITION p89 VALUES LESS THAN (1519426800) ENGINE = InnoDB,
PARTITION p90 VALUES LESS THAN (1520031600) ENGINE = InnoDB,
PARTITION p91 VALUES LESS THAN (1520636400) ENGINE = InnoDB,
PARTITION p92 VALUES LESS THAN (1521241200) ENGINE = InnoDB,
PARTITION p93 VALUES LESS THAN (1521846000) ENGINE = InnoDB,
PARTITION p94 VALUES LESS THAN (1522447200) ENGINE = InnoDB,
PARTITION p95 VALUES LESS THAN (1523052000) ENGINE = InnoDB,
PARTITION p96 VALUES LESS THAN (1523656800) ENGINE = InnoDB,
PARTITION p97 VALUES LESS THAN (1524261600) ENGINE = InnoDB,
PARTITION p98 VALUES LESS THAN (1524866400) ENGINE = InnoDB,
PARTITION p99 VALUES LESS THAN (1525471200) ENGINE = InnoDB,
PARTITION p100 VALUES LESS THAN (1526076000) ENGINE = InnoDB,
PARTITION p101 VALUES LESS THAN (1526680800) ENGINE = InnoDB,
PARTITION p102 VALUES LESS THAN (1527285600) ENGINE = InnoDB,
PARTITION p103 VALUES LESS THAN (1527890400) ENGINE = InnoDB,
PARTITION p104 VALUES LESS THAN (1528495200) ENGINE = InnoDB,
PARTITION p105 VALUES LESS THAN (1529100000) ENGINE = InnoDB,
PARTITION p106 VALUES LESS THAN (1529704800) ENGINE = InnoDB,
PARTITION p107 VALUES LESS THAN (1530309600) ENGINE = InnoDB,
PARTITION p108 VALUES LESS THAN (1530914400) ENGINE = InnoDB,
PARTITION p109 VALUES LESS THAN (1531519200) ENGINE = InnoDB,
PARTITION p110 VALUES LESS THAN (1532124000) ENGINE = InnoDB,
PARTITION p111 VALUES LESS THAN (1532728800) ENGINE = InnoDB,
PARTITION p112 VALUES LESS THAN (1533333600) ENGINE = InnoDB,
PARTITION p113 VALUES LESS THAN (1533938400) ENGINE = InnoDB,
PARTITION p114 VALUES LESS THAN (1534543200) ENGINE = InnoDB,
PARTITION p115 VALUES LESS THAN (1535148000) ENGINE = InnoDB,
PARTITION p116 VALUES LESS THAN (1535752800) ENGINE = InnoDB,
PARTITION p117 VALUES LESS THAN (1536357600) ENGINE = InnoDB,
PARTITION p118 VALUES LESS THAN (1536962400) ENGINE = InnoDB,
PARTITION p119 VALUES LESS THAN (1537567200) ENGINE = InnoDB,
PARTITION p120 VALUES LESS THAN (1538172000) ENGINE = InnoDB,
PARTITION p121 VALUES LESS THAN (1538776800) ENGINE = InnoDB,
PARTITION p122 VALUES LESS THAN (1539381600) ENGINE = InnoDB,
PARTITION p123 VALUES LESS THAN (1539986400) ENGINE = InnoDB,
PARTITION p124 VALUES LESS THAN (1540591200) ENGINE = InnoDB,
PARTITION p125 VALUES LESS THAN (1541199600) ENGINE = InnoDB,
PARTITION p126 VALUES LESS THAN (1541804400) ENGINE = InnoDB,
PARTITION p127 VALUES LESS THAN (1542409200) ENGINE = InnoDB,
PARTITION p128 VALUES LESS THAN (1543014000) ENGINE = InnoDB,
PARTITION p129 VALUES LESS THAN (1543618800) ENGINE = InnoDB,
PARTITION p130 VALUES LESS THAN (1544223600) ENGINE = InnoDB,
PARTITION p131 VALUES LESS THAN (1544828400) ENGINE = InnoDB,
PARTITION p132 VALUES LESS THAN (1545433200) ENGINE = InnoDB,
PARTITION p133 VALUES LESS THAN (1546038000) ENGINE = InnoDB,
PARTITION p134 VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
RAM available and usage
total used free shared buffers cached
Mem: 74508 74130 378 0 131 7272
-/+ buffers/cache: 66726 7782
Swap: 49151 3601 45550
cnf:
tmp-table-size and max-heap-table-size = 32M
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-flush-log-at-trx-commit = 1
innodb-buffer-pool-size = 60G
Error :
same as first post