30 reputation
17
bio website
location
age
visits member for 1 year, 5 months
seen Jul 19 at 8:13

I am web developer at numbertank.


Jul
19
comment mysql fulltext query is very slow
thanks @dgig, I have changed ft_min_word_length and rebuilt index again. but when I restart mysqld service and then run query first time it is taking to much time (may be worm up time), but still this is taking too much time. do you any guess
Jul
15
asked mysql fulltext query is very slow
Jul
8
awarded  Tumbleweed
Jul
2
awarded  Curious
Jul
1
asked mysql service failed to start when datadir changein ubuntu
Jun
26
awarded  Commentator
Jun
26
comment MySQL Community Edition Capacity
@ypercube, I mean to say capability to handle workload. Currently, some of my queries includes multiple tables getting very slow (this tables are well normalized and properly indexed as per EXPLAIN)
Jun
26
asked MySQL Community Edition Capacity
Mar
12
comment MySQL query with order by decreased performance
@Mihai, there is already one composed index (userid, userstatus, fullname ), but it doesn't used in plan. it is using primary key, may be because I have write <> on that field
Mar
12
comment MySQL query with order by decreased performance
@ypercube, I have just changed it. it is working, but no performance gain
Mar
12
comment MySQL query with order by decreased performance
UNION ALL may result duplicate data, and subquery has already using index
Mar
12
comment MySQL query with order by decreased performance
@ypercube, Order by 1,2 can be removable. I just want to check, and If I remove extra warpping, query takes 2 seconds, means performance is bed. I have explained in detaild
Mar
12
asked MySQL query with order by decreased performance
Mar
1
awarded  Scholar
Mar
1
accepted Performance with IN clause
Feb
27
awarded  Supporter
Feb
27
comment Performance with IN clause
thanks @gbn, But how engine goes to each pointer. means I have doubt, If I have pass values as 4,3,19,25,2 then engine first go to record no 4 then jump reverse on record 3 and then jump over 19 and 25 and again reverse on record no 2? so, I think this is not good.
Feb
27
asked Performance with IN clause
Feb
2
awarded  Notable Question
Sep
2
awarded  Popular Question