35 reputation
18
bio website
location
age
visits member for 1 year, 6 months
seen Aug 20 at 11:25

I am web developer at numbertank.


Jul
28
comment Mysql replication with c
hello @tero-kilkanen all points you suggested, is checked and ok as per my knowledge. but still I want to replicate my database and store all the data on SLAVE and only 2 months data (some of tables) on MASTER (eg PRODUCTION Database). Is is possible? If yes, How? and another question about real-time or latency. imagine my MASTER server is located in USA and my SLAVE at Singapore, when records get inserted in MASTER, at how many time it will take insert it on SLAVE (forgot about network latency)
Jul
28
awarded  Editor
Jul
28
comment Mysql replication with c
I sorry for typo. It is not billion, it's a million. :) and not just for backup. I want solution for real-time synchronization, so I have another option in case of main server crashed.
Jul
28
revised Mysql replication with c
edited body
Jul
26
asked Mysql replication with c
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