| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> i dunno if there's cast
<0> !man cast
<1> (CAST()) : http://dev.mysql.com/doc/mysql/en/Charset-CAST.html
<0> shabes, no ?
<0> shabbs, no ?
<2> no, not you
<2> hazard_
<0> oh hazard, ya .. I shake my head too :)
<0> hazard, you need normalization man. Unless you're doing 100 recipies and don't care.. but if it's going to be anything that you may want to sell in the future, make sure you normalize. It's easy as pie, takes maybe 1 hour to get the concept and like 2 hours to learn the joins
<0> shabbs, i'm so close to getting this replication bug.. I hope they send me a check for a days pay lol
<2> anyone that says 'flat files are more convenient than normalized databases' should be shot and dragged through the streets then pelted with empty ink cartridges
<0> empty?
<0> full :)
<2> no sense in wasting good ones
<0> hahaha
<3> hazard: there are some recipe projects - you might want to look at their database development
<0> FIGURED IT OUT.. heh
<0> hot damn, i want a paycheck.
<0> send it.
<4> Is it entirely impossible to use an alias in the WHERE clause? For example: DATE_FORMAT( '%e-%c-%Y', `posted` ) AS postday, WHERE `postday` > DATE_SUB( NOW(), INTERVAL 1 DAY )
<2> UltimateB|: just use the field in the comparison instead of the alias. the alias refers to the formatted-for-output version, which you can't use in the compare properly anyway
<4> shabbs: you mean that for DATE_SUB i always need a full date string?
<4> shabbs: if so i retain my question before that.
<4> Does DATE_SUB( NOW(), INTERVAL 1 DAY ), select today, or the last 24 hours?
<4> :)
<2> it'll get you yesterday's date
<2> since it's date_sub it only returns date iirc
<5> todays date minus 1 day
<6> dude I'm doing m*** moving of nodes in a preorder tree, it takes very long and mysqld uses very high CPU
<4> Ok thanks. So no time will be used in that part then
<2> shouldn't be
<4> thanks again.
<4> :)
<7> good day :)
<8> does mysql < 5 supports SSL connections?
<9> hi there
<7> i was wondering is there anywhere on the net publicly available, a cross reference of syntax vs. mysql [345].x
<7> ?
<10> check google?
<10> it spiders 'publicly available' stuff
<9> does anybody have an idea, why I'm getting *sometimes* "Can't connect to local MySQL server through socket", sometimes it does work. same host, same script, same mysqld
<7> i did, maybe i missed it
<7> you know about it?
<11> hi, in my ubuntu system mysql -u root don't work but sudo mysql -u root works! Where the problem lies please?
<12> munzir: What do you mean by "don't work"?
<11> salle: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
<12> munzir: Check rw permissions
<11> salle: rw permission for which file, please?
<12> munzir: Isn't it obvious?
<12> munzir: Read the error message you posted above
<11> salle: if you mean mysqld.sock it's already srwxrwxrwx mysql mysql
<13> munzir: the directory above it probably isn't, though. you need execute access on the directory tree all the way up to that file.
<12> munzir: Is the directory readable for the user you are trying to run mysql as?
<11> salle: you are right the mysqld directory is 770
<11> salle: thanks a lot should I report this as a bug to ubuntu? or it's for a security reason?
<14> So... MySQL 5.0 with Clustering on FreeBSD... is this possible ... or not?
<14> make -DWITH_OPENSSL=yes -DWITH_NDB=yes install
<14> and I don't have the ndbd or other binaries...
<12> munzir: It's for root to decide!
<12> munzir: mysql.sock location is configurable and Ubuntu packagers decided to put it that way by default. Definitely not bug.
<15> hey all.. i'm getting this error on a select query - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
<15> I have no idea what it means!
<0> shabbs, i found the bug! and I submitted it: http://bugs.mysql.com/bug.php?id=17620
<0> woot.
<0> SCORES
<0> 2-0 canada
<14> lakez: w00t! :)
<0> shabbs, do you work for mysql?
<0> I know salle does... hey salle, can you see if they can fix that bug by 5.1.7 ? :)
<15> ok.. i've added SET SQL_BIG_SELECTS =1; to the start of my query in phpmyadmin
<15> and the query executes fine now
<15> however, if i add that to the start of the query in php, it doesn't work
<11> salle: thanks for the clarification but this means I can't run any site unless I changed it! for example I installed drupal and it won't work because of this
<15> i ***ume that SET SQL_BIG_SELECTS =1; sets a mysql parameter
<15> and so i should only need to do it once
<15> or should i have to execute it each time i run my query that i'm getting an error on?
<15> any suggestions?
<0> Welly, do you feel it's a mysql specific problem or php specific?
<15> lakez, i think it's a mysql problem
<0> if php, ask in a php channel, they'll know instantly
<0> ok i'll read what you wrote
<15> yeah, i know i said it didn't work in php
<14> so... nobody? 5.0 w/Clustering? FreeBSD?
<15> however, i'm running the query numerous times, so i'm wondering if it is a mysql option that needs setting somewhere/somehow
<0> run this on the server, set global sql_max_join_size=#...
<15> ok i'll give that a go
<0> MyQuiL, with all the clustering bugs fixed in 5.1.* i wouldn't bother with 5.0 clustering
<0> that's just me tho
<0> i'd just use 5.1.6
<0> they're going beta in 5.1.7
<0> at least that's what it looks like
<0> I just hope that query cache+rbr bug is fixed
<14> lakez: hrm, problem is these guys are production with 5.0, they don't want to move to 5.1 (which may or may not be wise)
<0> MyQuiL, this is mysql 5.0 specific docs: http://dev.mysql.com/doc/refman/5.0/en/ndbcluster.html
<0> so people are using it, I just am not
<14> I've been poring thru that for days
<0> i bet if you use normal stuff, it'll work out nicely... if you use advanced features you may hit bugs
<14> but when I build MySQL (from ports)... the ndbd and other binaries don't get build/installed
<0> MyQuiL, what's the prob? I don't use cluster but I might have a guess
<14> make -DWITH_OPENSSL=yes -DWITH_NDB=yes install <-- and they should
<0> ohh.. nano Makefile ... add in the --with-...
<14> heh - nano too eh? :)
<0> or don't use -D*
<0> SEC
<0> sec, heh
<0> you don't need -D
<14> .if defined(WITH_NDB)
<14> CONFIGURE_ARGS+=--with-ndbcluster
<14> .endif
<14> What's wrong with -D?
<0> do, make WITH_NDB=YES ...install
<0> only time i've ever used -D is for ... -DFORCE_PKG_REGISTER .. i think it just defines the variable... as a boolean, not as a "YES"
<0> try.. make WITH...=YES .... install
<0> trust me, it'll work my way cause i've done it 1000 times
<14> k...
<14> I've done it 1000 times the other way :)
<0> I used this on alpha : make WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes BUILD_STATIC=yes WITH_ARCHIVE=yes WITH_FEDERATED=yes WITH_PARTITION=yes WITH_NDB=yes install clean
<0> MyQuiL, that's more of a freebsd problem tho
<0> show variables like 'have%';
<14> lakez: building...
<0> MyQuiL, waiting for paypal....
<0> :)
<14> heh
<0> Love the nick
<14> Like NyQuiL?
<0> ya
<14> I go by 'Myke', which somewhere turned into 'Mykel' ... then I got really sick for several months and took on a lot of NyQuiL, so my mother-dear renamed me :)
<14> ... and 'Myke' is taken on FreeNode :)
<14> lakez: in lieu of funds, would you like me to go hand-deliver angst at 24 Sus***? ;)
<0> why did you get sick for several months? my gf has been sick for a week and a half taking nyquil/dayquil
<14> Mono.
<0> yeah i would
<0> i hate conservatives
<14> out of commission for 6mo.
<14> Ottawa is such a liberal town too.
<15> hmm.. right, i think i need to revise this query a bit
<0> Welly, i think it's breaking because you're not using an index on the join.. thus a SEQSCAN join ... and it breaks the max size
<0> cause it'll take 20000 years i'd think unless someone lowered the settings
<0> i've never hit that problem, ever.
<0> explain <query>
<15> oh right.. ok :) hang about, i'll pastebin the query
<0> Welly, no..
<0> Welly, paste the explain
<15> ok i won't
<15> paste the explain?
<15> <- relatively new to mysql
<0> welly, EXPLAIN <query>
<15> ok
<0> It will tell you what your query is doing inside mysql...
Return to
#mysql
or
Go to some related
logs:
kanotix 3Ddesktop
#mysql
maildir for postfix courier-pop squirrelmail
undefined symbol XvRTPort
azadder
virtual_alias_domain = mysql:
#web
damn small linux error15
#centos
force close_wait_2
|
|