Can long mysql queries to be due to CPU frequency is 400MHz?

Question

On a VPS the CPU frequency of 400MHz. The queries in phpmyadmin for a long time back.

I also noticed that on this VPS slower installed application such as apache.

Answer 1

Than to read tea leaves, you need to take measurements.
4 Useful Commandline Tools to Monitor MySQL Performance...
Tuning Your MySQL Database
MySQLTuner-perl

Answer 2

well, the 400 MHz is very small , so it's not surprising.

Comments

Puma Thailand So slowly that even the "Queries in phpmyadmin for a long time back."?
Navryadli.

---

Novel : how important ? I would say it's not important as you said if the situation is viewed between 1 core and 8 cores, but that core 3200 MHz time 8 times more operations to do, and if we consider not quite micro queries it will be 8 times quick tray.

---

Yes not the fact. Depends on the server load and request rate.

---

Novel Yes, and there, too , all the same queries in phpmyadmin, they are requests and not phpMyAdmin, I've worked on a dual-core processor with a frequency of 800 megahertz, and beheld it slowly.

Answer 3

I have the impression that people cease to understand what the MC and what they do. Cease to understand the relationship between megahertz and speed :(

Default, in your opinion, what is 400 MHz? 400 parrots? 400 million WHAT?

PS Started on 4.7 MHz :)

Answer 4

If You run CPU - you can tell by the top display. If MySQL eats up more than 90% during the query execution (assuming that You have a single core) - just not enough processor performance.
Look, I didn't leave You in a SWAP You may not have sufficient RAM. The command free-m or top

The queries request the strife - if You have a query consists of a join, then there will not save even dozens of cores.
In General, 400MHz for the web server is not enough.

Provide information on server configuration and MySQL configuration, as well as a sample request. MySQL config You default? With the inclusion of caching, the situation may change for the better (provided that there are enough resources for this).

Can turn on log slow queries in mysql config add the lines
log-slow-queries=/var/log/slow_queries.log
long_query_time=3

Answer 5

can