Hi Aveek,
I think Ghulam just want to count calls for each intervals
so the query should looks like this:
select count(*) as total_calls, queue_seconds
from calls group by queue_seconds order by total_calls;
- Original Message -
From: "Aveek Misra"
To: "Ghulam Mustafa" , mysql@lists.my
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
> Date: Fri, 30 Jul 2010 12:19:07 +0100
> Subject: script of mysql
> From: pratikshadjayswa...@gmail.com
> To: mysql@lists.mysql.com
>
>
Nunzio Daveri,
Joerg Bruehe gave you a lot of good tips to try and speed things up.
A few hundred queries per second seem to be a relatively small number to
cause the server to crawl. I don't have the rest of your thread, but can
you publish some of the slow queries (see Slow Query Log) an
Thanks again :-)
Nunzio
From: Joerg Bruehe
To: Nunzio Daveri ; mysQL General List
Sent: Fri, July 30, 2010 1:31:54 PM
Subject: Re: Indexes larger than RAM (was: Do you know who can answer this
question I posted yesterday please?)
Hi!
I am no InnoDB and t
Hi!
I am no InnoDB and tuning expert, so I had intended to stay away from
this question. Ok, I'll give some general remarks:
Nunzio Daveri schrieb:
> [[...]]
>
> All, I was running slamdb against one of our QA boxes and noticed that the
> innodb database is 190Gb in size BUT the worrying issu
Awesome, thanks for helping that's just what I needed :-)
Nunzio
From: Joerg Bruehe
To: Nunzio Daveri
Cc: MySQL General List
Sent: Fri, July 30, 2010 10:49:14 AM
Subject: Re: CentOS 4.8 no-install of MySQL 5.1.4X???
Hi Nunzio, all (cc' to the list)!
Nunzi
Simple - brilliant. I've modified to cat a temporary script...
1) cat the file as suggested:
cat > ~/payload/scripts/create_mysqldb.sql << EOF
###---
### Display the current user
###---
create database puppet;
###---
### Display all default accounts
###---
USE puppet;
###---
### Remove anonym
Hi Nunzio, all (cc' to the list)!
Nunzio Daveri schrieb:
> Hello Joerg, thanks for replying. I am at:
>
> http://mysql.llarian.net/Downloads/MySQL-5.1/
I cannot comment on that server, do neither know it nor the origin of
the packages they provide (own builds or mirrored ones from the MySQL
Bu
Nunzio, all,
Nunzio Daveri schrieb:
> Thanks Claudio but I do that all the time. The question is where is the
> file?
> You said to go to the download area, there are hundreads of files and not one
> tar file says rhel or cent os.
"tar.gz" packages are not specific to the Linux distribution,
Thanks Claudio but I do that all the time. The question is where is the file?
You said to go to the download area, there are hundreads of files and not one
tar file says rhel or cent os.
What is the URL / file name to download and untar please?
Thanks for responding :-)
Nunzio
PRATIKSHA JAISWAL schrieb:
> Hi List,
>
> Can somebody please help me if they have a script using which we can get an
> idea for installed mysql server, backup, created databases, indexes, tables,
> engines, replication etc...
>
> I will appreciate your help in advance
>
>
You can find t
Hi List,
Can somebody please help me if they have a script using which we can get an
idea for installed mysql server, backup, created databases, indexes, tables,
engines, replication etc...
I will appreciate your help in advance
Thanks
Pratiksha
12 matches
Mail list logo
