MySQL Query big table an error occurred

The following error occurred during the first Test execution: Bigdata There are 1 million data MySQL> Select Count(*) from(Select distinct(ID) fromBigdata) asTotal ; ERROR1317(70100): Query execution was interrupted waited a while and then executed it successfully MySQL>  Select Count(*) from(Select distinct(ID) fromBigdata) asTotal ;+----------+| Count(*)|+----------+|   598898 |+----------+1Rowinch Set(6.60sec) guesses that there may be a system cause, due to insufficient CPU or memory running. 

MySQL Query big table an error occurred