The MySQL database version 5.6.24
There is a table four of six fields is int a bit a varchar (1000) [data rarely mostly empty]
There are 24 w data
I use the select x query needs to wait for more than ten seconds time
Please help me with what could be the cause

CodePudding user response:

If you are a remote query, may be the speed

CodePudding user response:

Return to 24 w, more than ten seconds; This is normal; I just use our big table test, the select * from the test limit 240000; In more than 30 seconds,
I look at the next time consuming information, execute, with 50% of the time to send data to use as much as 27% of the time

CodePudding user response:

LAN connection problems should not be remote
Database quickly after the restart, but after two hours or so began to change slowly

CodePudding user response:

How much memory?
Database is not to give you such a play, nothing to check 240000 data?

CodePudding user response:

Look your select statement posted,

CodePudding user response:

The execution plan posted

CodePudding user response:

Yes, should consider whether it is necessary to article 24 w must get the data at once found out,