Re: MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE

[Wagner Bianchi]

I've just got a MySQL 5.6.21 box running once again on mysql environment as a slave server, which one I'm using to test a new SSD Storage and this is executing all the transactions reading form the relay logs. At this moment, everything seems to be OK, event executing events having tables with `datetime` columns on old format.

Regarding your question about the mtype, all the `datetime` columns has its MTYPE value as 6. A sample below:

[bianchi@srv105873-br logs]$ mysql -u bianchi -p -e "select mtype from information_schema.innodb_sys_columns where name ='x' limit 10"
Enter password:
+-------+
| mtype |
+-------+
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
+-------+

My slave server is catching up overnight and tomorrow I'll let you know if this stops or it's finely replicating.

Cheers, WB

Wagner Bianchi - [phone]
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr