Reset of Status Parameters

I am using MySQL version 5.0.22, I am interested in knowing the current performance on the MySQL. With the status command we can get the queries per second but it will average since the beginning of time when SQL was up and running and not the current rate? Is there any way to reset that

Re: Reset of Status Parameters

if using innodb do show innodb status\G. Here u will see real time insert,delete,update and selects. On 6/20/08, Venu Madhav Padakanti [EMAIL PROTECTED] wrote: I am using MySQL version 5.0.22, I am interested in knowing the current performance on the MySQL. With the status command we

Re: Reset of Status Parameters

I tend to use the 'mytop' program, which shows the average queries/second for the entire lifetime and for the last 5 seconds, as well as showing a bunch of other statistics and a list of running queries. It's a handy little monitoring tool. On Fri, 2008-06-20 at 12:17 +0530, Venu Madhav Padakanti

Re: Reset of Status Parameters

I would also add Baron's maakit http://www.maatkit.org/ ( innotop ) for innodb details to the arsenal. On Fri, Jun 20, 2008 at 3:11 PM, Ian Simpson [EMAIL PROTECTED] wrote: I tend to use the 'mytop' program, which shows the average queries/second for the entire lifetime and for the last 5

trigger that calls a webservice??

Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own catalog (zope/plone). so I would like to be able to push an update to the frontend. thanks robert

Re: trigger that calls a webservice??

On Fri, June 20, 2008 9:12 am, robert rottermann wrote: Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own catalog (zope/plone). so I would like to

Re: trigger that calls a webservice??

James wrote: On Fri, June 20, 2008 9:12 am, robert rottermann wrote: Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own catalog (zope/plone). so I

Re: trigger that calls a webservice??

On 20 Jun 2008, at 06:43, James wrote: On Fri, June 20, 2008 9:12 am, robert rottermann wrote: Hi there, is it possible to define an update trigger that calls a webservice (or just some external method that would do it). we have a web frontent, that does the indexing of data in its own

Very large temporary file(s)

I'm running MySQL 4.1.22-standard Community on CentOS. My problem is a query that is using about 800mb for what I assume is a temporary sort file, and I'm hoping that I can do something about it. The purpose of this query is to populate an unnormalized table with data from several other tables. I

RE: Very large temporary file(s)

Nuts: not only did I write a huge message, but I made a booboo up at the top! I won't repost the whole thing. I'm running MySQL 4.1.22-standard Community on CentOS. My problem is a query that is using about 800mb for what I assume is a temporary sort file, [JS] That should be 800Gb. -- MySQL

RE: Very large temporary file(s)

Double nuts! I corrected the wrong number. This time, I am reading my message more carefully. The temporary space used is indeed 800 MEGABYTES! I still need help, though. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 --

Re: Migration of mysql 3.23.32 from Tru64 to RHEL 5.1

Hi Tom, all, Swigg, Tom C wrote: I have been given the task of migrating some 200+ web sites fom Tru64 UNIX to Red Hat Enterprise Linux 64 bit V5.1 Many of these sites use PHP3 (3.0.18) and mysql 3.23.32 and the developers have long gone... The objective is to provide a 3.23.32 environment

MySQL using only 1 CPU

Hi, I've recently installed a MySQL 5.1.23-rc-log: | version | 5.1.23-rc-log   | | version_comment | MySQL Community Server (GPL)    | | version_compile_machine

ERROR_FOR_DIVISION_BY_ZERO question

Hello all, Currently, if I use sql_mode ERROR_FOR_DIVISION_BY_ZERO and have a select statement that has division by zero, I get back a warning: mysql set sql_mode=ERROR_FOR_DIVISION_BY_ZERO; Query OK, 0 rows affected (0.00 sec) mysql select 1/0; +--+ | 1/0 | +--+ | NULL | +--+ 1

InnoDB File Fragmentation

I have a question about how InnoDB deals with fragmentation within it's data files. Let me describe my usage scenario to you: 1.) Records are inserted into a InnoDB table. We'll call this table A. It contains several different kinds of columns including VARCHARs. 2.) Records are then processed

Error with max and group by

Hi, My sql is rusty but I'm trying to solve a problem and I'm getting a result that does not make sense. The table is mysql select * from cust_full; +---+-+--++ | name | item_id | location | acq_date | +---+-+--++ | Jim |

Re: Error with max and group by

On Fri, Jun 20, 2008 at 10:50 PM, Joe Pearl [EMAIL PROTECTED] wrote: I want to get back only the most recent entry for each person and I don't care about the order. I want the result to show Jim with the acq_date of 2008-01-03, Mary and Sally with the location and date for all of them.

improve performance of this sql

The below query performance in 10 sec when there are no other activity on db , but when any insert or LOAD DATA Index creation happens it takes close to 80 sec. Any ways to improve the performance of this sql. innodb_buffer=11GB , key_buffer=3 GB, we have totally 16GB EXPLAIN select * from