Not the answer you need?
Register and ask your own question!

Want to understand server and storage engine thread management.

dineshcsdineshcs EntrantInactive User Role Beginner
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.

Comments

  • dineshcsdineshcs Entrant Inactive User Role Beginner
    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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.