Topic: CPU Utilitization

[darmasanthi]

Hi,
I have SME 7.3 with all updated installed, and with system Monitor installed
and i has use the MySQL for our Application databases,
When i am trying to make some report, i show the graph of CPU Utilitization at System Monitor with 100% Green Bar (User Bar).
And when i am check at MySQL state i show "Copying to tmp table on disk"
and when some one trying to running the application the database state is "locked".
I'm using "myisam" engine and at client computer using "MySQL ODBC connector"

thank you,
darmasanthi

[cactus]

Hi,
I have SME 7.3 with all updated installed, and with system Monitor installed
and i has use the MySQL for our Application databases,
When i am trying to make some report, i show the graph of CPU Utilitization at System Monitor with 100% Green Bar (User Bar).
And when i am check at MySQL state i show "Copying to tmp table on disk"
and when some one trying to running the application the database state is "locked".
I'm using "myisam" engine and at client computer using "MySQL ODBC connector"

thank you,
darmasanthi

First of all 100% CPU resources on a linux system is not neccesarrily a bad thing. Linux uses what is av available but in comparison to windows it has a far better priority system to organise which task gets the resources when.

Second, OT here but, your application seems to make use of temporary tables this is not a SME Server related issue but most likely due to badly written My SQL queries.

If it is a application you have written yourself and not explicitely permitted to create temporary tables you can check your queries to see if they could be analysed by adding the EXPLAIN keyword in front of your queries. With that informatin you can optimize your queries. More information can be found in the MySQL.

[CharlieBrady]

First of all 100% CPU resources on a linux system is not neccesarrily a bad thing.

100% CPU utilisation usually indicates a programming error.

[cactus]

100% CPU utilisation usually indicates a programming error.

For one single process it does, but I thought OP meant 100% of CPU was used for multiple processes in total, not per process.

[darmasanthi]

Hi,
we only Running the server as File Sharing,
and applying the MySQL for our Internal Application as the databases.
The client is only running the our Internal Application

cause i am a new be for MySQL, is there any solution to resolve the problem

regards,
darmasanthi

[CharlieBrady]

For one single process it does, but I thought OP meant 100% of CPU was used for multiple processes in total, not per process.

Unless you are doing raytracing, weather simulations, etc, etc, then you can expect all processes to be waiting for I/O nearly a lot of the time, so that you have idle CPU, sometimes 99%+ idle. 100% cpu is unusual. Virus scanning can be CPU intensive, as can compression during creation of a backup. OP can use 'top' to identify which process or processes are using CPU.