#mysql
02 January 2008
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Wed Jan 02 00:00:06 2008
00:03 <****> Changing from 32 to 64bit is not a step to take without proper testing, which could be significant
00:10 <****> hello
00:10 <****> how would i write a select that included the row number of each result?
00:11 <****> is there a shorthand to specify the same condition for all fields when doing a select ?
00:12 <****> I've like 30 text fields and I'd like to get all rows that has a given string in one of its fields
00:13 <****> suppaman, you need a fulltext index covering the fields or something like that
00:13 <****> archivist: mm I don't even know what it is
00:13 <****> !man fulltext s
00:13 <****> see http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
00:15 <****> slowernet, depends what you mean by row number see
00:15 <****> ranking
00:15 <****> for some ideas on ranking see http://arjen-lentz.livejournal.com/55083.html
00:16 <****> is it worth it ? I mean I could just generate a condition with 30 'OR'
00:17 <****> depends how often and what speed
00:18 <****> I don't know but I think seldom, maybe a few hundreds queries per day , say 1k to be large
00:18 <****> speed isn't crucial
00:20 <****> but whole table scanning could be a pain, perhaps set up your own specialised index
00:21 <****> @archivist, thanks
00:21 <****> suppaman, rowid,word,field and a possibly a sexy self join
00:23 <****> #5 - Out of memory (Needed 2091656 bytes)
00:23 <****> how can i assign more memory to mysqld?
00:23 <****> archivist: I'm little too noobish for that
00:23 <****> i think im just going to pay someone to fix my databases
00:24 <****> too much shit to read ill never use
00:24 <****> Druid_: your system doesn't have enough ram
00:24 <****> Druid_: how much ram do you have?
00:24 <****> CPU states: 64.7% user, 0.0% nice, 14.5% system, 0.0% interrupt, 20.8% idle
00:24 <****> Mem: 124M Active, 2776M Inact, 220M Wired, 200M Cache, 112M Buf, 568M Free
00:24 <****> Swap: 8192M Total, 48K Used, 8192M Free
00:26 <****> mysql couldn't allocate 2 MB lol
00:28 <****> chadmaynard
00:28 <****> a noob
00:28 <****> yeah
00:29 <****> so what's wrong there?
00:30 <****> mysql couldn't allocate memory
00:30 <****> your settings, see my.cnf and see docs on memory usage
00:30 <****> or fix your query so you dont need as much
00:31 <****> i imagine he didn't have time to run a query
00:31 <****> if you don't need innodb make sure you don't load it. works well on low-memory systems
00:32 <****> myisamchk: warning: Size of indexfile is: 2804980736 Should be: 1024
00:33 <****> evening
00:34 <****> mornin
00:42 <****> ok, bye bye
00:42 <****> Is there a site where I could find some good mysql-sample databases .. all from small simple ones.. and more "advanced" ..? thx
00:43 <****> kall: databases or queries?
00:44 <****> bye
00:44 <****> see ya
00:47 <****> databases
00:47 <****> oh.
00:48 <****> fuck
00:48 <****> i really have some issues
00:51 <****> Good! The first step is to admit it.
00:54 <****> lol
00:54 <****> kall: there is the world database
00:55 <****> and one i think its called sakila, that has actors and stuff (alot more tables than world)
01:01 <****> hmm
01:01 <****> fulltext IS evil
01:31 <****> Hi, is there any way to get a MySQL query to only return one row for each value. For example I have lots of cl_to values that are identical and I'm selecting cl_to from mytable; so i only want one row for each cl_to value to appear - is this possible?
01:35 <****> Hey, i have three tables: recipes, recipes_ingredients, and ingredients. There's a many-many relationship between recipes and ingredients through recipes_ingredients
01:35 <****> Is there a way to get a list of all the ingredients names that refer to a specific recipe?
01:36 <****> i know it involves a join, but I can't figure out how to write the query for it
01:36 <****> MinuteElectron distinct or group by
01:37 <****> jtaby inner join recipe, regicpe_ingredients and ingredients
01:37 <****> this sounds an awful lot like a homework assignment
01:37 <****> ebergen: no, it's for a personal project
01:37 <****> MinuteElectron: SELECT DISTCINCT ..
01:37 <****> thank you
01:37 <****> ebergen: Surely no one would go to the Internet to try to get someone to do a homework assignment for him.
01:37 <****> err. i'm not
01:38 <****> www.codeExtinguisher.com
01:38 <****> clearly not
01:38 <****> ok...
01:38 <****> could someone tell me what my 10 most significant experiences were in 2007?
01:38 <****> weird..but thanks
01:38 <****> threnody well you didn't get laid so we can go ahead and eliminate that from the list
01:39 <****> that may leave consuming some tacos and potentially cashing a paycheck
01:39 <****> crikey, now everyone knows.
01:43 <****> bye
01:43 <****> see ya
01:43 <****> Hello, I've been reading a few articles about blob, some say storing files inside a database is bad, some say it's good. I want to know, what do you think is better? Filesystem storage or MySQL Blob
01:45 <****> deepends
01:46 <****> What do you mean depends?
01:46 <****> Since I'll be creating a pretty big database
01:47 <****> Will the overhead slow down the database? (I currently use 4.1)
01:47 <****> hey, what is most scaleble with inserts/updates memory or innodb?
01:48 <****> bardyr you realize that with memory if mysql stops you lose all your data right?
01:48 <****> yep
01:48 <****> its a tmp table
01:48 <****> Ragon the filesystem will be faster
01:48 <****> bardyr what are you trying to scale for?
01:48 <****> speed, size, both?
01:49 <****> How much faster? Are we talking about nanoseconds or milliseconds?
01:49 <****> ebergen, writes/updates and trying to release some cpu time
01:49 <****> Since I need to conserve iNodes
01:50 <****> conserve inodes? what for?
01:50 <****> Users will be uploading images
01:51 <****> Average image size is 100KB
01:51 <****> ok
01:51 <****> Will the speed difference be noticeable?
Total 23 pages. You are browsing page 1/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last