All Questions
7 questions
1
vote
0
answers
184
views
Mysql cache is my headache
This is my status of query cache
SHOW STATUS LIKE 'Qcache%';
+-------------------------+------------+
| Variable_name | Value |
+-------------------------+------------+
| ...
- 25
0
votes
2
answers
58
views
Why does ordering rows lessen the row count in an explain?
I have a table with some two or three million rows…
mysql> select count(*) from tbl;
+----------+
| count(*) |
+----------+
| 2615889 |
+----------+
1 row in set (1.23 sec)
mysql> show ...
- 75
0
votes
1
answer
35
views
Too much time on optimal path
Below query has taken just 0.04 second
SELECT A.*
FROM `TABLE1`
JOIN TABLE2 ON ( TABLE1.ID = TABLE2.ID )
WHERE `COL1` ='1'
While next query has taken 4 seconds
SELECT A.* FROM `TABLE1`
JOIN ...
- 1,087
3
votes
2
answers
219
views
Ambiguous column in where clause with qualified identifier
I get the following error:
ERROR 1052 (23000) at line 1: Column 'id' in where clause is ambiguous
Database: MySQL 5.5.30 (with all tables & columns in the schema)
SELECT cam.id, cam.name AS ...
- 4,872
0
votes
1
answer
42
views
Sql Query For my case
I Have table in format mentioned below
USER_ID ORDER
1 0
1 1
1 2
1 3
2 0
2 1
2 3
3 0
3 2
I want to find list of user id whose ordering ...
- 246
3
votes
4
answers
871
views
Handling Deletes/Inserts/Select in a huge table
I have a dating website. In this website I used to send daily 10 photo matches to a user and store them in the structure as
SENDER RECEIVER
11 1
12 1
13 1
14 1
I maintain two ...
- 1,087
0
votes
1
answer
111
views
How to execute select queries, while not locking update queries
I have a table on which i get heavy select queries every few seconds. Due to this, my update queries get locked for a long time. Is there any way by which I can let my select queries execute, while ...
- 395