Topic: MySQL Locked

[darmasanthi]

Hi All,
I Got another problem after we had updated the SME 7.3,
we check before we updated the SME the MySQL it was on 4.1.20 version and after updated the version become 4.1.22.
And we had this problem:
- we have application using the mysql server on SME, there is no problem before we updated the SME, but we got the mysql server is locked when we trying to query the database for preview and printing process for the application.

what is the problem

regards,
darmasanthi

[Stefano]

darmasanthi:

you have to remember that we are not in front of you, we are far from you.. so you have to give us many details of your issues..

questions:
- is mysql up and running?
- if you digit

Code: [Select]

mysql

in console, what do you get?

ciao
Stefano

[darmasanthi]

Hi Stefano,
yes, the mysql is running good, when we entering the information for filling the form on our application is no problem,
but the problem is coming when we trying to preview or printing the report,
it's mean we have to read many tables on mysql database.
Before we updated the SME we do not have a problem

regards,
darmasanthi

[Stefano]

it doesn't add any usefull info to me..

do you have errors in your log?

how can you think we can help you if all you can say is "it doesn't work"?

Ciao
Stefano

[darmasanthi]

Yes,
we check the status of MySQL server with MySQL Administrator (win 32 App),
on the state status we see the "Copying to local tmp",... and after a few second the status become "locked"...
(it's onlu haven on updated SME with MySQL 4.1.22)

regards,
darmasanthi

[Stefano]

hi

what about checking mysql's logs on SME?

your info are still useless
ciao
Stefano

[cactus]

yes, the mysql is running good, when we entering the information for filling the form on our application is no problem,

we check the status of MySQL server with MySQL Administrator (win 32 App),
on the state status we see the "Copying to local tmp",... and after a few second the status become "locked"...

This is not abnormal behavior, but it might be due to slow/badly written queries. The data can not be presented without making a temporary table, hence copying to tmp and locking the table to copy data, hence the lock.

I suggest you do not temper with MySQL, since you seem to lack a lot of knowledge and suggest gettig up-to-date with MySQL and how it works.

To start on how to analyze your queries I suggest you read this:
http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
http://dev.mysql.com/doc/refman/5.1/en/explain.html

you have to remember that we are not in front of you, we are far from you.. so you have to give us many details of your issues..

it doesn't add any usefull info to me..

do you have errors in your log?

how can you think we can help you if all you can say is "it doesn't work"?

I have to agree with Stefano you should improve your communication in the forums if you like help. Try to answer the questions asked as precise as you can and when asked for data from logfiles, it is not without a reason, so please provide it instead of stating you see all kind of other things with other tools we did not state you to use in diagnosing your problem(s).