|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 9:35 PM
| #1 | ||
 |
How can I kill or interrupt a hung or locked query. My PHP web app freezes up when it does a select on a table that I presume has been locked by another process. It causes phpMyAdmin to freeze up and timeout, too. When I tried to do a SELECT or a DESCRIBE on the table in question from the mysql prompt in UNIX, the query itself just sits there doing nothing. I do not experience the problem when I go against other tables. Thanks for any help. | ||
     |
| Featured Websites | ||||
|
|
| Tags: hung, mysql, queries |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Optimising queries | Alex Buell | Database | 0 | 07-01-2007 9:35 PM |
| 2 Queries in 1 statement? | Good Man | Database | 2 | 07-01-2007 6:58 PM |
| Car stereo queries. | blah | Car audio | 3 | 06-18-2007 11:42 AM |
| Correcting queries | James Walker | Database | 0 | 05-31-2007 8:37 PM |
| Looking for any handy SQL queries | Whatcha | Database | 10 | 07-10-2006 6:59 AM |
| Featured Websites | ||||
|
Hung MySQL queries 
PacMan
Linear Mode
