MySQL Forums
Forum List  »  InnoDB

Re: mysql got signal 6 and restarted twice in last 2 days
Posted by: Vaibhav Upadhyay
Date: February 26, 2017 07:19AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.