150908 10:39:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150908 10:39:52 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
2015-09-08 10:39:52 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
...
2015-09-08 10:39:52 5875 [Note] Server hostname (bind-address): '*'; port: 3306
2015-09-08 10:39:52 5875 [Note] IPv6 is available.
2015-09-08 10:39:52 5875 [Note] - '::' resolves to '::';
2015-09-08 10:39:52 5875 [Note] Server socket created on IP: '::'.
2015-09-08 10:39:52 5875 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Failed to open table mysql.event
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Error while loading from disk.
2015-09-08 10:39:52 5875 [Note] Event Scheduler: Purging the queue. 0 events
2015-09-08 10:39:52 5875 [ERROR] Aborting
2015-09-08 10:39:52 5875 [Note] Binlog end
2015-09-08 10:39:52 5875 [Note] Shutting down plugin 'auth_pam_compat'
...
2015-09-08 10:39:55 5875 [Note] Shutting down plugin 'binlog'
2015-09-08 10:39:55 5875 [Note] /usr/sbin/mysqld: Shutdown complete
Error in my_thread_global_end(): 1 threads didn't exit
150908 10:40:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
root@desktop:~#
So yes, with enable super_read_only with read_only simultaneously, mysqld getting crashed.
root@desktop:~# cat /etc/mysql/my.cnf | grep read_only
super_read_only=1
read_only=1
root@desktop:~#
root@desktop:~# /etc/init.d/mysql restart
* Stopping MySQL (Percona Server) mysqld [ OK ]
* Starting MySQL (Percona Server) database server mysqld [fail]
root@desktop:~#
root@desktop:~# tail -100 /var/log/ mysql/error. log
...
2015-09-08 10:39:52 1598 [Note] /usr/sbin/mysqld: Shutdown complete
150908 10:39:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql mysqld/ mysqld. pid ended schema' .'events_ waits_history' has the wrong structure
150908 10:39:52 mysqld_safe mysqld from pid file /var/run/
2015-09-08 10:39:52 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
...
2015-09-08 10:39:52 5875 [Note] Server hostname (bind-address): '*'; port: 3306
2015-09-08 10:39:52 5875 [Note] IPv6 is available.
2015-09-08 10:39:52 5875 [Note] - '::' resolves to '::';
2015-09-08 10:39:52 5875 [Note] Server socket created on IP: '::'.
2015-09-08 10:39:52 5875 [ERROR] Native table 'performance_
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Failed to open table mysql.event
2015-09-08 10:39:52 5875 [ERROR] Event Scheduler: Error while loading from disk.
2015-09-08 10:39:52 5875 [Note] Event Scheduler: Purging the queue. 0 events
2015-09-08 10:39:52 5875 [ERROR] Aborting
2015-09-08 10:39:52 5875 [Note] Binlog end
2015-09-08 10:39:52 5875 [Note] Shutting down plugin 'auth_pam_compat'
...
2015-09-08 10:39:55 5875 [Note] Shutting down plugin 'binlog'
2015-09-08 10:39:55 5875 [Note] /usr/sbin/mysqld: Shutdown complete
Error in my_thread_ global_ end(): 1 threads didn't exit mysqld/ mysqld. pid ended
150908 10:40:01 mysqld_safe mysqld from pid file /var/run/
root@desktop:~#