Re: mysqladmin question
Hello. MySQL team verified this issue, but they've said that this is rather a feature request, not really a bug. See: http://bugs.mysql.com/bug.php?id=13032 Jason Pyeron [EMAIL PROTECTED] wrote: Thanks Michael, but it now seems that on prepared selects, the values are still place holders, whilst on prepared inserts they are substituted in. Does anyone know how to address this issue? +-+---++---+-+--+--++ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--++ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | Sending data | SELECT id, pathref, version, mdate, ddate,size, md5 FROM files WHERE (version, pathref)=(SELECT MAX(version),pathref FROM files WHERE pathref=? group by pathref) | +-+---++---+-+--+--++ 2 rows in set (0.01 sec) mysql show full processlist; +-+---++---+-+--++--+ | Id | User | Host | db| Command | Time | State | Info| +-+---++---+-+--++--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | update | INSERT INTO files (pathref, version, mdate, ddate, size, md5) VALUES (51943,0,1060907651000,NULL,64685,NULL) | +-+---++---+-+--++--+ 2 rows in set (0.06 sec) mysql On Tue, 6 Sep 2005, Michael Barnett wrote: You can log on to your mysql server and run: show full processlist; That should give you what you are looking for. -m On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote: mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+ -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqladmin question
mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+--+--+--+ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--+--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0| Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0| | show processlist | +-+---++---+-+--+--+--+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin question
You can log on to your mysql server and run: show full processlist; That should give you what you are looking for. -m On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote: mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+-- +-- +- -+ | Id | User | Host | db| Command | Time | State| Info | +-+---++---+-+-- +-- +- -+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0 | Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0 | | show processlist | +-+---++---+-+-- +-- +- -+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from your system and notify the sender immediately. Any other use of the email by you is prohibited. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqladmin question
Thanks Michael, but it now seems that on prepared selects, the values are still place holders, whilst on prepared inserts they are substituted in. Does anyone know how to address this issue? +-+---++---+-+--+--++ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+--+--++ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | Sending data | SELECT id, pathref, version, mdate, ddate,size, md5 FROM files WHERE (version, pathref)=(SELECT MAX(version),pathref FROM files WHERE pathref=? group by pathref) | +-+---++---+-+--+--++ 2 rows in set (0.01 sec) mysql show full processlist; +-+---++---+-+--++--+ | Id | User | Host | db| Command | Time | State | Info| +-+---++---+-+--++--+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Query |0 | NULL | show full processlist | | 117 | crisfield | testserver:40291 | crisfield | Execute |0 | update | INSERT INTO files (pathref, version, mdate, ddate, size, md5) VALUES (51943,0,1060907651000,NULL,64685,NULL) | +-+---++---+-+--++--+ 2 rows in set (0.06 sec) mysql On Tue, 6 Sep 2005, Michael Barnett wrote: You can log on to your mysql server and run: show full processlist; That should give you what you are looking for. -m On Sep 6, 2005, at 1:24 PM, Jason Pyeron wrote: mysqladmin is truncating the output, how can i disable this? or is there a better way to examine what the serer is executing at that moment in time? [EMAIL PROTECTED] root]# mysqladmin process +-+---++---+-+-- +-- +- -+ | Id | User | Host | db| Command | Time | State | Info | +-+---++---+-+-- +-- +- -+ | 110 | crisfield | 192.168.1.104:2655 | crisfield | Sleep | 70 | | | | 117 | crisfield | testserver:40291 | crisfield | Execute | 0| Sending data | SELECT id, pathref, version, mdate, ddate, size, md5 FROM files WHERE (version, pathref)=(SELECT MAX | | 127 | root | localhost | | Query | 0| | show processlist | +-+---++---+-+-- +-- +- -+ [EMAIL PROTECTED] root]# -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - - - Jason Pyeron PD Inc. http://www.pdinc.us - - Partner Sr. Manager 7 West 24th Street #100 - - +1 (443) 921-0381 Baltimore, Maryland 21218 - - - -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, purge the message from
mysqladmin question
Hello, I have an error when the system (Linux 7)goes to rotate the logs. I get an error sent to me by cron daemon that access is denied for user root @ localhost using password=no. I had this same problem when I first installed the RPM when I was trying to set a root password. when I issued the mysqladmin command to set password I got the same message. I ended up setting the password manually in the mysql database using sql. Has anyone heard of this or had this problem? Please Help! My log file is HUGE! Thanks, Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
