| Druide_ | hm anyone alive? |
| CapriSkye | yes |
| Druide_ | http://rafb.net/p/acT2bF11.html any idea why modified by is not working? |
| jbalint | what is not working |
| burtonator | ... so I'm trying to migrate a table to INNODB and during import one of the INSERTs is deadlocking ... no disk or CPU is being used....... any ideas? |
| jbalint | show engine innodb status; |
| cliffclof | what's an undefined index warning? dang i thought i got my indexes right? |
| seekwill | Where did you get that error msg? |
| burtonator | hm........ I dont' think this is a deadlock.... the statatement would have been aborted otherwise |
| turbolover | hey guys how many characters long is a string of [255], 256? or when you define a string in mysql is it mroe than that |
| seekwill | huh? 255 usually means, 255. |
| turbolover | ok is there any flag i can set for something so although i allocate a certainlegnth for it, it can accomodate more if need be? |
| seekwill | Use a VARCHAR length VARCHAR(255) will use up number_of_chars+1 No VARCHAR is variable length |
| turbolover | yeah, well what im doing is storing an array of 40 form elements that had been serialized into a string from php so its quite length y |
| seekwill | Sure |
| turbolover | i ran out of space with 255 :P |
| seekwill | Usually it's better to store each form element in a different row Use TEXT then |
| mugger | is there anyway to pull say all the data out of table1, then join it with table 2 on the condition a row in table 2 = 1(a fixed value)? |
| seekwill | How does table1 relate to table2? But yes, you can do: FROM a INNER JOIN b ON a.id = b.id AND b.fixed = 1 (if that's what you mean) |
| cliffclof | Is it practical to have a multiple tables with 100,000 entries |
| seekwill | Yes |
| cliffclof | err does it work okay say I have 3 indexes |
| seekwill | 100k entires is "little" |
| cliffclof | sweet thank you |
| seekwill | Depends on your queries |
| cliffclof | they are calling only groups of 1000 at a time |