14,499 reputation
22254
bio website in.another.dimension
location Athens, Greece
age 46
visits member for 3 years, 2 months
seen 16 mins ago

Interests: math, programming and games, not necessarily in that order.

Not sure if my next web app will make me a millionaire or a billionaire. In the mean time, I'm looking for a new job. Send proposals to my personal email: ypercube@gmail.com


16m
comment Update all columns from another table
DELETE / INSERT may also have unwanted or just different (cascade or triggered) effects than the UPDATE.
11h
revised Nested query efficiency in MySQL
edited body
11h
revised Nested query efficiency in MySQL
added 2 characters in body
11h
comment Nested query efficiency in MySQL
Are you sure the inner query should have SELECT id and not SELECT id2?
11h
answered Nested query efficiency in MySQL
11h
comment CTE statement to delete duplicate rows - what's wrong with this statement?
A comma before the parenthesis would produce this error - but the query shown does not a comma there.
12h
comment Two MySQL Server accessing same database over NFS
Your linked question (and answer) is about 1 server. This question is about 2 servers that share the same data directory. The two do not seem relevant.
19h
comment Two MySQL Server accessing same database over NFS
What is not clear from "Permitting multiple MySQL servers to access a common data directory over NFS is a very bad idea." ?
20h
reviewed No Action Needed How to fix ERROR Postgresql * Removed stale pid file
20h
reviewed Edit suggested edit on cant pass table name as argument in a same procedure
20h
revised cant pass table name as argument in a same procedure
code indenting
20h
reviewed No Action Needed Can creating indexes colide with future database upgrades?
21h
comment I'm trying to run an oracle database in virtual box under oracle linux
Nice, thank you.
22h
reviewed Reviewed I'm trying to run an oracle database in virtual box under oracle linux
22h
comment I'm trying to run an oracle database in virtual box under oracle linux
Not only a link but a youtube video? It would be more helpful if you added the steps you did here, not in a link that may stop working tomorrow.
23h
comment A little clarification on how 'LIMIT' works
Well, the helpful comment was the one a few minutes ago, about several tables having the same behaviour. If all queries behave so slow, this suggests a server issue - as you have found out (just read your answer and the accepted one).
23h
comment A little clarification on how 'LIMIT' works
You still haven't answered the questions: And is that <table> a real, base table or a view? Or some complex derived table? It would be good to also add the output of SHOW CREATE TABLE <table>; in the question.
1d
reviewed No Action Needed Does MySQL guarantee atomic upgrade from read lock to write lock?
1d
reviewed Close Error after SQL Server upgrade
1d
reviewed Close how can insert multipal data from table1 one column data can copy from another table2 from sql server