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 (sel

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.

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 |

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 processe

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

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

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 o

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 -- MySQ

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. -- MyS

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: 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 c

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 wou

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 lik

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: 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

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

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 comman