| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> jeffzz: too late... http://bugs.mysql.com/bug.php?id=15287
<1> !m sjrussel string functions
<2> sjrussel: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<3> mysqldump generates INSERT ... VALUES (...), (...); Can I make it output standart INSERTRS?
<0> use --complete-inserts option
<3> TodoInTX: not avilable in 4.1
<0> erg... nevermind it didn't work like I thought anyway
<4> TodoInTX, just out of curiosity ... do you happen to know if this happens: go.go recieves dbi results, with a trigger to insert into processing.go (with the columns resolved to their respective ids for normalization) .. and then on the processing.go table, have an after insert that does heavy processing. My question is, will the go.go block waiting on the processing.go to finish? I don't think it should but just wondering
<4> i'm testing it, just wanna know if you know before i waste 1/2 hour
<5> I need some help. I'm trying to use the migration tool, but when I enter my target database it errors out and wont connect. Doesn't tell me why either.
<3> Any other option to make it output data in any other format?
<4> Cvbge, mysql -u blah -p -e -X "select * from table" database
<4> -X, --xml Produce XML output
<0> jeffzz: no clue on that one.
<6> !weather egnx
<2> Current conditions at East Midlands, United Kingdom: It is 2 C (37 F), windspeed is 20.92 km/h, and visibility is 11.27 km. (Information current as of 2006.02.08 2020 UTC).
<7> Ok mysql taking up 128mb of memory and I have 9 connections sleeping how can I clean free up some memory on mysql with out restarting mysql?
<0> zap123: reduce query_cache_size or key_buffer_size.
<7> what should I put it to?
<0> if you have no need for innodb, later you can restart with --skip-innodb and that will free up some and reduce the number of processes.
<0> zap123: that really depends.
<7> I am running a message board that has small load on heavy days only like 15 people at the same time
<7> should I just restart mysql so it free up the memory?
<0> zap123: you could, but the mem would just get used again.
<7> well seems like it happen over time
<7> I might be tracking the wrong proccess but seems like that is my memory hug
<0> what sort of ratio do you have for key_read_request to key_reads?
<7> what do you mean ?
<0> show status like 'key_read%';
<7> 7242
<7> sorry I am space mode
<7> key reads is 90
<0> 1/80 key lookups find the result in key_buffer. you can sacrifice some index performance by reducing key_cache_size.
<5> Can someone please help me with this migration tool? It absolutely will NOT connect to my server.
<4> ***yKen, can you connect to the server with the mysql client?
<5> Yes.
<4> I heard the NSA was doing spying on people using the migration tool, perhaps it's related to that ?
<5> Yea, perhaps.
<5> netstat doesn't even show the server attempting to connect.
<5> The migration tool rather
<5> What do you recommend please?
<5> This is not working.
<7> so probably not worth reducing then
<8> I'm getting this error, do i need to set the socket in php.ini? Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld-401.sock'
<7> I will have to look at my proccess list see what's killing me
<9> simmerz: or symlink
<7> thanks TodoIntx
<6> simmerz check if mysqld is running
<0> zap123: have a look at the link I sent to you.
<0> it's a tuning recommendations script I wrote.
<7> thanks
<5> It's saying "no route to host" but that's such crap I can connect using sql client
<7> I will check it tomorrow
<5> i can ping the box
<7> night
<5> everything else works fine.
<8> archivist: it is.
<8> symlink works. but as a permanent measure, I guess I want to change it to the right socket, right?
<6> yes
<10> I have an odd situation .. had a master db crash last night (HD glitch) .. got the master back up, repaired all the tables .. did the same with the slaves .. now the slaves won't restart. No errors, no nothin'. Does this sound familiar to anyone?
<11> what does show slave status say ?
<10> blank
<10> no status
<10> well
<10> I mean there are the numbers for log pos, log file, etc
<10> but no io or sql thread status
<10> or 'state', rather
<10> by all accounts, looks like it's ready to go .. slave start .. nothing .. no entries in the error logs either
<10> should I perhaps just record the positions and 'reset' the slaves?
<10> It probably wouldn't hurt me to take these 2 slaves down and restart them anyway .. I've been wanting to do that to set them to 'read only'
<10> well .. I've got the SQL thread still running apparently .. according to 'show processlist'
<10> tried shutting down the sql_thread .. then restarting .. still nada
<12> what is wrong with this query? SELECT * FROM events WHERE (client_id = 1 && DATE(start) > 9 && DATE(end) < 10)
<10> well .. I'd put some more ()'s in there, but that's just me
<13> hi - I am doing a select like Select id, COUNT(id) from etc... but I want to refer the id back to another value. Wrapping it with SELECT name FROM db WHERE id IN (<-PREVIOUS STATEMENT... ) wont' work 'cos of the COUNT. Any better way of doing this?
<14> Hey, in my.cnf under [mysql], for character-sets-dir and default-character-set, what should they be to use latin1 for default, instead of utf8?
<14> Should they be simply, latin1?
<15> I used a long for an GPS Coord, it truncated it to the 4th decimal, what would hold more?
<12> I have a table with two fields start (datetime) and end (datetime), I want to get a date string like 2006-02-8 12:23:22 and basically query for records that have start dates within the current month. how do I do this?
<16> hmmm, torrentflux is giving me this error :
<16> Warning: mysql_connect(): Access denied for user 'user'@'localhost' (using p***word: YES), anyone know what i funked up today?.
<17> hi i am trying to install mysql server from the synaptec package manager, and it keeps asking for the CD...
<17> is that normal? i do have the i686 kernel, but i am using the i386 kernal
<15> csb, check the PATHs env's
<18> question, recently I believe my host upgraded to phpmyadmin 2.70 pl1 Now when i click a table i can't see the link to insert data via text file... What does that indicate?
<15> it's prolly looking for the package or depend on /mnt/cdrom/packages/blahhh
<19> Would creating more fields on a table cause more loading time within queries even if I'm not selecting those queries?
<20> can anyone tell me a good gui program to allow me to connect to my MySQL server please?
<20> program for windows
<19> MySQL Query Browser -- Use this graphical client to work with your MySQL databases and run queries
<19> http://dev.mysql.com/downloads/query-browser/1.1.html
<19> Try that mate
<20> thanks
<0> dm: LONG => BIGINT ?
<10> if a slave just refuses to start, there should be SOMETHING in the logs, right?
<19> TodoInTX: No, a bunch of small tinyints actually heh
<19> But like...20 of them
<21> how could i change the encoding of a database? i want to use greek characters and utf-8 is what i want
<4> TodoInTX, yeah it does block
<0> dm: why not just use float, or double?
<0> or even better "POINT"
<0> virgomoon: yes
<10> TodoInTX, this one has be baffled, then .. no error status in the show slave status .. nothing in the server logs
<10> it just damned won't start .. I'm having flashback of looking at an old clunker in disgust with my grandpa
<0> restart mysql with --skip-slave-start, then issue "slave start" manually.
<10> worth a shot
<0> I've seen mysql not give a error when it has log file issues. You'll see the error during the manual "slave start"
<0> but only once.
<0> usuially the master log doesn't exist.
<0> you may need to "reset slave" then "change master to..." whatever the last good position was.
<10> already tried that last part
<5> Hey guys -- does anyone have experience with the mySQL Migration Tools?
<10> checked .. master log is there
<10> double checked spelling .. ok
<0> are all the files in the relay log index file present?
<10> well .. I don't know .. let's find out
<10> yes
<5> The Migration Tool is giving me a "no route to host" error,but there really is a route to host. I can ping it fine.
<10> yeah .. it already started a new relay-bin .. I made sure the IO and SQL thread were at the same pos and did the slave reset
<0> did the manual slave start reveal anything?
<10> nada
<22> LOL I'll trade my experience trying to get the oracle 10g for non-commerical freebie for you experience with mySQL Migration Tools. What a nightmare. Glad I don't have to use Oracle for real anymore. Haven't used it since 8.0 It's mutated.
<10> oo oo
<10> wait
<10> yes it did
<10> in the logs
<10> oh, this is a good one
<5> capgadget, what ?
<10> Client requested master to start replication from an impossible position
<10> that's new
<10> besides the obvious .. wtf does that mean?
<0> remove the master.info file from the slave and run "CHANGE MASTER"
<0> after restarting mysql again.
<10> ok .. remove the master.info .. shut down, restart and change master, right?
<0> eya
<0> yea
<10> k
<0> with skip-slave start enabled.
<10> TodoInTX, ditto .. I'm gonna have to pull in that binlog and bring it up to the end of that one manually aren't I
<0> probably.
<0> unless it's easier to snapshot the master and start from their.
<10> TodoInTX, oh no ... 46GB
<0> ok relay log it is.
<0> ;)
<10> am I going to get the same 'impossible position'?
<0> no, not if the master.info file is gone and you've set "CHANEG MASTER ..." to a valid log and position on the master.
<23> quick question on replication, i've got replicate-do-db=exampledb but what if i need to do more than one db?
<10> no, I mean when I try to merge in the binlog
<10> brb .. diaper duty
<4> self change?
<24> thank goodness for Depends
Return to
#mysql
or
Go to some related
logs:
#perl
varchar or tinytext
totem-xine flickers
perl string as regexp
#perl
#perl
udev repopulate
mac address ban
ipt_time gentoo
#ubuntu
|
|