If you are using innodb. Then increase innodb_buffer_pool_size. If myisam
then increse key_buffer_size.
Please send status of mysql server and OS details
On Wed, Sep 24, 2008 at 12:39 PM, sangprabv <[EMAIL PROTECTED]> wrote:
> Hi,
> My MySQL server's data is increasing for about 1 million new rec
Hi,
My MySQL server's data is increasing for about 1 million new records per
day. And it's now become slower when processing data. Is there any way
to speed up? TIA.
Regards,
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Tobias Asplund wrote:
Can anyone tell me what's going on? Are there MySQL parameters that can
improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
What is preferred in this mailing list: the whole texts in the mail, or
as attachments?
(Hi all, I'm a friend of Dirk and helping him trying to speed up everything)
Fagyal Csongor wrote:
> Dirk Schippers wrote:
And this is the question that makes me totally confused:
How is it possible that the following query:
"SELECT COUNT(*) FROM messages WHERE touser = 20 AND hidden = 0" with
a k
> Can anyone tell me what's going on? Are there MySQL parameters that can
> improve things?
To know if you need to tune something, you can send us the copy of SHOW
STATUS; and SHOW VARIABLES;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Why not just add an index on touser+hidden. Problem solved.
Donny
> -Original Message-
> From: Dan Nelson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 14, 2004 11:48 AM
> To: Dirk Schippers
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL speed
>
> In
ongor" <[EMAIL PROTECTED]>
To: "Dirk Schippers" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: September 14, 2004 12:24 PM
Subject: [Bulk] Re: MySQL speed
> Dirk,
>
> > Hello,
> >
> > For several years I am hosting a popular website using PH
In the last episode (Sep 14), Dirk Schippers said:
> For several years I am hosting a popular website using PHP and MySQL.
> As the site is growing and evolving, speed is becoming more and more
> important. With my latest inventions on the website, I notice that
> the website is becoming slow and I
Dirk,
Hello,
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important.
With my latest inventions on the website, I notice that the website is
becoming slow and I want to find out what's causing this.
And
Hello,
For several years I am hosting a popular website using PHP and MySQL.
As the site is growing and evolving, speed is becoming more and more
important.
With my latest inventions on the website, I notice that the website is
becoming slow and I want to find out what's causing this.
And this i
Andre MATOS wrote:
Hi,
I faced a speed access problem today with the MySQL. In the morning was
working well and fast, but after lunch when I tried to access the MySQl
using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes
to process. I checked the log files from Apache and P
Hi,
I faced a speed access problem today with the MySQL. In the morning was
working well and fast, but after lunch when I tried to access the MySQl
using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes
to process. I checked the log files from Apache and PHP and I could not
hi!
i have 2 machines.
both of them running mysql daemon.
i want to check the speed difference, and i am looking for a method how can i do this ?
is there an official tool for this thing ?
Vaso
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
E COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
To: Gelu <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 2:04 PM
Subject: RE: mysql speed concer
PROTECTED]
- Original Message -
From: Michael Chang <[EMAIL PROTECTED]>
To: Gelu <[EMAIL PROTECTED]>
Cc: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>; Jason Yates
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 10:29 PM
Subject: Re: mysql sp
.sorry ... RFC 793
- Original Message -
From: Gelu <[EMAIL PROTECTED]>
To: Michael Chang <[EMAIL PROTECTED]>
Cc: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>; Jason Yates
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 10:52 AM
Sub
On Wed, May 01, 2002 at 10:49:36AM -0400, Jason Yates wrote:
> Currently our MySQL server runs around 20-30 queries per second.
> The upper management decided they wanted to add about 4 times the
> customers in the next two or three weeks. I'm worried that MySQL on
> this particular box won't be
Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
> To: Gelu <[EMAIL PROTECTED]>
> Cc: Jason Yates <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, May 01, 2002 7:32 PM
> Subject: RE: mysql speed concerns
>
>
> > With IPC I mean Inter Process Communi
t;; <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 7:32 PM
Subject: RE: mysql speed concerns
> With IPC I mean Inter Process Communication - any process that wants
> to talk with something else than with it self _needs_ necessarily IPC.
>
> Particularly an RDBMS needs IPC - othe
Hi,
We have faced this kind of problem for our main web site. When a single
server was not enough any
more (2 years ago), we have separated the database from Apache server.
Last year, we added 3 more Apache servers with load-balancing and
upgraded the database server
with a faster machine (2x1
limit number of
connections/jobs on the machine, and then assume the
worst case scenario from this.
> -Original Message-
> From: Gelu
> Sent: Wednesday, May 01, 2002 6:12 PM
> To: Svensson, B.A.T. (HKG); Shaun Bramley
> Cc: Jason Yates; [EMAIL PROTECTED]
> Subject: Re: mysql sp
Wednesday, May 01, 2002 6:20 PM
Subject: RE: mysql speed concerns
> An webserver uses mostly CPU resources while a DB uses I/O, or?
>
> Separation between the webserver and the RDBMS also suggest increased
> delays with IPC. I think one needs to find a balance somewhere in between
Wednesday, May 01, 2002 6:20 PM
Subject: RE: mysql speed concerns
> An webserver uses mostly CPU resources while a DB uses I/O, or?
>
> Separation between the webserver and the RDBMS also suggest increased
> delays with IPC. I think one needs to find a balance somewhere in between
er to see what happens with the system.
//Anders
> -Original Message-
> From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 01, 2002 5:13 PM
> To: Jason Yates; [EMAIL PROTECTED]
> Subject: Re: mysql speed concerns
>
>
> Hello,
>
&
[snip]
I'm worried that MySQL on this
particular box won't be able to handle the load of around 100-120
queries per second. Not to mention the CGI scripts are also getting run
on the same box with apache.
The system has 1gb of RAM, 1 Pentium III 700Mhz, and some ultrascsi HDs
(no raid), running
quot;Jason Yates" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 10:49 AM
Subject: mysql speed concerns
> Currently our MySQL server runs around 20-30 queries per second. The
> upper management decided they wanted to add about 4 times the customers
Currently our MySQL server runs around 20-30 queries per second. The
upper management decided they wanted to add about 4 times the customers
in the next two or three weeks. I'm worried that MySQL on this
particular box won't be able to handle the load of around 100-120
queries per second. Not t
At 13:35 Uhr -0400 6.4.2001, Vivek Khera wrote:
>
> ... LIMIT '3',2
>
>and resulting in a parse error. The fix was to call
>$sth->execute($start+0,$howmany+0) and then DBI did the right thing.
A similar problem may occur if you use a text variable in a ==
comparison before passing it to execut
> "PD" == Paul DuBois <[EMAIL PROTECTED]> writes:
PD> But why does it matter? MySQL will convert the strings to numbers
PD> anyway.
But according to earlier threads here, it will mess up with BIGINTs
Also it may screw up with LIMIT:
$sth = $dbh->prepare("SELECT foo FROM bar LIMIT ?,?") or
PROTECTED],
> [EMAIL PROTECTED]
> Subject: Re: Mysql speed :)
>
> On Fri, Apr 06, 2001 at 08:41:32AM -0700, William R. Mussatto wrote:
> > How do you get it not to try an quote numbers? I realize this should be
> > obvious, but I can't find an exampl in the msql/m
f any do.
Tim.
> --Greg Johnson
>
> -Original Message-
> From: Martin Hubert [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 9:52 AM
> To: Tim Bunce; Heikki Tuuri
> Cc: [EMAIL PROTECTED]; FileCopy
> To: Heikki Tuuri <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
> > Subject: Re: Mysql speed :)
> >
> > On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
> > >
> > > for ($j = 0; $j < 10; $j = $j + 1) {
> >
y does it matter? MySQL will convert the strings to numbers
anyway.
>
> On Fri, 6 Apr 2001, Tim Bunce wrote:
>
> > Date: Fri, 6 Apr 2001 11:00:57 +0100
> > From: Tim Bunce <[EMAIL PROTECTED]>
> > To: Heikki Tuuri <[EMAIL PROTECTED]>
> > Cc: [EMA
[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: Mysql speed :)
>
> On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
> >
> > for ($j = 0; $j < 10; $j = $j + 1) {
> >
> >$dbh->do("insert into s
M
> To: Heikki Tuuri
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Mysql speed :)
>
>
> On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
> >
> > for ($j = 0; $j < 10; $j = $j + 1) {
> >
> >$dbh->do("insert i
-
From: Martin Hubert [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 9:52 AM
To: Tim Bunce; Heikki Tuuri
Cc: [EMAIL PROTECTED]; FileCopyMartin
Subject:RE: Mysql speed :)
But does that really
]; [EMAIL PROTECTED]
Subject: Re: Mysql speed :)
On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
>
> for ($j = 0; $j < 10; $j = $j + 1) {
>
>$dbh->do("insert into speed1 values ($j, $j, $j)");
> }
That would run faster if you do a prepare wit
Richard Ellerbrock writes:
> Are the Mysql supplied statically linked binaries built using these optimised glibc
>2.2 libraries, or are they just the stock standard 2.1.3 libraries?
>
> --
> Richard Ellerbrock
> [EMAIL PROTECTED]
Hi!
Our binaries are based on our patched glibc and not
Heikki Tuuri writes:
> Hi!
>
> I tried a test similar to Peter. There is a table with 3 integer
> columns. There is a primary key on the first column and a non-unique
> key on the second column. I wrote a Perl program which inserts rows
> one at a time, and also selects rows one at a time.
On Thu, Apr 05, 2001 at 07:50:24PM +0300, Heikki Tuuri wrote:
>
> for ($j = 0; $j < 10; $j = $j + 1) {
>
>$dbh->do("insert into speed1 values ($j, $j, $j)");
> }
That would run faster if you do a prepare with placeholders outside
the loop and then just use $sth->execute($j, $j, $j)
Hi!
I tried a test similar to Peter. There is a table with 3 integer
columns. There is a primary key on the first column and a non-unique
key on the second column. I wrote a Perl program which inserts rows
one at a time, and also selects rows one at a time.
I ran the tests on a Linux 2-CPU Xeon
Are the Mysql supplied statically linked binaries built using these optimised glibc
2.2 libraries, or are they just the stock standard 2.1.3 libraries?
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Sinisa Milivojevic <[EMAIL PROTECTED]> 2001/04/05 05:06:45 >>>
Peter Zaitsev writes:
> Hello mysql
Peter Zaitsev writes:
> Hello mysql,
>
> I've resenty tried to becnhmark mysql in really simple case.
> I need to select indexes really fast so I did "select * from pages
> where hash=11" there was a key on hash and the query returned only
> one row. The query was constant and serv
Hello mysql,
I've resenty tried to becnhmark mysql in really simple case.
I need to select indexes really fast so I did "select * from pages
where hash=11" there was a key on hash and the query returned only
one row. The query was constant and server ad no other load.
I've run this on
44 matches
Mail list logo
