| snoyes | su |
| Noeve | lirakis, full database ? |
| lirakis | Noeve: no.. full table |
| Leithal | !man table is full |
| lirakis | this is the only table in the db |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/full-table.html |
| Leithal | the issue is likely not with file size ... but ... "something else" ;) |
| lirakis | the_wench: ive already read the docs.. and for the correct version of mysql i am running (4.1.2) not 5 |
| Noeve | aoirthoir, do you know what's wrong with the query ? I'm guessing it's the CASE. |
| aoirthoir | Noeve: i am prepping a sample in my mysql db to see if I can run it |
| lirakis | Leithal: yeah ... im just not sure what? i mean.. everything about this system seems to be able to support MUCH larger file sized .. i dont know why its erroring out |
| Noeve | aoirthoir, thanks very much :) |
| Leithal | read the manual page it describes the problem |
| snoyes | lirakis: You've changed the myisam_data_pointer_size? |
| lirakis | snoyes: this is a fresh install of centos 4.4 ive changed nothing |
| haptiK | crap i have two bites of toaste left and ive run out of cheese spread. |
| snoyes | By default, MyISAM allows up to 4GB. Change myisam_data_pointer_size to 5 or 6. |
| Leithal | use peanut butter |
| haptiK | nah taking a bite of toast and licking the plate |
| Leithal | lol |
| snoyes | lirakis: or use alter table and set MAX_ROWS to something bigger |
| haptiK | hehe |
| archivist | eat the plate |
| chadmaynard | haptiK: i wouldn't advie eating cheese. |
| haptiK | i love cheese! class over so soon? |
| Leithal | snoyes: worth noting that just changing myisam_data_pointer_size is not enough for an already created table only takes affect after changing for *new* tables |
| action | archivist is eating cheese slices in croissants |
| archivist | is eating cheese slices in croissants |
| chadmaynard | haptiK: yep. 50 mins. I have another one right now buts its calc3. I don't need to listen to the lecture |
| snoyes | That's a useful point that ought to be mentioned in the manual. |
| haptiK | chadmaynard: you'll be happy to note that ive mastered normalisation |
| Leithal | need to still do the above alter, or null alter table, or optimize, or whatever, after changing it |
| haptiK | i have 4 tables all normalised and i have a huge sql statement to bind them together |
| chadmaynard | haptiK: i haven't :( |
| snoyes | One SQL to bring them all, one SQL to find them... |
| lirakis | snoyes: i will try it... but i have 9,802,070 now.. it seems like an odd number to 'fail' on |