Re: InnoDB monitor

2002-03-25 Thread Heikki Tuuri 

Hi!

Please look in section 9.1 of http://www.innodb.com/ibman.html

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB


-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Sunday, March 24, 2002 10:50 PM
Subject: InnoDB monitor


Hi,
Can anyone tell me how to use the InnoDB monitor please.  After creating
the
table with the following command: CREATE TABLE innodb_monitor(a int) type
=
innodb; I don't know where to watch the output from the InnoDB monitor.
Can anyone help?
Balteo. (sql,query)



-
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




-
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

RE: innodb monitor

2002-03-12 Thread Felix Richter 

Hi,
you can see the monitor's output in the logfile. In my case (mandrake linux), it is in 
/var/lib/mysql and I do:

tail -f /var/lib/mysql/SERVERNAME.err

 Also, where do I designate autocommit = 0; 

Use SET AUTOCOMMIT = 0 as a SQL query. Just issue it where you do your SELECT, 
UPDATE etc. queries, and don't forget to SET AUTOCOMMIT = 1 afterwards.

-
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