181 reputation
15
bio website cs.uoregon.edu/~gmemon
location
age 33
visits member for 4 years, 4 months
seen Mar 5 at 4:54

Aug
15
awarded  Notable Question
Jun
10
awarded  Popular Question
Aug
18
asked Extensive memtest
Aug
3
accepted ECC vs Non-ECC memory
Aug
3
asked ECC vs Non-ECC memory
Aug
3
comment PCIe x8 NIC in PCIe x16 slot
Thanks for the very detailed answer
Aug
3
awarded  Scholar
Aug
3
awarded  Supporter
Aug
3
accepted PCIe x8 NIC in PCIe x16 slot
Aug
3
asked PCIe x8 NIC in PCIe x16 slot
Dec
6
awarded  Teacher
Dec
6
answered nfsclient on ubuntu server
Dec
6
comment nfsclient on ubuntu server
I am using nfs version 3
Dec
5
asked nfsclient on ubuntu server
Apr
25
comment Linux filesystem suggestion for MySQL with a 100% SELECT workload
Thanks for your reply. The two tables that I am mostly dealing with are 14 GB and 28 GB in size. Each row in both the tables is almost 3 KB. The total physical memory on my server is 16 GB. I have realized that for each table there are 500 groups, and all my queries involve a group by clause, and perform analysis on those. I am thinking that I should create 500 partitions instead, and issue 500 queries on 500 separate connections. I believe This would provide a 500x speedup. What do you think?
Apr
25
comment Linux filesystem suggestion for MySQL with a 100% SELECT workload
Thanks for recommending the blog. I am already reading their book
Apr
24
awarded  Student
Apr
23
asked Linux filesystem suggestion for MySQL with a 100% SELECT workload