Want to understand server and storage engine thread management.

MySQL & MariaDB Other MySQL® Questions
1

Hi All,

Thanks for the wonderful articles. I am new to MySql and about to use MySql in my production env.

I like to know how threads are being managed by mysql server.

  • What will happen when a thread fails? (Whether mysql tries to restart it or mysql will be crashed)

  • Necessary threads for mysql to run?

This may be silly questions, but coming from oracle dba background I have so many questions about this.

2

Below are my findings,

I have killed the threads at OS level in windows and noticed that the threads are recreated with different thread_os_id. (tried with sql/main and thread/sql/thread_timer_notifier,thread/innodb/io_write_thread)

But it doesn’t reflect on performance_schema threads table. Confused.