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 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]
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- 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]
