mysql - Even the most simple query takes half a second on to any table -


I created an Inodb table with the ID and name columns and started this query

  Insert test (name) values ​​('test');  

takes .5 seconds

Even

  select ID from selection range 1  

or

  select1  

takes 5 seconds or so

about any suggestion In which I can improve it speed will be useful. I think that these questions should not be taken for .05 seconds or more. The server did not get help from restarting and testing / repair / analysis.

Is there anything like checking base query time? Which means that a query can run fast? I wonder if the server is slowing down, the weight average does not say that it comes in use.

I am using mysql query browser to check these statuses.

How far is the distance from the server (network-wise)? If "select 1" is taking 0.5 seconds, then your round trip database server is about 0.5 s.


Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -