LP #1690723: integer overflow with thread_pool_stall_limit in PS 5.6/5.7

**Reported in Launchpad by Zhengsilong last update 28-12-2017 14:56:37

As compared with percona server 5.6. We found set_timespec_nsec() is different in function:timer_thread(file:sql/threadpool_unix.cc)

set_timespec_nsec(ts, timer->tick_interval*1000000LL); – percona server 5.6
set_timespec_nsec(ts, timer->tick_interval*1000000); – percona server 5.7

In percona server 5.7, the table information_schema.tp_groups has been removed, we can not observe the changes of IO_EVENT_COUNT and QUEUE_EVENT_COUNT by thread_pool_stall_limit. So we port information_schema.tp_groups from percona server 5.6. When set thread_pool_stall_limit = 20000 and do something in normal client, we find the IO_EVENT_COUNT and QUEUE_EVENT_COUNT never changes(At least 20 seconds later, there is still no change)

On the other hand, we modify "set_timespec_nsec(ts, timer->tick_interval*1000000);" in percona server 5.6(just remove "LL"), and compile again. We do the same thing on the above, the IO_EVENT_COUNT and QUEUE_EVENT_COUNT in table information_schema.tp_groups never changes, neither.

All of the above operations are performed under suse11sp2.