| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<tdn> TodoInTX, are there no differences between databases from a 5.0 server and a 4.1 server?
<Psykick> ok well I've made another change ... the warnings have gone from 9 down to 3
<Psykick> but still getting warning 1329 "No data to FETCH"
<TodoInTX> tdn: are you copying the files directly or doing a mysqldump from 5.0?
<mm-mysql> Psykick: Ah, that's something different then...
<mm-mysql> Sounds like you're iterating a cursor that is empty (for some reason)
<TodoInTX> tdn: I only have a MySQL 5 and 3.23 box handy to test with.
<tdn> TodoInTX, well... I copied the database files directly from the backup to a Windows MySQL 5.0 server. Then I am doing mysqldumps and pipe them into mysql on my production server (which is running 4.1).
<Psykick> not using cursors ... at least I don't think I am
<tdn> TodoInTX, but is mysqldump not needed?
<TodoInTX> tdn: you may not have a consistent backup then.
<tdn> TodoInTX, hmm...
<tdn> TodoInTX, it should be...
<TodoInTX> mysqldump is perfered method from 5.0 -> 4,1
<Psykick> in my stored procedure I'm using basic select statements that ***ign the selected value to declared integers
<tdn> TodoInTX, ok.
<tdn> TodoInTX, that is what I am doing.
<TodoInTX> mysqldump --compatible=mysql40
<tdn> TodoInTX, there are 46 databases in the backup. Each and everyone of the other bases are working fine.
<Psykick> I've put the stored procedure on pastebin
<Psykick> http://hashmysql.org/paste/1454
<elJo> aahm... shouldn't last_insert_id() return only one row?
<HarrisonF> yes, but only if you use it correct
<tdn> TodoInTX, do you think that my backup of that database is broken?
<HarrisonF> don't select it from a table
<elJo> HarrisonF: so, how do i use it correctly?
<HarrisonF> SELECT last_insert_Id();
<tdn> TodoInTX, because it gives me that error with a table not existing when using LOCK TABLES?
<elJo> HarrisonF: ah, thanks
<Psykick> I think I've figured out what was wrong with the query
<TodoInTX> Or like I said before... the number of tables you are trying to lock all at once is higher than the number of allowed open files.
<TodoInTX> tdn: you will probably find that if you dump each database independanty you won't get this error.
<tdn> TodoInTX, I *am* dumping each database one at a time.
<tdn> TodoInTX, when I got to this database it failed.
<will> WHO WA HA HA HA HA
<MacWeenie> i have a list a postcodes with x/y coordinates in meters from a fixed point. I'd like to get all postcodes within z meters of an inputed postcode. can i do something with mysql like: select * from postcodes where sqrt((x1-x2)^2+(y1-y2)^2) < z
<MacWeenie> basically leave the distance calculation for mysql to do on each of the postcodes.. there about 2800 postcodes
<HarrisonF> sure, or you could use the GIS stuff
<HarrisonF> which can handle all of the math for you
<lsmith> there should be a strict sql mode that prevents non grouped, non aggregates to be contained in the select list when aggregating
<HarrisonF> lsmith: there is
<lsmith> ah goody
<lsmith> then they should turn it on by default :-)
<HarrisonF> ONLY_FULL_GROUP_BY or something
<HarrisonF> yea, lets break 90% of the applications out there by default ;)
<lsmith> HarrisonF: great .. more work for someone to get paid for :-)
<ehc> I am getting the error "Access denied for user: 'user@localhost' (Using p***word: YES)" How can I give this user access?
<farrioth> So.. I've just added an entry to a table, how do I now find out the entry's PK value?
<crackintosh> are there any upgrade guides available for mysql? I have version 4 installed via an rpm from my linux distro and I will be installing 5 from an rpm should i be concerned about anything?
<beetlepun> crackintosh, y, backup your tables first :)
<litheum> crackintosh: you should be cocnerned about a lot of things! :)
<litheum> crackintosh: are you using 4.0 or 4.1 right now?
<crackintosh> i am using 4.1
<crackintosh> i am going to back up the databases before the upgrade
<crackintosh> im going to shutdown mysql
<crackintosh> then I am going to install the rpm.
<crackintosh> and hope for the best.
<farrioth> I'm using PHP with SQL. How can I get a value from an item I just created?
<Jy> farrioth: that is a #php question
<Jy> and its RIGHT in the mysql section on the php docs
<litheum> crackintosh: you should read the upgrade guide, perhaps?
<litheum> !m crackintosh upgrade 5.0
<SQL> crackintosh: Nothing found
<litheum> !man upgrading 4.1
<SQL> (Upgrading from Version 4.0 to 4.1) : http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html
<litheum> !man upgrading 5.0
<SQL> (Upgrading Replication to 5.0) : http://dev.mysql.com/doc/mysql/en/Replication_upgrade_5.0.html
<litheum> lol
<litheum> stupid *** bot
<litheum> crackintosh: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.1.html
<crackintosh> thank you
<crackintosh> weird, I was already reading that document!
<kibab> Hey, I have a query that appears to run and fail on the master, yet makes it to the slave and kills replication. Any ideas?: http://pastebin.com/556889
<kibab> btw, I didn't design the db... I know it's horrible (and the maintainer is on vacation for two weeks ;( )
<rickhax> Hello. I am running mysql 5 EL4 RPM on centos 4. My mysqld_safe process is not creating multiple mysqld children. this seems to be hindering system performance
<rickhax> is there a switch for this?
<firewire> mysqld_safe does not create children
<kibab> rickhax: perhaps a poor default setting? "show variables like '%max%'"
<crackintosh> litheum: im just wondering about upgradeing the rpm file
<rickhax> ok, let me run that
<litheum> crackintosh: what do you mean?
<rickhax> http://pastebin.com/556897
<rickhax> kibab, can you check it out real quick?
<kibab> rickhax: seems reasonable... 'mysqladmin processlist'?
<wrack> )
<kibab> (or 'show processlist')
<kibab> Nobody has any ideas on the replication dieing? It shouldn't be able to happen as nobody can connect to the slave, the dump happened during a 'flush tables with read lock;' .... it works fine for about 30 minutes or so, then the same query (or one very similar) runs again.
<kibab> mysql-5.0.18 on both boxes...
<rickhax> http://pastebin.com/556905
<rickhax> there it is kibab , thanks
<rickhax> my connections are sleeping but its normal
<rickhax> i need my db to handle tons of connections, froma remote server, new ones take like 3-5 sec
<kibab> You have allowed plenty of connections.... you aren't even close to your max... why do you think it's the db?
<rickhax> for example, when i telnet to port 3306 from my server on the same lan, it takes a while to get a prompt from mysql
<rickhax> but when i telnet to port 80, apache greets me instantly
<rickhax> so i know its in the application. also my php script hangs on mysql_connect()
<rickhax> i strace'd it, and its hanging on the connect() sys call
<kibab> rickhax: so it doesn't matter what db you connect to?
<rickhax> let me verify
<rickhax> no, it doesnt. its the connection to the mysql server that is lagging
<kibab> rickhax: if telnet is slow.... then it shouldn't matter...
<rickhax> when I look at PS, i notice there is only one mysqld running under mysqld_safe
<kibab> strange firewall policy... dropping packets? What happens if you log packets to that port? ethereal/tcpdump? etc.?
<rickhax> when I look at my other servers running mysql 4.1, there are tons of mysqld children running
<rickhax> no firewalls involved
<rickhax> software or hardware
<rickhax> so, i think mysqld can only handle 30-40 connections per process. is this possible?
<rickhax> i think there should be many mysqld children spawned
<kibab> rickhax: ps auxmm | grep mysql
<rickhax> http://pastebin.com/556918
<kibab> rickhax: so it's only using threads right now... not extra processes
<rickhax> ah ok. i didnt know that would check for threads
<kibab> rickhax: hmm... how "busy" is that box?
<rickhax> not busy at all, no other services
<rickhax> only this choking mysql. its a fast box
<rickhax> load average: 0.04, 0.02, 0.00 / -/+ buffers/cache: 161 849
<kibab> rickhax: hmm... you could try attaching strace to the mysqld process (and have it view children) right before you connect... not sure what else to say, seems really strange?
<rickhax> ok, ill try that. thanks for your advice and help dude
<rickhax> is there a way to switch mysql to multi process rather than multi threaded
<kibab> rickhax: I don't know that you can control it...
<kibab> rickhax: almost all of your threads were sleeping anyway.... so it shouldn't need to spawn it.
<kibab> rickhax: almost sounds like something os/kernel level is going on with it.
<kibab> hmm.... TCP_NODELAY? not sure.
<kibab> Well, I have to get home to pick up kids... good luck. I'll be back tomorrow... but hopefully you'll have it answered before then.
<tom7e> if i get errno 2 error and it says a directory doesn't exist which does, does this mean i need to clean caches?
<kibab> rickhax: I don't suppose there's anything obvious in the error log?
<kibab> tom7e: sounds like the directory really doesn't exist to me... unless you have filesystem corruption or you have a stale link to it.
<tom7e> ok i must have filesystem corruption or stale link
<tom7e> thanks
<kibab> tom7e: run fsck on the system and see if that fixes it.
<kibab> ok... I'm really leaving now ;)
<tom7e> shared hosting, can't run fsck
<tom7e> i will check my links
<will> You go do that.
<will> Then come back with a report.
<will> Join quit Join quit Join quit Join quit Join quit Join quit Join quit Join quit Join quit
<jpm_> litheum: you adorable child, thanks for the valentine's day card
<litheum> hahaha
<litheum> yes!
<jpm_> litheum: but what's up with the batman theme?
<litheum> that's what they had at the drugstore
<jpm_> nice
<litheum> yep
<jpm_> no thought given to it
<litheum> they also had polly pocket or something
<litheum> batman was the best combination of ridiculous and not-completely-out-of-control
<jpm_> so am i the only lucky person to receive such a ****ing ridiculous gift?
<litheum> dean and bryan were also so blessed
Return to
#mysql
or
Go to some related
logs:
d-link di-704 slow connection
#debian
#debian
evolution junk dapper
#perl
perl-Term-ReadPassword rpm
how to burn .img in ubuntu
mysql alter table add auto_increment
gentoo samba-client ebuild
#lisp
|
|
