#mysql - Wed 21 Feb 2007 between 00:01 and 17:09

NY Lost Funds



threnodytkup: something like user_table(uid, name) and story_table(sid, uid, sname). Both the user_table uid and story_table sid should be something like INT UNSIGNED AUTO_INCREMENT.
tkup: something like user_table(uid, name) and story_table(sid, uid, sname). Both the user_table uid and story_table sid should be something like INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
tkup: the story_table uid should be the user_table uid of the respective author.
brutuzhi... what happens if the slave suddenly slows down.. would it hamper the performance of the master?
preddera replication slave? no it shouldnt. It might be behind in its data but that's about it
burtonatoris there a way to SLEEP in MySQL? I need to debug something.......
arjenAUburtonator: there's a sleep function
burtonatorarjenAU: its in mysql 5 or something right?
I can use GET_LOCK()
everything I always need is in the next version :-P
brutuz!Tropix John Michael Montgomery - Be My Baby Tonight.mp3
ooppss.. sorry about that..
arjenAUburtonator: I think. no don't use get_lock. ugh
burtonator: so you're not on 5? that's not good
hydrocodoneI'm helping someone with a very large database, roughly 6,000 tables... anyway, a lot of entries suddenly have weird characters such as "" and such... how would these ASCII chars make it into the databases and is there a simple fix, or time to lock the DB and grep and replace?
I guess what I'm asking is, what would be the best way to go through this database, roughly 2.1GB large and... remove these special characters that somehow ended up in it?
tkupthrenody, thanks for the reply. just so I get the terminology right, the story_table uid is the FK, which links it to the user_table uid. the linking being the fact that story_table's uid=user_table's uid. does it sound right?
ricknickhi
how can i create a subset of a database
Ysmael_Vasquez_bAnyone here has a toshiba laptop?
Is it okay to take the battery out with just the ac plugged in>
?
fraggelnthats normaly okay
i do that on my hp :)
setuidserotonin|work, What was it?
serotonin|work, And are you doing bulk inserts now?
serotonin|workno, i decided to try to figure out why it was super-slow first
before i recode a bunch of stuff
so what i did was 'show full processlist;' a bunch of times
setuidAnd?
serotonin|workthe address table and miscfield table were showing up all the time
so i decided to put an index back on them
seekwilllol
setuidheh
serotonin|workon the zip field in the address table and the misfield in its table
coz it was selecting all the time
10 fold increase in speed instantly
:D
setuidYes, indices can help
serotonin|workI wont be forgetting this lesson

Page: 2 9 16 23 30 37 44 51 

IrcArchive

NY Lost Funds