87 reputation
1411
bio website inoxapps.com
location Delhi
age 26
visits member for 2 years, 5 months
seen Oct 16 at 10:44
Know Everything and your life becomes easier....

Aug
18
awarded  Notable Question
Jul
2
awarded  Notable Question
Jul
2
awarded  Curious
Feb
23
awarded  Popular Question
Apr
4
awarded  Popular Question
Mar
16
awarded  Notable Question
Feb
8
awarded  Famous Question
Dec
2
comment How to use insert delay with the InnoDB engine and use less connection for insert statements?
Server is running apache2, mysql and php, should i go for upgrade memory in this situation or is there any optimal solution except to innodb buffer pool?
Dec
1
comment How to use insert delay with the InnoDB engine and use less connection for insert statements?
my server memory is 2GB, so according to memory i set innodb buffer pool to 500M, and log files 25% to pool, also set log buffer to 64M. But still server is heavy busy. Should i upgrade memory? Also my server is on 32 bit ubuntu, so max i can set memory to 4 GB.
Dec
1
revised How to use insert delay with the InnoDB engine and use less connection for insert statements?
explain problem statement more
Nov
30
revised How to use insert delay with the InnoDB engine and use less connection for insert statements?
revised table structure and problem statement
Nov
29
comment how to retrieve rows of different dates using IN clause
@RolandoMySQLDBA: Hey, this query will take max 156 seconds and min 100 seconds to retrieve past seven consecutive dates data. Presently there is 35k/hr insertions in my database, and these select queries are executed alongside. Should i post another question for explaination?
Nov
28
comment how to retrieve rows of different dates using IN clause
@RolandoMySQLDBA: yes it is, actually i can't edit from the post, so i request for this one.
Nov
28
comment how to retrieve rows of different dates using IN clause
Hey, remove the semicolon at the end of date interval, as it shows an error at run time
Nov
28
comment how to retrieve rows of different dates using IN clause
Hey, i want this query to be run as in real time scenario, like dates have to be dynamic. Should i do for seven days using DATE(track_time) and last one is DATE_SUB(CURDATE, INTERVAL 7 DAY) ?
Nov
28
awarded  Commentator
Nov
28
comment how to retrieve rows of different dates using IN clause
hey, second option working for me, that was an awesome query to help me for retrieving different date ranges data, can you prefer me any tutorial or resources for work on query logics
Nov
28
accepted how to retrieve rows of different dates using IN clause
Nov
28
revised how to retrieve rows of different dates using IN clause
edited title
Nov
28
revised how to retrieve rows of different dates using IN clause
edited count syntax, COUNT(DISTINCT user)