| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> !rtfm grant
<1> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<0> ;)
<2> thanks
<2> after i have create a user i have typed GRANT USAGE ON *.* TO 'dummy'@'localhost';
<2> i just want this user to make queries not changes
<2> after on i have placed *.* but i cannot access databases why ?
<0> USAGE Synonym for gno privilegesh
<2> i dont know if i have understand since you are not using the right charset but you are just saying usage = privileges ??
<2> i get this from the page: Synonym for ?no privileges? ok i get it
<3> Hew you found any problems with setting FK constraints after upgrading to 5?
<4> If I have this query: SELECT table1.* FROM table1, details WHERE table1.id = details.id GROUP BY details.location how can I get the max(items.update_at) record?
<4> instead of the first record
<5> what do you guys use to edit your stored procedures (long sql files)?
<5> sod it; i'll just use vim
<5> ;)
<6> can I safely ***ume that LIMIT X, Y; can always appended to an SQL SELECT statement?
<7> mornin, i've a question regarding binlog and replication
<7> if the master writes a statement to the binlog, but don't flushes the disk
<7> will the slave read this statement immediately?
<8> hi. i got a question regarding replication. At the moment every time a script does INSERT INTO tbl SELECT foo, bar FROM othertbl on the master, the replication is dropped because of duplicate key violations on the slave. Is it possible that the mysql replicates the stuff twice, once the insert ... select and the subsequent inserts made on the master afterwards?
<5> eleftherios: only if you want to limit obviously
<9> is there a way to set a mysql server to read only?
<7> roo9: yes, set global read_only=ON
<10> roo9: set global read_only??
<10> roo9: set global read_only=1;
<6> Narada, sure. I am just asking if it can always be appended to SELECT statements (given that LIMITing is desired)
<10> :
<8> roo9 chmod 555 /var/lib/mysql/tblname ;-)
<9> lol
<10> ninan: wouldn't work that well with innodb
<9> chmod 555 /var/lib/mysql/ibdata1 ?
<5> eleftherios: yeah
<7> i use this read_only for ring replication
<9> -/-/
<8> hehe, smiley states it was a joke
<8> ;-)
<6> Narada, thank you
<8> dont try that at home, children. ;-)
<7> Leith: do you know how the slave reads the binlog on the master?
<7> i'm working on a ha szenario for mysql with ring replication
<9> ok, except that doesn't work
<7> roo9: read_only doesnt work for root
<9> set global read_only=1;
<9> oh
<9> ok
<9> lol, how did you know :P
<7> read_only=ON
<7> not 1
<11> such as?
<7> Leith: i need to be sure that the slaves can read the binlog statement without the need to flush the binlog to the disk ;)
<11> that would seem somewhat of a bad thing to do in a HA environment no..?
<9> ok, it still doesn't work
<11> you want at least one set of binary lgos that ar "complete" at any one point in time
<9> even for a non-root user
<7> Leith: right
<11> so let's not even thing of trying to do that then right..? ;)
<7> Leith: maybe you misunderstood me a bit ;)
<11> ok well carry on the :P
<7> i'd like to know if the slave reads the binlog from the master right away, or only if the binlog is written to disk
<7> there is a thread on the master that pushes the data to the slave?
<7> the doc is somewhat unclear
<7> do you know how expensiv sync_binlog is?
<11> the slave pulls the data from the master, yes it connects to the master (see it as a system user in processlist)
<11> slave basically runs two threads, the I/O thread (connects to the master, pulls the binary logs) and the SQL thread (applies the changes on the slave)
<7> i see
<7> so the io thread can read the binlog without need to flush the binlog to disk?
<5> I'm still amazed at how the concept of boolean managed to escape mysql.
<7> Narada: ?
<5> SELECT IF(t.leftval=(t.rightval-1), 1, 0) AS leaf FROM acl_nsm AS t WHERE t.item_id=?
<5> I'm using 1's and 0's.
<5> But I'm not sure if that's really the best way.
<5> !man if
<1> (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<7> everyone uses 1 and 0 ;)
<3> I'm about to tell that there is something screwed up in InnoDB FK in 5.0
<5> teite: Excellent.
<11> I'm not 100% sure whether it can be read from the buffer or the from the disk (and of course it would depend on sync_binlog etc. as well)
<7> Narada: well i'm refering to coding in general ;)
<7> Leith: thats what im wondering a bit ;)
<11> domas: any idea?
<5> i see
<10> yes, slave reads binlogs without flushing it to disk
<3> Do i do something wrong when trying to set up FK constraint: ALTER TABLE `customerRecommendations` ADD FOREIGN KEY (customerId) REFERENCES customers(id); ERROR 1025 (HY000): Error on rename of './test/#sql-1872_a' to './test/customerRecommendations' (errno: 121)
<11> woo there we go
<12> .
<7> domas: thx ;)
<3> All tables are empty.. so it's structure probem.
<7> zimnyx: strange error
<3> Indeed...
<3> and error doesn;t occour if i turn off other FK, and create it back...
<3> IS it possible that this is bug in 5? error occoured after upgradng to 5
<13> !perror 121
<1> System error: 121 = Remote I/O error
<1> MySQL error: 121 = Duplicate key on write or update
<13> zimnyx: Sounds like something wrong with filesystem
<7> whats wrong with this my.cnf config: innodb_data_file_path = ibdata01:128M:autoextend:max:1G;ibdata02:128M:autoextend:max:1G
<7> i'm getting syntax error on this line
<7> The autoextend attribute and those following can be used only for the last data file in the innodb_data_file_path
<7> ok never mind
<7> :>
<3> salle: on 3 different machines? not possible (i use reiserfs, other boxes ext3)
<13> zimnyx: Yes that sound impossible
<4> can someone help me with a group by question?
<13> zimnyx: SELECT VERSION(); ?
<14> hello
<13> mhsd: No one can help you if you don't ask your question :)
<13> teite: autoextend
<13> teite: You can have it at the end only. That's because only last file can grow.
<3> salle: what's more, the referencing table has one FK, if i remove it and create again, this error doesn;t occour. so maybe mysql tries to use wrong (existing) name for constraint?
<3> salle: 5.0.18-Debian_9-log
<7> salle: yeah got it already
<13> zimnyx: Can you post table structures somewhere so I can test it? SHOW CREATE for both tables
<4> salle: if i do a max(credit_cards.ccexp) how do I get the values of the same row. ie. credit_cards.ccnum
<3> salle: can i PM you?
<13> zimnyx: Yep
<13> mhsd: Subquery
<5> wow yet another version is out
<15> any one arround
<16> hey, how would i select a random row from a table?
<16> oh n/m got it
<11> !perror 121
<1> System error: 121 = Remote I/O error
<1> MySQL error: 121 = Duplicate key on write or update
<3> Leith: can you help us with possible bug?
<3> can i PM You?
<11> what is it?
<3> PM?
<11> is i super secretive?
<5> hehe
<3> Leith: bug no, but tables a bit
<11> ok
<13> zimnyx: No need to flood everyone with your test case :)
<3> salle: i kindly ask
<13> zimnyx: If you drop and recreate the table the problem disappears just like if you drop the keys and recreate them
<3> salle: yes.. but it should work without it, shouldn;t it?
<13> zimnyx: Yep.
<17> exit
<13> zimnyx: The error itself indicates duplicate key name, but I don't quite agree it is the case
<3> salle: that was just my guess.. i really dunno what causes the problem
<3> maybe Leith will firuge something out
<3> i hope you won't enter http://dev.mysql.com/mysql_51_contest.html :)
<8> hi. i got a question regarding replication. At the moment every time a script does INSERT INTO tbl SELECT foo, bar FROM othertbl on the master, the replication is dropped because of duplicate key violations on the slave. Is it possible that the mysql replicates the stuff twice, once the insert ... select and the subsequent inserts made on the master afterwards?
<11> salle: how did you reproduce the error?
<3> Leith: i pasted him the same instruction like i PM you.
<11> those worked no problem
<11> on 5.0.19
<3> Leith: i use 5.0.18
<5> weird how come it says 5.0.20 GA in topic but on the website downloads are still on 5.0.19
<3> Leith: after importing structure i gave you, try: ALTER TABLE `customerRecommendations` ADD FOREIGN KEY (customerId) REFERENCES customers(id);
Return to
#mysql
or
Go to some related
logs:
compiz klipper
Can't locate Algorithm/GenerateSequence.pm in @INC
#web
remove a perl module
sent an invalid ICMP broadcast
#ubuntu
fuseftp sarge stable
#php
kdevelop debug Application does not exist
gentoo input/output error command not found ls
|
|