151 reputation
128
bio website
location
age
visits member for 2 years, 10 months
seen Jan 27 at 13:24

1d
awarded  Notable Question
Aug
27
awarded  Famous Question
Aug
3
awarded  Self-Learner
Jun
9
awarded  Popular Question
Oct
21
awarded  Promoter
Oct
21
revised MySQL requires FORCE INDEX on huge table and simple SELECTs
added 3044 characters in body
Oct
21
comment MySQL requires FORCE INDEX on huge table and simple SELECTs
Yes, this table has exactly 3 columns. It is meant to contain only the basic metadata, because it was know it will become huge. The IDs in the IN clause are fetched via another query in the client and are different for every user.
Oct
17
comment MySQL requires FORCE INDEX on huge table and simple SELECTs
Yes, because we need microsecond precision here. Insert rate at this table is around 400,000 entries per hour and we need the dates to be as unique as possible.
Oct
17
awarded  Editor
Oct
17
comment MySQL requires FORCE INDEX on huge table and simple SELECTs
Yes, this was a typo, thanks for the correction. I have fixed it. Of course we did ANALYZE, but that didn't help at all. I will try to capture some EXPLAINs later.
Oct
17
revised MySQL requires FORCE INDEX on huge table and simple SELECTs
analyze = EXPLAIN
Oct
17
asked MySQL requires FORCE INDEX on huge table and simple SELECTs
Jun
18
answered How to change “tmpdir” on a running MySQL instance
Jun
18
comment How to change “tmpdir” on a running MySQL instance
It worked by changing the size in /etc/fstab and then issuing mount /var/lib/mysqltmp -o remount
Jun
18
comment How to change “tmpdir” on a running MySQL instance
Any ideas if I can unmount the tmpfs and continue running on disk? Is there a way to force mysql to release the tmpdir (even for a secnond)? The tmpdir seems empty, but cannot be unmounted.
Jun
18
asked How to change “tmpdir” on a running MySQL instance
Feb
7
awarded  Notable Question
Aug
16
awarded  Popular Question
Jan
14
comment Fastest way to check if InnoDB table has changed
Further story development for those who are interested: forum.percona.com/index.php?t=msg&th=2060&goto=7785&;
Jan
6
awarded  Teacher