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
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
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
[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 PHP and MySQL.
As the site is growing and evolving, speed is becoming more
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 the last episode (Sep 14), Dirk
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:
(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 key
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
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
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
.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
Subject: Re: mysql speed concerns
TCP/IP
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 speed concerns
Technically speaking
]
[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 concerns
As well as semaphores, shared memory and messages queues
Hello,
The first thing that I would do would be to separate the DB and apache. Set
the DB up so that it is on a box of it's own. The system cannot serve pages
if it is crunching through the db tables looking for information (and vice
versa).
Shaun
- Original Message -
From: Jason
[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),
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,
The first thing that I would do would
the load in steps in
order to see what happens with the system.
file://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,
The first thing
the load in steps in
order to see what happens with the system.
file://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,
The first thing
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 speed concerns
Hi,
MySQL
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
: [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: 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
PROTECTED]
Subject: Re: mysql speed concerns
Hi,
MySQL don't seems to use IPC.!?...Strange ..!?...And if Shaun will need
real-time response from RDBMS,in my opinion, is strongly recomended to
set
up MySQL on the other host.
Regards,
Gelu
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 execute. If
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) inside.
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.
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 on
]; [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 with placeholders outsid
]; [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 with placeholde
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 speed1 values ($j, $j, $j)");
}
That would run faster if you do a prepare with pl
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 with placeholde
Message-
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
On Fri, 6 Apr 2001, Tim Bunce wrote:
Date: Fri, 6 Apr 2001 17:25:27 +0100
From: Tim Bunce [EMAIL PROTECTED]
To: "William R. Mussatto" [EMAIL PROTECTED]
Cc: Tim Bunce [EMAIL PROTECTED],
Heikki Tuuri [EMAIL PROTECTED], [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: M
-
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
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 server ad
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,
35 matches
Mail list logo