# Node-red-node-mysql: mysql query blocks node-red

**URL:** <https://discourse.nodered.org/t/node-red-node-mysql-mysql-query-blocks-node-red/40688>\
**Category:** General\
**Created:** [9 February 2021 16:35 UTC](https://discourse.nodered.org/t/node-red-node-mysql-mysql-query-blocks-node-red/40688 "2021-02-09T16:35:38Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![GPG](https://avatars.discourse-cdn.com/v4/letter/g/f19dbf/32.png) [@GPG](https://discourse.nodered.org/u/GPG)\
**Post date:** [9 February 2021 16:35 UTC](https://discourse.nodered.org/t/node-red-node-mysql-mysql-query-blocks-node-red/40688/1 "2021-02-09T16:35:39Z")

</div>

Dears all,  
unfortunately I had this problem using mysql node.

I'm using node-red-node-mysql version 0.1.1  
Please refer to previous information and tests in this topic:

> [@Uibuilder ping timeout - possibly related to mySQL taking over 1 minute to get large data](https://discourse.nodered.org/t/uibuilder-ping-timeout-possibly-related-to-mysql-taking-over-1-minute-to-get-large-data/40445):
>
> Hi all, I have some problem with browser connection to uibuilder web page when I have to do some "very long and heavy" work on server-side (node-red). For example: start with a client request on uibuilder web page (i.e. button) this request produce a message to node-red to retrieve a lot of data with mysql node finally, after 1 min or more (it depends), retrieved data come back to uibuilder node with anoter message During this long wait, browser disconnect socket (ping timeout), so I'm not …

After different test, it seems that mysql node use all node-red resources to execute my query, so other nodes (i.e. uibuilder) goes in starvation (and all web connection are closed by client).

Normally mysql node work without problem, but in this case I need to retrieve 2 tables with 40k rows each one in a unique query.  
My query is very simple "SELECT \* FROM table1; SELECT \* FROM table2;".

This query took about 2 seconds using mysql query (mysql CLI) or DBeaver, but mysql node block resources for more than 40 seconds (node-red is 100% of CPU).

I added also some extra-info than msg.topic (i.e. msg.selection) used in next nodes (to by-pass mysql node) , but unfortunately I have the same problem also removing them.

Please, could you help me?

Thanks in advance

---

_[View the full topic](https://discourse.nodered.org/t/node-red-node-mysql-mysql-query-blocks-node-red/40688)._