Re: Mysql on Ultrasparc T2 and floating point performance

On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson wrote: > In the last episode (Apr 22), Rod Heyd said: > > I've been running mysql on a T1000 (Ultrasparc T1) system for several > > years now, and while I've been happy with the performance overall, the > > poor flo

Mysql on Ultrasparc T2 and floating point performance

Hi, I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing the

Poor performance with WHERE Value like 'XXX%'

amine practically the entire table. Adding a force index(PRODUCT_ID) seems to help a little bit, but still not like it should. Any ideas what could be happening? I'm seeing the same behavior on both mysql 5.0.37 and an older system running mysql 4.0. Thanks. Rod Heyd

replicated queries are not placed in the binary log of dual master replication set up

Hi, I'm building a dual master set up that looks something like this: master A <-> master B || slave A slave B Replication between the masters works. Replication between the slaves and their respective masters works (ie, inserts on master A are repl

Re: Trouble with read-only

On 6/14/06, ravilr <[EMAIL PROTECTED]> wrote: Are you inserting rows as a root user? The root user will be able to write to tables even if read-only is set to 'ON'. Ah, yes. That was it. I forgot about that. Thanks. -Rod

Trouble with read-only

Hello, I'm trying to set up a replication slave as read-only, but the read-only part doesn't seem to be working. Replication between the master and the slave works fine. I have added the read-only keyword to the slave's my.cnf, and looking at the output of show variables indicates that read-onl

Hardware experiences

Hi, I'm just looking for any experiences that people might want to offer on this subject. My project is in the process of selecting hardware to build out our system, and we are considering getting a few of the new Sun Fire T1000's to run mysql on. We are expecting that the project will have a st

Re: Normalization question

Thanks for you responses! This list has proven to be for useful to pick pick the brains of other DBA's. I think we are probably going to go the route of splitting the different pieces of data into seperate columns, while keeping the original product_id, since we have a lot of third party applicat

Normalization question

Hi Everyone, I've got a little debate that maybe you can all help me settle. I have three tables that I need to join, but there are performance problems with the joins due to some misunderstandings of my predecessor about what's needed to join the tables efficiently. Here's the setup. t1 has a

Re: Improving the performance of joins

On 5/17/05, Jigal van Hemert <[EMAIL PROTECTED]> wrote: > From: "Rod Heyd" > > Tables Version_(1-5) > > > > -- > > > ID |PRO

Improving the performance of joins

I have a question about joins. My situation is as follows: I have 5 tables identical in structure. Each table represents essentially the same data, however, the data in each table represents a different "version." The processing involved in generating the values stored in each table may have ch