Re: reports

In infinite wisdom Gallego Juan wrote: > [1 ] > Hi, > > I want to ask you the next topic, > > I have to deliver some reports and i want to know if exists some reporting > open source tool to generate them. > > The reports that i need are: > - how many users, sessions,cursors by hour, day, w

test - please ignore

i said: ignore! -- hartmut -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

reports

Hi, I want to ask you the next topic, I have to deliver some reports and i want to know if exists some reporting open source tool to generate them. The reports that i need are: - how many users, sessions,cursors by hour, day, week How mysql manage them? is this information stored in some pla

Re: Foreign Key Problem

Victor Subervi wrote: On Tue, May 18, 2010 at 1:09 PM, Shawn Green > wrote: Johan De Meersman wrote: For additional details about failed FK attempts, check the error details in the SHOW INNODB STATUS report. I get this: 100518 10:26:22 Error i

Re: Foreign Key Problem

On Tue, May 18, 2010 at 1:09 PM, Shawn Green wrote: > Johan De Meersman wrote: > > For additional details about failed FK attempts, check the error details in > the SHOW INNODB STATUS report. > I get this: 100518 10:26:22 Error in foreign key constraint of table seaflight/Passengers: constrain

Re: Foreign Key Problem

Johan De Meersman wrote: On Tue, May 18, 2010 at 6:00 PM, Victor Subervi wrote: So apparently it didn't like my foreign key. Do I need to do something with the table I'm referencing or what? TIA. Well, quickfix is to convert your tables to innoDB, starting with the lowest-level (foreign-key

Re: Foreign Key Problem

On Tue, May 18, 2010 at 6:00 PM, Victor Subervi wrote: > > > So apparently it didn't like my foreign key. Do I need to do something with > the table I'm referencing or what? > TIA. > Well, quickfix is to convert your tables to innoDB, starting with the lowest-level (foreign-key only ones) first -

Re: Foreign Key Problem

On Tue, May 18, 2010 at 10:06 AM, Johan De Meersman wrote: > You're not specifying an engine, and the default is MyISAM, which doesn't > support foreign keys and will likely silently ignore requests for them. Can > you confirm that you've changed the default engine to InnoDB ? Got me. No, it was

Re: Foreign Key Problem

You're not specifying an engine, and the default is MyISAM, which doesn't support foreign keys and will likely silently ignore requests for them. Can you confirm that you've changed the default engine to InnoDB ? On Tue, May 18, 2010 at 3:44 PM, Victor Subervi wrote: > Hi; > mysql> create table i

Foreign Key Problem

Hi; mysql> create table if not exists Passengers (id int unsigned auto_increment primary key, foreign key (id) references Flights (flights_id), foreign key (id) references Customers (customer_id), name varchar(40), weight tinyint(3)); Query OK, 0 rows affected (0.00 sec) mysql> select c.first_name

Re: To get Processlist and Status of MySQL ?

If your mysql server is hung, crashed or otherwise unreacheable (as you first posted), you can't connect to it and request it's status and processlist - it's threaded and thus all inline. You could use GDB or something similar to go look in the execution stack, as Raj said, and if you have full qu

Re: To get Processlist and Status of MySQL ?

I found some tools to capture the MySQL processlist, log errors, etc. MySQLReport and mytopapps. My goal is to grab the logs of mysql including the processlist to help me assist in diagnosis of faults. What tool/apps do you