I use the 4400+. The 1meg cache makes a difference.
Larry
- Original Message -
From: mos [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, September 01, 2006 11:29 AM
Subject: Which AMD Dual Core Processor?
I'm thinking of upgrading my AMD3500 to a dual core AMD
is so much
better with the Athlon 64 boxes. At this time we are getting
enough performance per dollar that we are not going to go to
the Opterons, although I would like to try a few. ;-))
Larry Lowry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
My $.02.As I agree SCSI has had a reputation for being
a more solid enterprise type drive, everyone's mileage varies.
We have moved to using all SATA drives in our newer
servers. I have to admit most of our databases are smaller
than what many on this list have. All our db's are under
500
We have been using the controllers built into the
motherboards. I know they are not as good as some
dedicated cards but they work well enough for us.
I prefer the nVidia nForce4 Ultra Chipsets. They
have a nice raid setup. We needed a cheap box for
data server but with a lot of tempory disk
Ok I changed my connection string to use the IP of the mySql box
and added my workstation to the hosts file on the server. Same
problem. The tests ran at the same slow pace.
I am really curious, what was the logic of adding the workstation
ip to the hosts file on the server?
Larry Lowry
field adding only abour .5 seconds to the whole
loop time. Half a second to dig into a database with 400k
records and yank the record 100 times but 22seconds just to
open and close the conection. Something just does not
seem right.
Thanks for your input.
Larry Lowry
- Original Message
? Any help would be appreciated.
Thanks
Larry Lowry
'MySql Code
Dim sDBCS As String = Server=DB;UserId=userid;Password=pass;Database=images
Dim i As Long
Dim ti As Long = Microsoft.VisualBasic.Timer()
Dim db As MySqlConnection
db = New MySqlConnection(sDBCS)
For i = 1 To 100
query_cache_size = 32M
query_cache_type = 1
read_buffer_size=2M
read_rnd_buffer_size=8M
skip-innodb
- Original Message -
From: Peter J Milanese [EMAIL PROTECTED]
To: Larry Lowry [EMAIL PROTECTED]; mysql mysql@lists.mysql.com
Sent: Friday, January 21, 2005 12:57 PM
Subject: Re: Connection
For cost reasons I use SATA. Does the machine already
have a SCSI card in it? If so I would use SCSI. If not
I would give one of the newer 10k SATA drives a spin.
Larry
- Original Message -
From: Fagyal Csongor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 12, 2004
Sorry to hear that. Although I have been feeling that way
lately about all WD drives. Seems like I have had to replace
a lot of them lately. Even non SATA.
Larry
- Original Message -
From: Gary Richardson [EMAIL PROTECTED]
To: Larry Lowry [EMAIL PROTECTED]
Cc: Fagyal Csongor [EMAIL
I have to agree with Chis on the single cpu box. We have been building
our own boxes using AMD Athlon 64 3400+. Make sure you get the chip
with 1mb cache. The hyperchannel on these make IO so much faster. A
couple of fast SATA drives in a raid config and you are ready to go. There
is a new
So far the one I have had the best luck with is
ByteFX.Data.MySqlClient
I use it in both VB.Net and C# against MySql 4.1.2 on
Windows and Linux.
It's here: http://www.bytefx.com
Larry Lowry
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 01
Put of all three lines of your sql in one string variable
with the semi-colons and execute it as one command.
Works for me using the ByteFX libraries.
Larry
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Mirco Santori ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
that it is not installed.
I seem to always have this problem with rpm packages.
What is the best way to get this installed?
TIA
Larry Lowry
Well that worked quite well, but not until I rebooted
the machine. Something was stuck but I sure do not
know what.
Thanks again.
Larry
- Original Message -
From: Brad Tilley [EMAIL PROTECTED]
To: Larry Lowry [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 8:01
Well I'm trying to move to MySQL from the MS SQL Server
world. Most data elements are easy except for the uniqueidentifier.
In the MySQL world what is the preferred/best way to store a
uniqueidentifier? The easiest would just be a char(36).
Thanks.
Larry Lowry
would that be?
How would one convert to binary char(16)? In what documentation
would I find this? I do not know enough yet to write a UDF.
Larry Lowry
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Larry Lowry [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday
17 matches
Mail list logo