network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 11 months |
| seen | Jul 16 '12 at 11:16 | |
| stats | profile views | 1 |
|
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? |
