347 reputation
610
bio website
location
age
visits member for 2 years, 10 months
seen Nov 27 '13 at 16:24

Aug
18
accepted Too Many Connections
Aug
17
comment Too Many Connections
Thank you for the helping, I already solved the problem, I added pause(0.1) after each insert. It's slow the insert because in one time I'm inserting 500 rows. And also I'm catching the connection error, if I exceed the 151 threads than I will wait a few seconds, and retrying to connect
Aug
17
asked Too Many Connections
Aug
6
accepted Shift db data to another column
Aug
4
comment Shift db data to another column
the default value is 0.0
Aug
4
accepted MySQL Query Optimization : Bets and Averages
Aug
4
asked Shift db data to another column
Aug
4
accepted Character Set Encoding in a Table
Aug
2
revised MySQL Query Optimization : Bets and Averages
added 22 characters in body
Aug
2
revised MySQL Query Optimization : Bets and Averages
added 352 characters in body
Aug
2
comment MySQL Query Optimization : Bets and Averages
This is good, and faster than mine, I figured out that this query is returning only one value which is bigger than the average, but I want all row where the q1 are greater than the average.
Aug
2
comment MySQL Query Optimization : Bets and Averages
Yes, it worked.
Aug
2
awarded  Commentator
Aug
2
comment MySQL Query Optimization : Bets and Averages
If it's help, this is the database, with data: sharetext.org/AZWV
Aug
2
comment MySQL Query Optimization : Bets and Averages
Still the same, not working.
Aug
2
comment MySQL Query Optimization : Bets and Averages
I'm still getting the same error.
Aug
2
comment MySQL Query Optimization : Bets and Averages
I tried your version, but I'm getting the following error: ERROR 1054 (42S22): Unknown column 'q1' in 'having clause'
Aug
1
accepted Complex mysql selection
Aug
1
asked MySQL Query Optimization : Bets and Averages
Aug
1
revised Character Set Encoding in a Table
added 9 characters in body