Why does this MySQL Query hang?

Posted by zzapper on Stack Overflow See other posts from Stack Overflow or by zzapper
Published on 2010-04-07T09:25:36Z Indexed on 2010/04/07 9:33 UTC
Read the original article Hit count: 256

Filed under:

mysql-query

|

hangs

SELECT *
FROM tbl_order_head AS o
INNER JOIN tbl_orders_log AS c
ON o.PAYMENT_TRANSACTION_LOG_ID=c.TRANSACTION_ID
WHERE o.VISUAL_ID = '77783';

tbl_order_head 67,000 (30 fields) records, tbl_orders_log 17000 (5 fields) records. I don't know if it would eventually return as I am running it on a live server and fear overloading.

I am doing similar queries and much more complex queries successfully.

© Stack Overflow or respective owner

Related posts about mysql-query

MySQL query returns different set of results on two identical databases

as seen on Stack Overflow - Search for 'Stack Overflow'
I exported a live MySQL database (running mysql 5.0.45) to a local copy (running mysql 5.1.33) with no errors upon import. There is a view in the database, that when executed locally, returns a different set of data than when executed remotely. It's returning 32 results instead of 63. When I execute… >>> More
What's wrong with my MySql query ?!

as seen on Stack Overflow - Search for 'Stack Overflow'
This is a query I am doing with mysql using PHP This is the query line <?php $query = "SELECT * FROM node WHERE type = 'student_report' AND uid = '{$uid}' LIMIT 1 ORDER BY created DESC"; ?> I get the following error You have an error in your SQL syntax; check the manual that corresponds… >>> More
Optimizing the MySQL Query Cache

as seen on Internet.com - Search for 'Internet.com'
MySQL's query cache is an impressive piece of engineering if sometimes misunderstood. Keeping it optimized and used efficiently can make a big difference in the overall throughput of your application, so it's worth taking a look under the hood, understanding it, and then keeping it tuned optimally. >>> More
index help for a MySQL query using greater-than operator and ORDER BY

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a table with at least a couple million rows and a schema of all integers that looks roughly like this: start stop first_user_id second_user_id The rows get pulled using the following queries: SELECT * FROM tbl_name WHERE stop >= M AND first_user_id=N AND second_user_id=N… >>> More
mysql query using jdbc

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have the following table: Service_ID feedback 31 1 32 1 33 1 1 I have the sample code to find the sum: ResultSet res = st.executeQuery("SELECT Service_ID,SUM(consumer_feedback)… >>> More

Related posts about hangs

VMWare ESXi 4.1- 5.1 installation hang

as seen on Server Fault - Search for 'Server Fault'
I'm well aware that I'm trying to install VMWare ESXi 5.1 on hardware that's not on the HCL. I can't find my motherboard on the ultimatewhitebox site as well. I acknowledge these issues in advance. What I'm trying to find is someway to access the logs during installation or see a console or log file… >>> More
apache2 + mod_fastcgi + suexec + php5.2 = unstable on high load...

as seen on Server Fault - Search for 'Server Fault'
I am hosting several (~30) different sites on one server with apache2+fastcgi+suexec+php5. Sites have different loads and different execution times of their scripts (some of them process request for 5-7 seconds, some <1sek). Sometimes when single site receives very high load (all php instances… >>> More
Windows Storage Server 2008 hangs at logon

as seen on Server Fault - Search for 'Server Fault'
We have a Dell PowerVault NX-3000 server running Windows Server 2008. Every now and then, when I try to login, the server seems to hang at the Welcome screen after I type in the password. However, all other services on the server are running fine - users are able to print off the print server and… >>> More
apache2 + mod_fastcgi + suexec + php5.2 = unstable on high load

as seen on Server Fault - Search for 'Server Fault'
I am hosting several (~30) different sites on one server with apache2+fastcgi+suexec+php5. Sites have different loads and different execution times of their scripts (some of them process request for 5-7 seconds, some <1sek). Sometimes when single site receives very high load (all php instances… >>> More
apache hangs frequently with semop

as seen on Server Fault - Search for 'Server Fault'
My Apache hangs frequently with multiple threads. Each thread get stucked for hours. Backtrace looks like this: (gdb) backtrace #0 0x00002af60c22b2d7 in semop () from /lib64/libc.so.6 #1 0x00002af60bbf612c in ?? () from /usr/lib64/libapr-1.so.0 #2 0x000055555559e614 in ?? () from /usr/sbin/httpd2-prefork #3… >>> More