mutlithreaded client slow mysql queries
My problem: i wrote a multithreaded app (C++) which uses mysql database (Server version : 4.1.13-standard-log, linux RedHat 8 2.4.29 #1 SMP Thu Mar 10 03:05:14 EET 2005 i686 i686 i386 GNU/Linux). Most of the treads are staying for extended amounts of time in rt_sig state. After processing several hundreds of records, queries are becoming exteremely slow. Any help, suggestion is welcome !