| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> so, as said, i would vote for stored procedures
<1> k
<0> doing as much as you can using the db...
<2> yup
<1> what are your reasons for that view though; i'm curious
<3> :X
<1> i mean i have my own reasons but i'm curious why others do that
<0> hrm...
<0> i think we're really getting off-topic...
<1> not really
<0> as said, we con discuss this either in a query or in another channel...
<0> mkay...
<0> so, php _was_ basically a very fast webserver language...
<0> that's php 3
<4> well imho one of the main reasons for SP's is that in the past vendors were pushing separate clusters of database nodes
<4> with middlware running on another cluster
<0> but the newer the php the more it's getting overfeatured...
<4> giving the fact that most people install mysql on the same server as their middleware
<4> network overhead becomes less of an issue
<4> which reduces the appeal for SPs
<4> and like the yahoo example illustrates php is plenty fast
<4> especially if you use the optional goto vm
<4> install a bytecode cache etc
<0> ehm, yahoo compensates very much using good hardware..
<4> they are using cheap server clusters
<4> they do have a slightly tweaked php version
<4> mainly to get around some of the issues with freebsd
<0> hrm...
<4> google, amazon etc
<4> all top notch web companies use cheap server clusters
<0> i don't know if they use threaded mpm, but with prefork it'll consume too much mem...
<0> yeah, _clusters_
<0> that's the point...
<4> depends
<4> you just have to make sure that your requests are handled quickly
<0> but if you start a little project in php, which grows very fast, you'll get into serious trouble
<4> remember that application servers eat up a ton of memory from the get go
<5> hi - how can i select a value which is between a range of int values?
<0> yeah, with caching...
<0> and other methods, like improving the code itself ;-)
<6> phatbyte: WHERE col BETWEEN 1 and 5?
<5> will - this only selects the values between 1 and 5 if it is sorted on it - right?
<0> the point is that it would be much faster if the implemention would be better...
<6> phatbyte: Sorted?
<3> Anyone here can help? I set the root p***word in PHPMyAdmin and now I can't access the DB, I redid the config with the new p***word but it still doesn't work, is this because I didn't change the p***word for the host_name row as well?
<4> The relationship to political and sociological aspects will not be covered in much detail due to the lack of relevant examples in the RDBMS market.
<4> ups
<4> http://talks.php.net/show/lt2004-lamp
<4> that is what i meant to paste :)
<6> lsmith: Darn. I wanted you to go into more detail...
<5> will hm if i got a table with keys like 10, 8, 5, 0, 2 and i do a between 1 and 3 it should output 2 - right?
<4> will: heh ..
<3> Any help?
<0> lsmith: and now?
<6> phatbyte: Try it.
<4> and now?
<1> lsmith: What bytecode cache would you recommend? Now I'm really offtopic.
<1> lsmith: Are you in ##php?
<4> nope
<5> will - but the between should do this right!?
<4> php4 or php5?
<1> 5
<6> phatbyte: Try it.........
<4> are you using the new object model .. or just php4 style code on php5?
<1> lsmith: I tried apc but it gives fatal errors with php5.
<1> lsmith: object model
<0> hrm, i won't say anything more about that...
<4> APC is getting better ..
<4> yahoo is investing heavily into apc as they are preparing the jump to php5
<1> In the time being I need something else. Atm I'm not happy with apc.
<1> turck-mmcache seems nice
<4> eaccellerator is taking a more conservative approach, but afaik they have issues with the new object model
<0> hrm, we're running eaccelerator
<1> lsmith: you should join ##php :)
<4> eaccelerator superseeds turck-mmcache
<4> zend hired the main turck-mmcache developer :)
<1> lsmith: oh; cool
<4> Narada: i am in enough php channels ..
<0> Narada: which derivate/distribution do you use?
<1> aszlig: gentoo,freebsd,rhel,centos,debian
<6> Is rhel free?
<1> no
<6> Darn
<0> Alystair: <aol>me too</aol>
<1> but centos is rhl made free
<1> apparently
<3> aszlig, since when does AOL come into question here?
<0> *gg* that's just an old usenet joke, where mostly aol-users replied with messages which only consists of "me too"
<0> hmm.... i use the 5.0.19, but in the source it prints:
<0> #define API_TOKEN_PRINT "mysqld(API)"
<0> but the documentation tells that this is obsolete O_o
<0> and it's the documentation in the _same_ source...
<0> Docs/mysql.info: [mysqld(SQL)] 1 node(s)
<0> but i don't think that this is the couse of that problem...
<7> Hi! Can I give the current time as a default value to a datetime field?
<8> i have installed mysql server from rpm but could not find my.cnf any where on box. do i need to create this manually ?
<8> can any one help?
<0> ronn: find /etc -name "my.cnf"
<0> golya: NOW()
<8> aszlig: i have looked every where .. i doesn't exist
<0> use this function as default value, and it snhould work
<0> ronn: mkay, then you have to create it manually
<7> I get this: ERROR 1067 (42000): Invalid default value for 'date'
<7> The relevant field:
<6> Look at the TIMESTAMP column type.
<9> ronn: check /usr/share/doc/mysql.../examples
<7> `date` DATETIME DEFAULT now() not null,
<8> aszlig: by default mysql does not need my.cnf ?
<6> There are some stipulations with it though
<7> hmm, with timestamp it works...
<0> yeah, because now() returns a timestamp
<6> It's a column type
<0> ronn: usually it doesn't need it, but it depends on how mysql is compiled...
<7> and what's the diff between timestamp and datetime? I guess timestamp is stored as a unix timestamp?
<0> golya: right, datetime is more "human readable"
<7> Guess I can convert them...
<6> Look at the column type page in the manual.
<6> Seriously, read about the TIMESTAMP column.
<6> Column type.
<7> thx, looking at http://dev.mysql.com/doc/refman/5.1/en/datetime.html now
<6> Are you using 5.1?
<0> hrm, anyone has a mysql cluster running?
<0> with version 5.0.19?
<6> I have to wake up in 3 hours to get ready for work. Should I even bother sleeping?
<0> sleeping? what's that?
<6> Closing your eyes and dreaming about pretty girls.
<0> hm, i prefer mr.brown ;-)
<6> Who?
<0> that's a coffee drink
<6> heh. Coffee doesn't do anything for me. Except make me want to pee.
<0> yeah, i'm immune to some level, too
<0> but after 30 tins, i'm really wide awake ;-)
<6> 30 tins?
<0> yeah
<6> I think I'm getting light headed now...
<6> What is "30 tins"?
<0> oh...
<0> "tin" is british english...
<0> "cans" i mean ;-)
<6> 30 cans of coffee?
<0> yeh
<6> druggie
<0> s/h/a&/
<0> uhm, no *gg*
<0> or yes?
<0> ;-)
<0> i'm awake since monday
<6> s2bu
<6> I'm going to sleep after I make this import script... haha
Return to
#mysql
or
Go to some related
logs:
#css
debian ps_files_cleanup_dir
#physics
#bash
#php
php: error while loading shared libraries
#perl
megahal brain size
amavis-new etch
interrupt handling perl ctrl-z
|
|