111 reputation
1
bio website
location
age
visits member for 2 years, 2 months
seen Jul 16 '12 at 11:16

Jul
13
comment MySQL table design / architecture, table is too big
the Claims and Description fields can both carry large text chunks (up to 1MB~ per record). the Abstract field can carry about 200kb per record. I thought that the text fields are stored outside the MYD file, but I can't find them. I don't see how we managed to get this big if the text fields located in a different path. as for now I can't alter the table because I don't have enough disk space on my drive (alter creates a tmp copy). I wanted to see how changing the ForeignReferences field from varchar to text would affect the size of the MYD file.
Jul
12
awarded  Student
Jul
12
comment MySQL table design / architecture, table is too big
you're right, but this is hardly 6%-10% of the entire DB. I can't even alter the tables now, mysql copies the MYD file and I don't have enough space for both the tmp and the live data file.
Jul
12
comment MySQL table design / architecture, table is too big
even after creating those tables, it doesn't really changes my question, I can create another table for the information I'm not searching on. So I'll have 2-3 more tables, I still need to deal with my text vs. varchar and the capacity of the DB\HD. I'm using windows. how would NoSQL help me here?
Jul
12
asked MySQL table design / architecture, table is too big
Jun
13
comment which database engine is best for full text search on a 10M rows table?
I don't know what will be sufficient, I can learn any engine needed for the cause, that's why I'm asking here first.
Jun
13
asked which database engine is best for full text search on a 10M rows table?