Hello Brent,
Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS
within my SELECT query (and I also didn't use SELECT COUNT(*) ... query).
But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of
all columns using SELECT FOUND_ROWS(), the performance was worse
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Juleni wrote:
Hello Brent,
Thanks for your answer, I have try to use clause SQL_CALC_FOUND_ROWS
within my SELECT query (and I also didn't use SELECT COUNT(*) ... query).
But when I used SQL_CALC_FOUND_ROWS and then I retrieved number of
Hello Mark,
Thanks for your short response. I have checked it again. I have
restarted MySQL first. When I executed command
select SQL_CALC_FOUND_ROWS
BF_USER.LOGIN_NAME,
BF_USER.EMAIL,
BF_USER.ID,
BF_USER.MODIFICATION_DATE,
BF_USER.SUPER_USER,
BF_USER.GUEST_ACCESS_ENABLED,
Well that´s me again with a new problem. I am runnig another database
with 7gb of data and this db can´t stop. All the time we have queries
being inserted by a plain text file and all the time customers get
information of this database. I obvserved that for a insert query is
taking about 5 to 15
Carlos,
Give us more details about our system:
What are the table types you´re using?
What are the configs in your my.cnf file?
Ronan
- Original Message -
From: Carlos Augusto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 3:41 PM
Subject: Mysql Performance
I do not believe that your problem is based on your hardware but ...
Inserting data requires to reorganize your indexes. Please try to drop
them (only for testing ;-) )
Hagen
Carlos Augusto wrote:
Well that´s me again with a new problem. I am runnig another database
with 7gb of data and this db
I could see how the Pentium 4 may be faster for certain things. In some
cases, older Pentiums with larger caches (i.e. 2MB) would outperform a
Pentium 4. Rumor has it that MySQL loves level 2 cache, but don't tell
PHP. But in this case, the Pentium 4 and Xeon I'm pretty sure both have
512K
Brent,
Would you be so kind to throw out some links to tweaking mysql to run
to its full performance. I am googling right now for the answeres. Is
there books you would recommend?
THANKS
On Tue, 2004-11-23 at 14:29 -0500, Brent Baisley wrote:
I could see how the
No books to recommend, although there was a review of one on
slashdot.org this morning, but you can start with the manual here:
http://dev.mysql.com/doc/mysql/en/Server_parameters.html
Other articles you may find helpful:
http://www.f3n.de/doku/mysql/manual_10.html
Vasiliy Boulytchev wrote:
Brent,
Would you be so kind to throw out some links to tweaking mysql to run
to its full performance. I am googling right now for the answeres. Is
there books you would recommend?
THANKS
High Performance Mysql (oreilly)
MySQL enterprise solutions
Hello,
I have a problem with poor performance when I execute select
from 50.000 records. I have a test that retrieve page by page
(20 records per page) all data from a table. It means I'm executing
2500 selects in the cycle for retrieving each page and I'm retrieving
also time duration of some
First you are using two distinct queries where you should be using two
related. Specifically, add SQL_CALC_FOUND_ROWS to your first query
that retrieves data, then issue a query to see how many rows you would
have had if you hadn't specified a LIMIT:
SELECT FOUND_ROWS()
The second query
We've got a really high-load MySQL server and are planning to get a new server.
Has anyone seen tests comparing performance of MySQL on AMD64 versus Xeon CPUs?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Miles Keaton wrote:
We've got a really high-load MySQL server and are planning to get a
new server.
Has anyone seen tests comparing performance of MySQL on AMD64
versus Xeon CPUs?
These tests are about a year old, but showed the Opteron was usually 50
to 100 percent faster in most often run
solution and
some mySQL optimizations Friendster is FAST.
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: Miles Keaton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 1:48 PM
To: [EMAIL PROTECTED]
Subject: tests comparing AMD64 to Xeon MySQL
Hello,
I need some help tuning mysql. I'm running 3.23.58-Max-log on a Red Hat
Linux Enterprise server with 1 gig of memory and 4 cpus. The database is
used by a web application which runs on a separate machine. The performance
is not so good. Can anybody tell me if my configurations are
Hello Chris,
I'm not familiar with super-smack, but it's compared to Apaches 'ab' which
IMO is great for getting quick performance numbers but should in no way be
trusted compared to a real world production environment. We run probably
about 50+ dedicated mysql servers on various FreeBSD 4.X
On Sat, May 22, 2004 at 11:25:54PM -0500, mos wrote:
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
35,000 queries per second.
First of
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped to
35,000
mos wrote:
At 04:42 PM 5/21/2004, you wrote:
Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their
patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
had just been released by the time I installed) this figure jumped
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for the
last few days to
Chris Elsworth wrote:
Forenote: I have no wish to start an OS debate.
Hello,
I'm in the fortunate position of having a dual 2.8GHz Xeon with 4G of
ram and 4 10k SCSI disks (configured in RAID-10) to deploy as a new
MySQL server.
Since I'm a numbers freak, I've been running super-smack on it for
On Fri, May 21, 2004 at 05:18:09PM -0600, Sasha Pachev wrote:
It looks like FreeBSD was using only one CPU from your numbers. Try the
test with only 1 thread and a lot of iterations to avoid the influence of
overhead. I know very little about FreeBSD, but one thing I would check is
if the
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send
to the my.cnf, and are you sure that MySQL is
using that my.cnf (ie is it in the correct location)?
- Original Message -
From: mysql [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:23 AM
Subject: MySQL Performance Tuning?
Hi Gurus,
I'm currently building an application
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something then updates
the 'log' entry.
To test MySQL in handling high load, I used siege
on another server to send 1000
: mysql [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:23 AM
Subject: MySQL Performance Tuning?
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does is essence is
to 'log' and incoming entry into MySQL, do something
Hi!
We are a hardware store(similiar to usa's home depot) here in venezuela.
We have 14 stores that moves a very heavy load of traffic.
Many of our retails runs in a home brew POS that uses mysql. Then sales
are uploaded to a bigger in-store server and then move to the central
office. The
.
Thanks!
- Original Message -
From: mysql [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 9:23 AM
Subject: MySQL Performance Tuning?
Hi Gurus,
I'm currently building an application which is expected
to take very high loads. What the app does
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:11 AM
Subject: Re: Mysql Performance Question
You need to figure out what's slowing down your application. It could be
expensive queries which in turn could be caused by missing indexes. It
could
be that the machine is too
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
Just out of wondering, are you using PHP and if so do you use
mysql_pconnect
rather then mysql_connect because that would really speed things up.
I tired pconnect before but it didn't help but using up all the available
memory.
() or whatever to check
the mtime.
Matt
- Original Message -
From: mos
Sent: Wednesday, October 22, 2003 1:44 PM
Subject: Re: Mysql Performance Question
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
Just out of wondering, are you using PHP and if so do you use
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are 450
concurrent uers hanging on the site. Mytop showed that the queries per second maxed at
500. I believe this could be higher, provided that I have it running on a
On Tuesday, October 21, 2003, at 12:48 PM, Rainer Sip wrote:
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when
there are 450 concurrent uers hanging on the site. Mytop showed that
the queries per second maxed at 500. I
On Wed, 22 Oct 2003 00:48:29 +0800, Rainer Sip [EMAIL PROTECTED] wrote:
In the mid run I'm planning to mirgrate to innodb for higher concurrency (I'm currently using myisam). However, I'm seeking suggestions in fine tuning the parameters.
I know you want to tune the parameters, but if you
:48 PM
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are
450 concurrent uers hanging on the site. Mytop showed that the queries per
second maxed at 500. I believe this could be higher
Rainer Sip wrote:
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are 450
concurrent uers hanging on the site. Mytop showed that the queries per second maxed
at 500. I believe this could be higher, provided
PROTECTED]
Sent: Tuesday, October 21, 2003 9:48 AM
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there
are 450 concurrent uers hanging on the site. Mytop showed that the
queries per second
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when
there
are 450 concurrent uers hanging on the site. Mytop showed that the
queries per second maxed at 500. I believe this could be higher
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:11 AM
Subject: Re: Mysql Performance Question
You need to figure out what's slowing down your application. It could be
expensive queries which in turn could be caused by missing indexes. It
could
be that the machine is too slow
Sorry for reposting , wrong subject in the prebious one
-- Forwarded message --
Date: Wed, 27 Aug 2003 11:17:36 -0400 (EDT)
From: Asif Iqbal [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: Replication with multiple servers in Mysql ?
Hi Jeremy Zawodny (and all)
I am using
Keith C. Ivey [EMAIL PROTECTED] wrote:
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
burst, with a wd 512MB HD and I want to store George Bush in our MySQL
database.
As far as table definitions are concerned, should I use a BLOB or
should I store him on disk and make
Hi,
Can anyone help?
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst,
with a wd 512MB HD and I want to store George Bush in our MySQL database.
As far as table definitions are concerned, should I use a BLOB or should I
store him on disk and make a reference to the
On 9 Jul 2003 at 23:14, Andrew Braithwaite wrote:
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
burst, with a wd 512MB HD and I want to store George Bush in our MySQL
database.
As far as table definitions are concerned, should I use a BLOB or
should I store him on
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQL on Windows platform or is there a reason why it might be slow
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Aman Raheja wrote:
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
These are very subjective questions and I know there is no hard answer,
I'm just seeking opinions from the community to get an idea to see if
these are worth testing.
1. Dedicated DB server vs clustered DB/WWW servers.
setup a:
2 servers running both WWW and DB. Each server queries it's local
Angel Flow wrote:
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
I would say that comparing DBI to ADODB is more appropriate; PHP more or
less directly calls the mysql C library
If this is going to hurt someone please when u
see mails from [EMAIL PROTECTED] do not
scroll down to the bottom
I won't. I've had enough of this, so I just set my mail program to erase any
mails from you. I do the same for anyone who repeatedly promotes religious
or political views on the
.
Sincerely,
Paul Magid, DBA
-Original Message-
From: Sameh Attia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:54 AM
To: [EMAIL PROTECTED]
Subject: [OT] Re: InnoDB vs. MySQL performance Issue
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed
PROTECTED]; [EMAIL PROTECTED]; 'Michael Widenius' [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 7:46 AM
Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue
To MySQL AB:
Your lists are being used to disseminate extremist muslim hate-speech.
As
such, this will reflect terribly negatively
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5
2003, 23 death and 100 injured by islamic terrorists, that's the islamic history
(small part).
Sam Apache-PHP-MySQL user.
--
Albert Einstein, Karl Marx, Jesus Christ,
and you Mohamed what have
I know this is a emotive subject but PLEASE drop it from the MySQL list.
Thanks
Simon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Sam,
I think now it is time to stop what you have started. If you can't answer the
question then don't waste the time of thousand of users on this list with your
personal opinions and comments on people signatures. You can communicate with
the user directly, not through the list. Other wise it
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
She who is in my mind and mouth, I love her with all my heart and blood
We'll restore OUR Palestine
Did you know a democratic country named ISRAEL created in 1948 ?
How do u define democratic? country? Israel? created?
Sameh Attia wrote:
Hi,
I have a system running MySQL 3.23.41. I read many times about
InnoDB performance and that it is superior to the MyISAM one. I have a
table 'sessions' in a MyISAM format with about 20 milion records. Its
size is 2.5 GB; the index file is 1.1 GB. In mysql client I
select crap from blahblah where nobody_is_interested = 'Y'
sql,query
- Original Message -
From: Sameh Attia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 7:32 PM
Subject: Re: InnoDB vs. MySQL performance Issue
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
She who is in my mind and mouth, I love her with all my heart and blood
We'll restore OUR Palestine
Did you know a democratic country named ISRAEL created in 1948 ?
How
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
She who is in my mind and mouth, I love her with all my heart and blood
We'll restore OUR Palestine
Did you know a democratic country named ISRAEL created in
: Monday, January 06, 2003 3:28 PM
Subject: Re: InnoDB vs. MySQL performance Issue
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
She who is in my mind and mouth, I love her with all my heart and
blood
We'll
[EMAIL PROTECTED]
Sent: Monday, January 06, 2003 3:28 PM
Subject: Re: InnoDB vs. MySQL performance Issue
Sameh Attia ([EMAIL PROTECTED]) écrivait:
Sam Przyswa wrote:
Sameh Attia ([EMAIL PROTECTED]) écrivait:
She who is in my mind and mouth, I love her with all my heart
Gelu Gogancea ([EMAIL PROTECTED]) écrivait:
Peace to all,
This is not the right place for this kind of discussions.
Please STOP.
Also i have a suggestion for the administrator of this list:
-to forbidden all e-mail which have in subject or body, logo
/slogan/catchword which can be considered
Hi,
I'm sure that all the people from this list RESPECT in what you believe or
in values which are considered by you to be inviolable/holy.
I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something
like ...
I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD, BEN GURION.
... i'm
Gelu Gogancea wrote:
Hi,
I'm sure that all the people from this list RESPECT in what you believe or
in values which are considered by you to be inviolable/holy.
I'M NOT JEWISH but i'm sure if you will see, like logo/slogan , something
like ...
I WILL LOVE YOU FOREVER WITH MY HEART AND MY BLOOD,
Sameh,
The right table manager to use (MyISAM or InnoDB) really depends on the
type of work you are requiring of MySQL.
If you are mainly doing selects, and hardly any updates/deletes/inserts,
then MyISAM is faster. Its indexes, as far as I know, are smaller and more
efficient. However,
Maximo Migliari wrote:
Sameh,
The right table manager to use (MyISAM or InnoDB) really depends on
the type of work you are requiring of MySQL.
If you are mainly doing selects, and hardly any
updates/deletes/inserts, then MyISAM is faster. Its indexes, as far
as I know, are smaller and more
Sameh,
your innodb_buffer_pool_size seems a bit small. In the manual it says:
Set buffer pool size to 50 - 80 % of your computer's memory, but make
sure on Linux x86 total memory usage is 2 GB. Your setting means that
you have no more than 256MB RAM and that's not much for operations on
really
Well, its possible that it took 10 hours to complete the conversion, if the
table was big enough, this could be justified.
20 million records is a lot of records!
Also, don't forget to change the memory settings for InnoDB in my.cnf.
InnoDB is a different table manager to MyISAM, and as such,
Maximo Migliari ([EMAIL PROTECTED]) écrivait:
Sameh,
We r here to help one another solving their problems. Ive never posted any
solutions, to this list or another based on religion or something else but
the problem itself only. I invite all people here to read the Islamic
history of true muslims
Hi,
I have a system running MySQL 3.23.41. I read many times about
InnoDB performance and that it is superior to the MyISAM one. I have a
table 'sessions' in a MyISAM format with about 20 milion records. Its
size is 2.5 GB; the index file is 1.1 GB. In mysql client I entered the
following
Hello,
I have noticed that my server running mysql-3.23.45 on Solaris 8/400MHz
sparc/1GB ram system appears to be only using up swap space and not free
memory. During light usage this doesn't seem to be a problem but under
heavy usage this causes my cpu to hit 90 - 100% at times. Even with
Hello.
I am setting up a quad xeon server that is dedicated for mysql. All
access will be via jdbc.
Are there any gotchas or performance bottlenecks in the configuration that
I can change to insure that the full capabilities of this hardware are
available for mysql?
Thanks!
Phillip
From: Angel Flow [EMAIL PROTECTED]
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL.
Since both of these use memory buffers for communication, I think performance for all
but the most trivial cases will be determined by the disk-speed-constrained
though
I don't know why for sure.
Cheers,
Wes
-Original Message-
From: Jan Steinman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Perl vs. PHP with MySQL - performance?
From: Angel Flow [EMAIL PROTECTED]
Would like to ask
Hi,
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
What's your experience? Does anyone know of any
benchmark data comparing mod_perl and mod_php working
with mySQL? Thank you very much.
Hello.
On Tue 2002-12-10 at 13:50:04 -0800, [EMAIL PROTECTED] wrote:
Would like to ask people's thoughts on whether Perl or
PHP has higher performance with MySQL. I've heard
rumours that DBI is slower than the PHP MySQL driver.
What's your experience?
The speed difference (if any) is so
Rummaging through some docs on performance and have come up with some
questions. Let me preface by saying, we don't have any performance
problems. I inherited this monster of a database and am running through
the configuration to make sure that it is indeed setup for optimum
performance.
For
Hi.
On Thu 2002-09-05 at 09:09:07 -0500, [EMAIL PROTECTED] wrote:
For clarity sake, assume the following:
Red Hat Linux 7.1
2.4.8 kernel
MySQL 3.23.42
MyISAM databases
3GB RAM
P3/700 x 4
15GB database spanned across ~200 tables
Key_reads / Key_read_request = 0.00059875
Key_write
Benjamin Pflugmann wrote:
OTOH, if this is a MySQL-only machine, 3GB are plenty and 100MB more
or less used do not really matter (regarding free memory), so I would
simply set it to use about 400MB are forget about it.
Remember to actually benchmark your differences too if possible (within
First of all, I forgive the rather lengthy post.
Thanks for the repl(y|ies) Benjamin. Decreasing the key_buffer should
be my first step. Back to the questions:
3) I'm somewhat at a loss for this one and perhaps the answer is more
obvious than not. I have 257 total tables from my main DB and
Hi again. :-)
On Thu 2002-09-05 at 14:18:10 -0500, [EMAIL PROTECTED] wrote:
[...]
3) I'm somewhat at a loss for this one and perhaps the answer is more
obvious than not. I have 257 total tables from my main DB and mysql. I
figured this by a ls -al var/ | grep -c MYD. How can I possibly
- Original Message -
From: Supriya Shiyekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 10:59 PM
Subject: MySql performance problem
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql
===
No System Faults found
==
Thanks for the help,
Supriya.
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Supriya Shiyekar [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 7:02 AM
Subject: Re: MySql performance problem
- Original
, August 28, 2002 7:02 AM
Subject: Re: MySql performance problem
- Original Message -
From: Supriya Shiyekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 10:59 PM
Subject: MySql performance problem
Hi,
We are having strange performance
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql database which resides locally on the
machine.
It takes 3 minutes to execute a piece of code(which involves select,
insert and update queries) on a Windows machine but an
filter: sql, mysql, query *bites filter :-]*
Hi gang.
I have the following problem facing me: Currently, we are utilizing
mysql to handle our business data needs. To this end, we have lots of
customers who access their data through a web-based interface. That
accounts for probably around
I am having performance problems with my MySQL installation - what would be an
appropriate channel for requesting help to such a problem?
I have posted to this list twice and another one as well. Volumes are very high on
using MySQL/standard SQL questions, but not an single suggestion has been
[snip]
I am having performance problems with my MySQL installation - what would be
an appropriate channel for requesting help to such a problem?
[/snip]
Repost your original concern and I will see if I can help.
Jay
-
Before
PROTECTED]
- Original Message -
From: webmaster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:13 PM
Subject: MySQL performance issues - PLEASE ADVICE!!
I am having performance problems with my MySQL installation - what would be
an appropriate channel for requesting help
Howdy all,
We have a curious situation here, and I was wondering if any of you have
encountered this before.
We have MySQL installed on a FreeBSD machine (733mHz, 256Mb RAM). Compiled
from source.
We installed MySQL on another FreeBSD machine (dual 866mHz, 512Mb RAM).
Compiled from source.
The
, so more memory won't help
much unless you use it in my.cnf and the kernel configuration allows
it!
Hope this helps,
Ken
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 2:04 PM
Subject: MySQL Performance on Dual Processor
Hi,
I don't have any experience with FreeBSD; however, I use MySQL on SMP
servers with Linux.
1. due to MySQL architecture (1 thread per connection) you should not
expect any performance
inprovement on a dual processor for a SINGLE SQL query compared to an
uniprocessor machine.
This is what
[snip]
I would suspect other things first such as the my.cnf configuration
(show variables) or has the kernel been optimised on the old box.
Did you check kernel configurations and disk subsystems? Also the
default process size on FreeBSD is 256Meg, so more memory won't help
much unless you
the indexes don't
copy.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 30, 2002 3:34 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL Performance on Dual Processor machine
[snip]
I would suspect other things first such as the my.cnf configuration
(show
PM
Subject: RE: MySQL Performance on Dual Processor machine
[snip]
I would suspect other things first such as the my.cnf configuration
(show variables) or has the kernel been optimised on the old box.
Did you check kernel configurations and disk subsystems? Also the
default process size
Blanchard [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 5:09 PM
Subject: Re: MySQL Performance on Dual Processor machine
Just becareful not to use too much memory unless you raise the DMAX
and such values (see /usr/src/sys/i386/conf/LINT ) if mysql runs out
of memory things
Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Ken Menzel wrote:
Date: Tue, 19 Feb 2002 15:14:39 -0500
From: Ken Menzel [EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql performance
Good Morning Alexander!
Looks like you have tuned your system pretty well.
They are slightly less than 25716, is there any way to check if this
upper
limit becoming reached sometimes?
sysctl kern.openfiles will tell you how many are open now but there is
no way to know if the upper limit is
Hi people,
May be anybody can advice from the personal experience tweeking which
options both in the mysql configuration and server hardware can help in
increasing mysql performance speed? As it is now, mysql is configured to
occupy about 600M RAM, and queries per second avg goes up to about 100
What disk drive have you got?
We have found that this can help.
Simon
-Original Message-
From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 13:14
To: [EMAIL PROTECTED]
Subject: Mysql performance question
Hi people,
May be anybody can advice from
101 - 200 of 254 matches
Mail list logo
