, until I reach 100 threads, which is the maximum number
of connections allowed by my server.
This is quite unexpected, since the server has only two processors. I
expect the throughput to grow from one connection to two connections.
But I don't expect it to grow with more than two connections
unexpected, since the server has only two processors. I
expect the throughput to grow from one connection to two connections.
But I don't expect it to grow with more than two connections. Why is
it the case?
My Server has one Intel Xeon X3360 CPU with two cores running at
2.83GHz and 8GB of main memory
A few weeks back I was reading an article that said that INNODB doesn't take
adantage of servers using more than 4 processors. I think I also recieved this
as a reply some time ago as to the same thing.
I was wondering if this is indeed true. We are using 5.1.30 and wanted to
pickup a new
Gary,
I need to know a lot about your workload to say whether it will work
well on InnoDB with 4+ processors. You can check
http://www.mysqlperformanceblog.com/ for a lot of benchmarks in this
area. But in general, my opinion is that for most workloads, 4 total
processors (cores included
Hello,
I'm looking to replace and aging an aging database
server and was wondering if anyone has any advice
about AMD Opteron dual/quad core processors and MySQL
on a 64 bit box. We're currently running MySQL 5.0.15
and we'd like to stay with that release. Are there any
problems with running
On Monday 31 July 2006 03:18 pm, Tripp Bishop wrote:
Hello,
I'm looking to replace and aging an aging database
server and was wondering if anyone has any advice
about AMD Opteron dual/quad core processors and MySQL
on a 64 bit box. We're currently running MySQL 5.0.15
and we'd like to stay
$$$ are left on CPU(s).
Tripp Bishop wrote:
Hello,
I'm looking to replace and aging an aging database
server and was wondering if anyone has any advice
about AMD Opteron dual/quad core processors and MySQL
on a 64 bit box. We're currently running MySQL 5.0.15
and we'd like to stay with that release
with
multiple cores is still a single processor.)
How to two data nodes on a single computer having two processors?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
Are there any known issues using MySQL on Localhost with WinXP Pro and a
dual processor machine? The reason I ask is that I have a friend that is
trying to run MySQL with this configuration and he seems to have a lot
of problems keeping a connection to the database. Has anyone else seen
Hello all...
I´m compiling the mysql 3.23.53 in DUAL PROCESSOR MACHINE...
in mysql exists an option to optimize on DUAL PROCESSOR MACHINE ?
my system is mysql 3.23.53 in linux 2.4.18 ( with 1G RAM )
sql,query
-
++
MySQL is multithreaded, so your OS will send separate threads to different
processors. So, yes, MySQL will automatically take advantage of multiple
processors, no need to tell it explicitly.
j- k-
On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote:
Hello all...
I´m
]]
Sent: Monday, July 15, 2002 1:41 PM
To: [EMAIL PROTECTED]
Subject: processors
we are considering moving to a 4-way system as the load average on our
2-way system is at 2.
Does anyone have recommendations? Is the larger 1MB cache on some xeon
chips worth the extra $$$?
I'm thinking of 2
we are considering moving to a 4-way system as the load average on our
2-way system is at 2.
Does anyone have recommendations? Is the larger 1MB cache on some xeon
chips worth the extra $$$?
I'm thinking of 2 raid1 arrays, one for the os and logs, the other for
the db. The data is relatively
Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 5:24 PM
To: Dreamtime.net Inc.
Cc: Mysql@Lists. Mysql. Com
Subject: Re: Mysql Problems - Peak loads - Two processors
On Sun, Mar 03, 2002 at 01:25:46PM -0800, Dreamtime.net Inc. wrote:
Hi,
We have mysql 3.23.43 running under
On Mon, Mar 04, 2002 at 08:33:27AM -0800, Dreamtime.net Inc. wrote:
We have FreeBSD 4.2-RELEASE and I can't say for sure how much time
it might take to upgrade to 4.3 or higher. It might take anywhere
from one reboot to several hours (if something won't work).
Well, if it stops the problem,
On Sun, Mar 03, 2002 at 01:25:46PM -0800, Dreamtime.net Inc. wrote:
Hi,
We have mysql 3.23.43 running under FreeBSD 4.2, two-processors and
a Tyan LE S2510 motherboard with 1 gig of ram. After a few peak
loads of the server (load avg. gets higher than 20), mysql starts
eating processor
Interesting question. This really depends on multiple things (operating
system, table locking, etc.)
LinuxThreads are implemented more like multiple processes sharing memory, so
you will see a benefit from having multiple processors as these threads
(processes) are scheduled across both
On Thu, May 03, 2001 at 12:12:35PM -0700, Bryan Coon wrote:
Would someone briefly explain to me how MySQL uses threading in a
multi-processor environment?
Yes.
Currently I have a Dual 1gHz processor box running RedHat 7.1 with
the smp kernel. Does this automatically take care of things?
Will mysql operate on a dual processor system under linux? Any
appreciable performance advantages?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
19 matches
Mail list logo