Skip to main content
Database Administrators

Return to Question

adding mysql tag and edited some words
Source Link
edit approved Dec 18, 2014 at 8:41
Ahmad Abuhasna
edit approved Dec 18, 2014 at 8:41
Ahmad Abuhasna
  • 2.7k
  • 4
  • 24
  • 36

I have faced some problem like sending data state in processlistprocesslist. In my application I used parallel processing which send 50 count at a time, and that will do some mysqlMySQL database operation  (select &and insert), but after few minutes latter there was nothing will happened. Then I see in database with SHOW PROCESSLIST;PROCESSLIST; most of the query is in SENDING DATA state with 1001 threads. my max query size is 1000. I decrease the size 50 to 10 but no luck. Can anyone suggest me how to solve this problem.

I have faced some problem like sending data state in processlist. In my application I used parallel processing which send 50 count at a time and that will do some mysql database operation(select & insert), but after few minutes latter there was nothing will happened. Then I see in database with SHOW PROCESSLIST; most of the query is in SENDING DATA state with 1001 threads. my max query size is 1000. I decrease the size 50 to 10 but no luck. Can anyone suggest me how to solve this problem.

I have faced some problem like sending data state in processlist. In my application I used parallel processing which send 50 count at a time, and that will do some MySQL database operation  (select and insert), but after few minutes nothing happened. Then I see in database with SHOW PROCESSLIST; most of the query is in SENDING DATA state with 1001 threads. my max query size is 1000. I decrease the size 50 to 10 but no luck. Can anyone suggest me how to solve this problem.

Source Link
Chandan Dey
Chandan Dey
  • 41
  • 1
  • 1
  • 2

Processlist show most of the queries are sending data for select query

I have faced some problem like sending data state in processlist. In my application I used parallel processing which send 50 count at a time and that will do some mysql database operation(select & insert), but after few minutes latter there was nothing will happened. Then I see in database with SHOW PROCESSLIST; most of the query is in SENDING DATA state with 1001 threads. my max query size is 1000. I decrease the size 50 to 10 but no luck. Can anyone suggest me how to solve this problem.