Is mysql query memory or something? Why query, my CPU, memory all have no action? Exactly calculate the query? Is command in this picture, a table of data is about 30 million, a total of 2 tables, and finally to associate new table after the query, as shown in figure, from 7 am to 12 o 'clock at night, still didn't get the result, also have no error, excuse me, what reason be? How to solve?

CodePudding user response:

Isn't that what you build data import table;
SHOW FULL the PROCESSLIST connection thread to view the background,

CodePudding user response:

Have a look at the log, whether to have access to relevant information,