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 |