From: Roberto Spadim [mailto:roberto@spadim.com.br] Sent: Sonntag, 22. September 2013 07:46 To: Vladislav Vaintroub Cc: maria-developers@lists.launchpad.net Subject: Re: [Maria-developers] MDEV-5019 - THREADPOOL - Create Information Schema Table for Threadpool Hi guys! new doubts... 1) threadpool.h don't have information about threadpool_unix.cc structures/interactors Why should it? The structs were only used in threadpool_unix.cc itself. maybe we should rewrite the threadpool_unix.cc to a .cc file and a .h header file? You can if you wish, but I see no need. If you plan to write I_S plugin that works only with unix threadpool, you can define it in the same file threadpool_unix.cc , right? samething to windows threadpool As already discussed, MariaDB on Windows relies on OS to manage threadpool, and there is no simple way to get threadpool diagnostics ( apart from learning kernel debugging , and equipping yourself with "Windows Internals" book that describes the structures). There are no interesting structures either, the pool is represented by opaque PTP_POOL 2) other doubt... how i know what threadpoll it's being used? windows/unix? there's a #define that i could use with #ifdef XXX #else #endif ? On Windows, Windows threadpool is used. Otherwise, Unix threadpool is used . CMake will conditionally compile either threadpool_win.cc or threadpool_unix.cc, dependent on OS. See sql/CMakeLists.txt thanks! 2013/9/21 Roberto Spadim <roberto@spadim.com.br> Hi Vladislav! i did some initial work, check if i'm going to the right direction: https://mariadb.atlassian.net/browse/MDEV-5019 something todo... ENUM('Y','N'), i never used... i will try some search at sql_show.cc to get this information thd->thread_id, thd->query_id, is listener, is waiting i didn't found information how could i get the thd, or how to know if a thread is the listener, or a thread is waiting i know that i have the all_groups[].listener to get listener, but i don't know how to check for example if a waiting_threads is the listener or not about thread waiting, i didn't understand yet where i could check if it's waiting or not well just first steps, i didn't compiled yet, just write the scratch =) thanks!! -- Roberto Spadim SPAEmpresarial