Home > database >  Select distinct primary key, which leads to the mysql service automatically stop
Select distinct primary key, which leads to the mysql service automatically stop

Time:09-20

Today I installed on another computer, extract is mysql5-7-16 version, but my SQL statements to heavy or uniqueness of the primary key fields to heavy, lead to the mysql service automatically shut down, I in other computer mysql can be above, is also the same version, I reinstall the also not line

CodePudding user response:

The size of the memory, in the configuration on how much difference is there?

CodePudding user response:

Distinct to be able to shut down the database, too long to see

CodePudding user response:

Saying the primary key can be repeated, also need it to be distinct?

CodePudding user response:

Why distinct primary key, which USES the distinct will not lead to stop the mysql service, tracking log, should be for other reasons,
  • Related