| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> Lrd_Matrx: if your database is of sufficient size. yes.
<1> yes, memory is very good for databases
<0> it depends on how big your db is.
<0> but generally, more memory is better.
<2> i also have a 4G memory 2x CPU server wich can be used
<0> once your entire db is already cached in memory it no longer will have a big impact though.
<1> like a couple stupid cross joins could easily fill a gig or 2 on big tables
<3> Just pick the best server you have available ;)
<1> yeah really.. "will this beautiful women make me happier?"
<0> and run it on a reasonable platform. ie, not Windows.
<2> it will be running on linux
<0> running mysql on windows is like taking a ferrari into a lake.
<0> well
<0> maybe a really deep mud puddle :)
<4> so mike, who's responsible for teh new style of the docs?
<1> ah yes i saw that.. not sure if it's annoying or not
<2> i do belive that the biggest db is about 1 gig with about 2g in total
<1> probly stefan or?
<2> not that big
<1> he's the documentation lead
<3> That would be Stefan, yes.
<3> The change I am waiting for is when clicking on a version number of the breadcrumb changes to the same page of the new version.
<3> We have had a request in for that for a while.
<4> that'd be nice
<4> and seemingly not terribly difficult
<1> not sure i understand
<1> i just want quicker access to changelog diffs and when functions were introduced
<1> i.e i want an interface for changelog where i can provide 2 version numbers, and it gives me the changelog
<5> I want a working search
<1> ah yes, that too ;)
<3> gleam_: The difficulty is that the implementation belongs to the web team.
<4> gotcha
<4> that explains that
<4> mcdonald's asian chicken salad
<1> hm i could use some more food.. or sleep
<5> yuk
<1> crappy 3d course at uni kept me awake til 4am last nite >;/
<1> http://www.gabejackson.com/cg/close.jpg
<1> :D
<1> will still have to give the roach bones and textures.. zzz
<1> waste of time
<4> wtf two ads in a single block for the mcdonalds asian chicken salad
<4> lord
<6> Hey. I'm reading for my exam here. And I've been bothering myself with the question of why I should use sub-queries at all, except from making the queries look better.
<6> Is that the only purpose?
<0> sub queries are nice.
<0> they save time
<6> Yea
<6> They look neat
<6> Save time in run-time or in writing?
<0> ii dunno
<0> if you havea need to use them
<0> then use them
<6> Do you have any examples where I have to use them? I can't come up with any :(
<0> select custname, (select count(orders) from OrderHeader where OrderHeader.CustNumber = Customer.CustNumber) as ordercount from Customers;
<4> eh you can do that with a join
<0> ok
<0> select custname, (select OrderDate from OrderHeader where OrderHeader.CustNumber = Customer.CustNumber order by OrderDate limit 1) as FirstOrderDate from Customers;;
<4> granbar, consider the problem of getting the id number of the most recent order for each customer
<6> Yes
<4> hwo would you do it without a subquery or a temp table?
<6> I tried doing that with subqueries, but it gave me an error...:
<0> what version of mysql?
<0> mysql 4+ supports sub querries
<0> previous ones do not.
<4> 4.1+
<4> not 4.0
<0> other than that it should work.
<6> insert into customer ( custid, name ) values ( ( SELECT MAX(custid) FROM customer ) + 1, "John Doe" )
<0> was it introduced at 4.1?
<6> )
<4> yes, 4.1
<4> well taht's just foolish
<4> why wouldn't you just use an auto_increment column?
<0> granbar: uhm. yah what gleam_ said
<7> lol
<0> granbar: also, i think if you did max(custid) + 1 it'd work
<4> http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
<4> there's an example of where subqueries are useful
<6> okay...
<6> Well thanks :)
<6> The exam's in 8 and a half hours. :)
<0> what course are you taking?
<6> Databases 1
<6> Despite the MS politics in my school they chose to use MySQL in that course :)
<8> does anyone know a good graphic design tool for mysql (mysql-workbench doesn't work for me) ?
<0> Flynth: mysql-query-admin is ok.
<0> Flynth: personally, i find all the gui tools just getin the way.
<0> they are handy to have when you are just learning though.
<0> Flynth: a very common and powerful tool is phpmyadmin
<9> what part of the documentation is relevant to copy a database schema from one server to another?
<0> dibblego: just the schema?
<9> the schema/data
<0> dibblego: dunno about documentation, but mysqldump does the job.
<8> I'm actually looking for sometching to design a database with
<9> ok I'll look it up thanks
<0> dibblego: mysqldump --help should have all the info you need.
<9> ok ta
<8> i feel ok with doing queries by hand
<8> I just need sometching to visualise the database as a whole, with relations between tables etc
<0> hrm
<0> i've always started small and grew as i needed.
<0> keeping a consistent naming scheme seemed to be the most important factor (any time i strayed from that lead me to headaches)
<9> mysqldump outputs the database, how does one get it back in? Do you just use 'source' for that?
<8> I'm generally ok with console and hand coding stuff, but things like database design are a lot less time consuming with a right gui
<0> dibblego: i usually use mysql -D newdbname < output.sql
<9> ah right thanks
<0> add -u and -p as needed!
<10> Hi, is it possible to use two mysql server using the same database? (is it dangerous, stupid?)
<0> Guillaumito: same?
<0> you can set up a cluster
<0> or a master and uhm. i forget the term for the non master.
<10> slave :)
<0> but two have two mysql instances running and accessing the same physical file is a very bad idea.
<10> the problem with cluster is that data has to be on memory
<0> and i don't think it'll even allow you.
<0> not sure what you mean by data has to be on memory
<10> yeah, I think it's a bad idea too, now I need to convince someone who wants to do it
<0> why do they want to do it?
<0> what do they expect to gain?
<11> Guillaumito you do a distributed database
<11> !tell Guillaumito about distributed database
<12> But I don't know a thing about that.
<11> bah
<10> :D
<0> !tell guillaumito gg:mysql distributed database
<12> Could you be a little more clear?
<13> ugh, Why does everyone tell me not to use PEAR?
<10> SimAtWork, about the in-memory database, that's what I've read here: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-overview.html
<1> jbrimble if here's a cl*** you can use, use it.
<0> because they don't like it?
<1> but jbrimble the PEAR packages... i dunno, they don't seem to serious to me.
<13> I'd just like to know why people dislike it
<1> and i don't know how well they are maintained
<13> ah, i see
<1> and most of the time, the cl***es are so trivial i just write them myself
<14> hi
<13> It's probably unnecessary unless you're planning to change your Database over, right?
<1> well, when do you really need an agnostic db layer?
<1> i find it quite overrated.
<15> when clients use some leet db
<15> :)~
<1> there are reasons why there are multiple RDBMSs, and i chose one because it does best what i want.. so making an agnostic database layer would just remove all the nice functionatliy of a specific RDBMS
<14> I am running into this error: "ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'" is there any possibity to rewrite my query to work around this?
<1> for instance mysql's query cache...
<13> That's true, Jax
<13> what version are you running, cato?
<14> 4.1
<13> i thought 4.1 supported LIMIT, but i am probably wrong
<14> 4.1.11-Debian_4sarge3-log
Return to
#mysql
or
Go to some related
logs:
#lgp
ubuntu unresponsive console
#awk
#gentoo
php setDBConnParms
mysqldump: Got error: 1017: Can't find file: '
n17ikh
python detect whitespace
mysql_config.exe
Gensnack
|
|
