In ali cloud recently purchased a new ecs server 4 nuclear 16 g5m bandwidth, I installed a mysql 5.7 on it, with navicat locally connected, (select * from table) full table to retrieve a 80000 data table, time consuming, 32 s database is not online, no use, I look at the CPU, memory, bandwidth, disk (my data is in to buy a essd disk), utilization rate is very low, if I had the same table guide into my PC with the inside of the virtual machine version mysql5.7, full table search is less than 2 s, can be finished, is there anyone elders as well as I encountered such a problem, now good, really don't understand,

CodePudding user response:

Will come to buy a set, RDS + DMS

CodePudding user response:

reference 1/f, the breeze gently up response:

will come to buy a set, RDS + DMS

Lack of funding, the pain,