Sunday, December 20, 2015

Solutions of Async MySQL


Solutions of Async MySQL 

1. create a thread
  a. thread synchronization
  b. request queue
  b. complet queue
  
2. create a thread pool
a. thread pool manager
b. working thread
c. request queue
d. complet queue

3. get MySQL's socket for async io
 MYSQL *= mysql_init(NULL);  
 ...
 mysql_send_query(m, q, strlen(q));
 //m->net.fd; this is the mysql's socket;
http://jan.kneschke.de/projects/mysql/async-mysql-queries-with-c-api/