IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[01:40]<sajjqdq>thats for the last 6 hours
[01:40]<dxdffdnz>Well I don't think they could each be running 10 transactions at once. Hmm. Therion any experience with this scenario?
[01:42]<sajjqdq>8Number of rows inserted 2888360, updated 2736302, deleted 238000, read 632568329
[01:42]<sajjqdq>96.09 inserts/s, 107.44 updates/s, 294.11 deletes/s, 40138.97 reads/s
[01:42]<sajjqdq>the slave
[01:42]<buzyrg>hey is there a mysql function to limit repeats of a returned value...say X, Y, Z are stored 10 times each in a db, but I only want to display them once each, how would I do that?
[01:42]<dxdffdnz>Which one is having the problem?
[01:43]<dxdffdnz>Burian: You could GROUP BY the column.
[01:43]<sajjqdq>both are giving that table is full error
[01:43]<dxdffdnz>Hmm, same statements cause the error on each?
[01:43]<sajjqdq>yeah since it replicates over
[01:44]<dxdffdnz>Ok, so not Statement A causeing the problem on the master but statement D on the slave.
[01:45]<buzyrg>mhillyer: Thanks that did the trick
[01:45]<dxdffdnz>argh, the wife calls and the inlaws are coming for dinner. scooby2 I'm sorry but I have to leave you to the mercy of others.
[01:46]<zzaxyvysv>is it the main tablespace because of "Note: InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there."
[01:46]<sajjqdq>archivist: now thats an idea
[01:48]<sajjqdq>i bet thats it
[01:48]<sajjqdq>default is ibdata1:10M:autoextend:max:128M
[01:48]<sajjqdq>so maybe that is hitting the max at 128M
[01:48]<zzaxyvysv>found that snippet here http://dev.mysql.com/doc/refman/4.1/en/multiple-tablespaces.html
[01:49]<sajjqdq>you are the bomb
[01:50]<snzvjooo>CREATE TABLE '05122006183520' ( 'IMGNAME' TEXT NOT NULL , 'DATE' TEXT NOT NULL , 'ID' INT NOT NULL AUTO_INCREMENT PRIMARY KEY); | keeps failing with a syntax error... But I don't see it.
[01:50]<sajjqdq>now how big do i need to make it i wonder
[01:50]<eyzau>Servo888: wrong quotes... use `
[01:51]<eyzau>i would avoid a tablename like that though
[01:51]<snzvjooo>zircu, curious, why?/
[01:51]<sajjqdq>archivist: how do I go about making that bigger?:) If it contains data already I cant exactly just wack it and stop/start with it set to 2gb.
[01:52]<snzvjooo>zircu, yah that worked, ` isntead of '. hehe I didn't even notice that =\
[01:52]<eyzau>Servo888: what does that number mean? is it an archive date or something?
[01:52]<snzvjooo>zircu, yes it's based on date.
[01:52]<zzaxyvysv>dunno the old 128m is just a limit so anew limit should be ok
[01:52]<eyzau>Servo888: the name isn't very obvious on what it is for
[01:53]<snzvjooo>zircu, Month, Day, Year, Hours, Min, Second.
[01:53]<sajjqdq>archivist: ahh ok
[01:53]<zzaxyvysv>methink (never tried it)
[01:57]<fzfjdnz>is it a bad idea to put whole files in a database?
[01:57]<fzfjdnz>tens of thousands of them?
[01:58]<eyzau>palomer: generally, yeah it is a bad idea
[01:59]<fzfjdnz>what if all the files are less than 10k?
[01:59]<zzaxyvysv>what sort of files
[01:59]<eyzau>what are the files used for?
[01:59]<ygvysj>Is there a good reason to do so? Is it searchable content?
[01:59]<fzfjdnz>well, the users are going to search for the files
[02:00]<fzfjdnz>and then I'm going to display the results
[02:00]<ygvysj>by name or contents?
[02:00]<fzfjdnz>then he's going to download the files
[02:00]<fzfjdnz>by name
[02:00]<fzfjdnz>(and information in other tables)
[02:00]<ygvysj>Sounds like there isn't a real compeling reason to put the files up in the db then
[02:00]<fzfjdnz>the contents are inconsequential
[02:00]<fzfjdnz>makes my life easier
[02:00]<zzaxyvysv>nah
[02:01]<eyzau>i would suggest putting the path to the file relative to where the files are stored on the filesystem in that case
[02:01]<fzfjdnz>I would simply plop the database anywhere and all the client application has to do is request a member of a row
[02:02]<fzfjdnz>instead of writing another application where the server is
[02:02]<zzaxyvysv>just a url no need for another application
[02:03]<fzfjdnz>but I don't want the files to be publicly available
[02:05]<fyvxnud>if you have some plan to distribute this beast with files already in it, putting them inside the DB may be a decent idea
[02:06]<fyvxnud>but that would be an uncommon scenario, and it might even be worth setting it up in some other way since storing such stuff in the DB is commonly considered to be a pretty bad idea
[02:07]<fzfjdnz>hrmph
[02:23]<slwnw>hi. how do you concatenate 2 strings with mysql?
[02:23]<slwnw>|| doesn't seem to work...
[02:23]<zzaxyvysv>concat('dfg','string')
[02:23]<slwnw>okay. thanks!
[02:23]<zzaxyvysv>!man string functions
[02:23]<sql>(String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
[02:24]<txgzyjg>mhillyer: Sorry, not paying attention to freenode, real busy
[02:32]<fsdyvx>sphex: there is an sql mode you can set to get || as concat .. i tihnk its called PIPES_AS_CONCAT
[02:38]<slwnw>lsmith: ah ok. Gonna take a look at it. thanks.
[02:38]<fsdyvx>have fun .. lalaland is calling me in ..
[02:38]<pzvzyac_>YEAH, JUST TAKE A LOOK AT IT.
[02:38]<pzvzyac_>HAVE FUN BUDDY.
[02:38]<pzvzyac_>HAVE A GOOD ONE.
[02:39]<pzvzyac_>HEY SPHEX, I THINK YOUR MOM'S CALLING YOU.
[02:39]<pzvzyac_>BETTER GET ON THAT.
[02:40]<drrvx_frrr>wtf?
[02:41]<pzvzyac_>Yeah, really.
[02:41]<pzvzyac_>Who the hell was that?
[02:41]<pzvzyac_>Death_Fag, do you have any idea?
[02:42]<pzvzyac_>Yeah, ladies can't resist my charm.
[02:42]<pzvzyac_>What can I say?
[02:43]<pzvzyac_>I've got a sword handle for you.
[02:43]<drrvx_frrr>Charm shmarm. Your head would look good on my trophy wall. The rest of your body shall feed the dogs tonight.
[02:43]<pzvzyac_>Take a gander, will you?
[02:43]<pzvzyac_>Uh, okay, weirdo.
[02:44]<pzvzyac_>Does anyone in here have a Mac?
[02:44]<pzvzyac_>Besides psycho girl.
[02:44]<sajjqdq>gah mysql hates me
[02:45]<pzvzyac_>Tell me about it.
[02:45]<sajjqdq>Incorrect information in file: blah.frm
[02:45]<sajjqdq>all i did was stop and restart
[02:45]<pzvzyac_>I have a car, scooby.
[02:45]<eyzau>incorrect information?
[02:46]<pzvzyac_>Yup, a car.
[02:47]<pzvzyac_>Hey zircu, do you like doritos?
[02:48]<eyzau>i would answer but i think you'll just end up answering for me
[02:48]<pzvzyac_>Dude, no way.
[02:48]<pzvzyac_>That's a serious question.
[02:49]<pzvzyac_>Uh, do you like Bay City Rollers?
[02:49]<pzvzyac_>I can't keep up with the room's speed; let me get my binoculars.

Back to #mysql
Or go to some related logs:
#gentoo
#ubuntu
#netbsd
#gentoo
#gentoo