How identify long running query etc?

Using MySQL and InnoDB, are there system tables or other tools that I can use to see which statements that are executing have consumed the most CPU time and find out which user, transaction and/or connection those statements belong to? If I identify a user that is causing a problem is there a way

Is the table cache used with InnoDB?

I cannot tell from the Reference Manual whether the table cache is used with the InnoDB database engine or not? It sounds like it only applies to tables that are stored in separate disk files. Is the table cache used by InnoDB? Bill -- MySQL General Mailing List For list archives:

RE: Do InnoDB rollback segments expand dynamically?

: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Monday, September 08, 2003 10:44 PM To: [EMAIL PROTECTED] Subject: Re: Do InnoDB rollback segments expand dynamically? Bill, - Original Message - From: Bill Todd [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday

How much memory does MySQL need?

I know, I know, with database servers more is always better.g However, assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost is a significant consideration. Is there any information available on MySQL's memory requirements? Most database vendors give you something as a

BDB transaction isolation levels?

What transaction isolation level(s) does BDB support? I can't find any information on BDB transactions section 7.6 of the manual. Thanks, Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Difference between Serializable and Repeatable Read with InnoDB

Since InnoDB does not allow phantom reads with Repeatable Read isolation (which are allowed in the ANSI SQL definition of Repeatable Read) what is the difference between these two isolation levels. Is it just serialization and that is all? Bill -- MySQL General Mailing List For list archives:

Do InnoDB rollback segments expand dynamically?

Using InnoDB with an autoextend tablespace, if I start a transaction that results in many record versions, will the rollback segments grow dynamically and force the tablespace to grow dynamically to provide the required room for record versions in the rollback segments? Bill -- MySQL General

DECIMAL math?

Since DECIMAL fields are stored as strings how are calculations performed? Does MySQL use string math routines or does it convert the string to a double and use the double for the calculation? The real question is, can floating point imprecision errors occur when using the DECIMAL type? Bill