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,
-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 o
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 than
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 solution
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
http://www.onlamp.com/pub/a/onl
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 Pen
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 leve
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
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
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 s
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 sh
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 o
tests comparing AMD64 to Xeon MySQL performance?
>
> 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
>
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
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 PROTECTED
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 incorrect
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 rele
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.
>
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 to
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 que
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
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 the
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 s
currently
>
> > What tuning have you done to the my.cnf, and are you sure that MySQL is
> > using that my.cnf (ie is it in the correct location)?
> >
>
> Tunings that I have tweaked cuurently are
> 1. join_buffer_size 131072
>
>
>
> 2. key_buffer_size 16773120
>
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 prices,
.
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. Wh
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 HTTP
have you done 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 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 1
.21 37.29
> 10:30:00 HK all 35.91 0.00 16.64 47.45
> 10:40:00 HK all 46.26 0.00 22.03 31.72
> 10:50:00 HK all 43.28 0.00 19.37 37.35
> 11:00:00 HK all 35.22 0.00 16.42 48.36
> 11:10:00 HK
piler :-)) -- except stat() 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:
&g
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.
ECTED]>
To: "Rainer Sip" <[EMAIL 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 c
tive-timeout
Hope that helps.
Matt
> - Original Message -
> From: "Rainer Sip"
> 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 s
m
Hope that helps,
David
- Original Message -
From: "Rainer Sip" <[EMAIL PROTECTED]>
To: <[EMAIL 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
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, provide
"Rainer Sip" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 5: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 concurren
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 haven
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 belie
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 d
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
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 o
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 physi
-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
MySQ
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 o
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 fu
> 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 m
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "'Michael Widenius'" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 7:46 AM
Subject: RE: [OT] Re: InnoDB vs. MySQL performance Issue
ot go to you if you do
nothing.
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,
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 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
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
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 tr
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, has
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
reall
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,
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, when
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,
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 al
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 considere
lt;[EMAIL PROTECTED]>; "MySQL List"
<[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
ECTED]>; "MySQL List"
<[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:
&
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 i
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
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 Przy
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 ente
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?
B
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 co
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
n
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
o PHP 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 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
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
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.
Howdy -
I have a question concerning MySQL performance. From the list, it seems to
be the topic as of late!
Database Server: Dual Pentium III 1.2GHz COMPAQ server with 2GB of RAM
running Red Hat LInux, 7.2 (Enigma). MySQL version is 3.23.52-Max-log. All
tables are InnoDB.
Storage: All
Here you go -
http://www.mysql.com/information/benchmarks.html
---
I'm just now starting to play with MySQL. I had a client ask me how it
performance compared to Oracle, DB2, and MS SQL server. Does anyone know of
any benchmarks of other specs that can compare performance?
-
I'm just now starting to play with MySQL. I had a client ask me how it
performance compared to Oracle, DB2, and MS SQL server. Does anyone know of
any benchmarks of other specs that can compare performance?
-
Introducing NetZero Long Distance
1st month F
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
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
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 (with
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
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 cl
1 SBus 25 3 SUNW,fas/sd (block)
> >
> > 1 SBus 2513 SUNW,socal/sf (scsi-3)
> > 501-3060
> >
> >No failures found in System
> >===
> >
> >No System Faults found
> >==
> &
r 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
> - Or
- 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
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 ho
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 2-
[EMAIL 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 ap
[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
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 s
t;[EMAIL PROTECTED]>
To: "Jay 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
TED]>
Sent: Tuesday, April 30, 2002 3:34 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 configurati
times 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 configura
[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 use
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
, 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
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
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 i
101 - 200 of 264 matches
Mail list logo