| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> cudgel, I just type crap in
<0> archivist, the improper error message is a bug
<1> archivist: you mean the page on that storage engine?
<2> yes
<3> Ungy: well, that's obviously what i'm trying to avoid.
<3> Ungy: plus, I don't really wanna remember stuff about ~100 databases
<4> Ungy: sry, but in this manual they dont tell how to create an clustered database, they use the test DB
<4> i just wanna know the switch which create the database in clustermode
<5> they say, we need to create the databases on all notes
<0> Schamane, hmm I believe you have to create it on each seperatly but I haven;t done any clustering myself
<5> nodes*
<0> johnjacky, that is what I thought as well
<4> johnjacky: oh thx, that means i have to create all 3 tables manual?
<4> and then they cluster themselve automatically
<5> yeah that is pretty tough :-( But once db's a recreated with ndcluster engine it syncs perfectly..but again, you need to be watch for the MaxNoOfConcurrentTransactions alerts
<4> johnjacky: hm, that ****s ;) i thought it would be easier
<4> but what do you mean with recreated? how get they synced? i will now create three databases on both nodes
<4> and then we will see ;)
<4> i think i`ll be back soon ;)
<6> hi. i have a MySQL performance question: i execute a SELECT statement 3000 times and it takes 5.6 secs. additional info here: http://pastebin.com/546759 is that expected or too long?
<1> Ungy: hmm it seems although you can use varchar memory table wastes the whole defined space
<1> so there's no point in declaring a varchar()
<0> Narada, interesting
<1> and in my case disappointing
<4> Ungy: johnjacky: thx a lot it really works
<4> you justhave to create the databases on both nodes
<4> they sync automatically
<0> Schamane, isn't that what we both said ;-)
<4> next question :)
<4> no ;)
<7> fastcall : Does primary key enforce that id is unique?
<8> multichil: yes
<9> guys is there a possibility in mysql to compare the similarity of two texts?
<8> tokyoahead: "compare"?
<9> ah ok
<9> I will check that
<9> thanks
<8> tokyoahead: no, what do you mean by compare?
<9> inviso ah ok :-)
<9> well I have two tables with text
<9> and some of them are supposed to be very similar
<9> I want to find them
<8> hmmm, so not exactly the same then
<9> sorry the prior question was wrong... I want to find similar texts
<8> !man full text search
<10> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<9> no they are not
<6> multichil: i just added a unique key to be sure, is there anything i have to do to reflect the changes?
<8> tokyoahead: full text search isn't quite what you need either... How long is the text?
<8> !man soundex
<10> (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<1> archivist: Ungy: when i changed the size of varchar to the recommended 21845 it says: ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs.
<8> and soundex probably doesn't handle large enough values
<1> argh! what size varchar can i use with memory table?
<1> no matter what i use it complains
<8> Narada: it's complaining about total row size
<1> ahhh
<11> I'm trying to delete a record from two tables. I get an sql syntax error.. Can someone tell me what's wrong with this query..?
<0> Narada since TEXT and blob do nto count against the Row size you need them for larger rows however memeory table doesn't support it so it seems to me Memory table isn't right for you in this situation
<1> hmm 21802 max works
<11> DELETE FROM pin, registrants WHERE pin.id='10' AND registrants.id=pin.customer_id
<1> Ungy: http://pastebin.com/546800
<1> Ungy: that's what i've settled on
<0> !m xbeanx DELETE Syntax
<10> xbeanx: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/DELETE.html
<8> tokyoahead: I'm not sure there is anything that really meets your need. My only suggestion is to give full text indexes and MATCH a shot.. perhaps MATCH(col1) against (col2) as score order by score limit 100 would work? Seems like it will be terribly slow though
<12> Narada, what are you using this for?
<12> cacheing?
<1> db driven session
<12> the varchar is a serialized variable or something?
<0> heh
<11> thanks, Ungy
<12> I think this is a bad idea
<1> sjrussel: it's whatever php puts into it yes i think it is serialised
<1> Ungy: why? is something bad about that idea?
<1> sjrussel: why
<12> you don't know how big that data will be
<12> you will get corruption
<0> Narada, yeah what he said
<1> sjrussel: it will be as much data as i put in there
<4> bye
<1> sjrussel: how will it get corrupted
<12> a better solution is to just use regular MyISAM table. Are you SURE that's too slow?
<12> if the serialized var is bigger than the column
<1> sjrussel: yeah i had a think about that; we decided to make very lightweight use of sessions but the limit is a problem
<0> OK I am off got too much work to do too hanfg out here today ;-(
<1> Ungy: take care and see you around
<12> if MyISAM is too slow, a custom solution using memcached + a MyISAM backup is probably workable
<1> sjrussel: memcached?
<12> !google memcached
<10> memcached: http://www.danga.com/memcached/
<13> inviso, WHO DO YOU WANT ME TO KICKBAN?
<14> how do i delete all rows where a certain field is blank?
<13> WHERE field = ''
<14> i tried that...
<14> delete * from e107_news where title = '';
<14> it errors out
<13> !m mindamp delete
<12> what errror?
<10> mindamp: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/DELETE.html
<14> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from e107_news where title = ''' at line 1
<14> i know how to use the delete syntax...
<14> but theres something wrong
<12> no, you don't
<14> something i forgot perhaps..
<12> yeah, hte '*'
<14> uh huh
<13> !m mindamp delete
<14> thats new...
<10> mindamp: (DELETE Syntax) : http://dev.mysql.com/doc/mysql/en/DELETE.html
<14> i got it the first time will
<13> Didn't seem like it.
<12> uh, no, there's never been a '*'
<12> it's not new
<14> i know theres never been a *
<14> thats why i didn't have it in there..
<12> huh???
<14> uh huh
<12> it's in your query AND in the error
<14> #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* from e107_news where title = '*'' at line 1
<14> oh
<14> hah
<14> now i get it :-)
<13> ...
<13> He didn't seem very grateful to you sjrussel ....
<12> embarrasment does that
<1> is memcached reliable and stable would you say
<13> heh
<12> well, it's more stable than your solution and app
<1> heh
<1> i haven't built it yet and you're already unhappy :)
<12> it's used by LiveJournal
<12> and Slashdot
<1> i see
<1> okay great
<1> language independent right?
<12> did you read the page?
<12> it's just a memory bucket, so probably
<1> k
<12> I don't know if the tokens support unicode, if that's what you're asking
<15> zeitoun, Bingo, Many thanks
<16> Eggplant: pardon me ?
<16> Eggplant: err... ok got it... already forgot since it was what..... 8 hours ago ?
<16> :)
<15> zeitoun, Yup something like that, I had to get my kid in bed and ended up falling alseep myself =\
<15> He has decided to be afraid of the dark
<16> Eggplant: I was wakin up at that time :)
<16> that was right after coffee and toasts :)
<15> zeitoun, what time was it for you? midnight here
Return to
#mysql
or
Go to some related
logs:
SYN_SENT netfilter
bmac Ethernet g3 ubuntu
#math
#kde
rshadow runescape
xfi under linux
ubuntu via82
#oe
yum not seeing ffmpeg
dovecot and transfer speed
|
|