Hello,
I would like to solve this problem.
I get a Connection instance from a connection pool, create some
statements and prepared statements, do some database operations, close
all statements and return the connection to the pool.
My question is, are the statements released (garbage collected) aft
ter I make this "alter table" action, can it have a
negative impact on MySQL performance or required disk space? It is
just an ordinary non-indexed column, not used in where or sort by
conditions.
Thank you.
Filip Rachunek
--
MySQL General Mailing List
For list archives: http://lists.
Are you sure you don't have any errors in your SQL? Maybe your query
returns a karthesian product - and this might kill your J2EE
application.
Check out your slow-log - the query is probably there.
--
Per Andreas Buer
Thanks for your response Per. Yes, the query is at my slow-log, I already
know
Hello,
can somebody tell me what the status "Writing to net" returned by "show
processlist" exactly mean? I've tried to find it in MySQL documentation but
either it's not there or I missed it.
I am asking because this status is usually shown when my J2EE application
[using Connector/J 3.0.9] starts
7 | 18446744073709250021 |
+-+---+--+
1 row in set (0.00 sec)
I have no such problem on MySQL 3.23.53, in both cases I get the same
result. Is it a MySQL 4.x.x bug? And what can I do to avoid it in the
future?
Thanks for all help.
