Re: Tracking changes in large datasets over time

On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: > I'm having trouble working through a data problem. Any tips or > keywords that might clue me into a known pattern would be incredibly > appreciated! > > I have about 500,000 users in my system. Each user has a points > ba

Re: Tracking changes in large datasets over time

Hi Rob --- MySQL 5. On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: >> I'm having trouble working through a data problem. Any tips or >> keywords that might clue me into a known pattern would be

Re: Tracking changes in large datasets over time

On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: > I'm having trouble working through a data problem. Any tips or > keywords that might clue me into a known pattern would be incredibly > appreciated! > > I have about 500,000 users in my system. Each user has a points > ba

Tracking changes in large datasets over time

I'm having trouble working through a data problem. Any tips or keywords that might clue me into a known pattern would be incredibly appreciated! I have about 500,000 users in my system. Each user has a points balance, updated by a system over which I have no control. I'd like to track changes t

Re: Help requested to provide bug reports for 5.1

Hi! > "Mark" == Mark Callaghan <[EMAIL PROTECTED]> writes: Mark> Can MySQL share the results of performance testing that has been done to Mark> compare 5.1 with 5.0? I would really like to see them too :) I will ask around and see if I can find what was done and what the results where. Re

RE: Multi-table deletes

I changed my tables to use foreign key constraints with on delete cascade and that did what I needed. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: David Ruggles [mailto:[EMAIL PROTECTED]

Multi-table deletes

My SQL: delete c, gt, g, sp from Companies as c, GroupTypes as gt, Groups as g, ServicePersons as sp where gt.companyuid = c.uid and g.companyuid = c.uid and sp.companyuid = c.uid and c.id = '01' This works fine as long as there are records in all t

Master-to-Master replication on same server

I recently installed 2 instances of mysql on the same server, using port 3307 for the second server, the normal 3306 for the first server. I found that while logged onto that box I could communicate to the 3307 instances using the socket parameter. Using the port parameter (--port=3307) by itself

Re: Configuration and improvement advice.

[EMAIL PROTECTED] (Josh Miller) writes: > I have recently become responsible for a LAMP site which has a decent > MySQL install (v5.0.24a). The database is around 40GB with a single > master to single slave replication scheme, although all activity goes > to the master at this time, with the exce

Configuration and improvement advice.

I have recently become responsible for a LAMP site which has a decent MySQL install (v5.0.24a). The database is around 40GB with a single master to single slave replication scheme, although all activity goes to the master at this time, with the exception of backups which are taken from the sla

RE: counting by countrycode

How are you storing phone numbers? I don't think there are leading zeroes in country codes, and country codes are not all the same length. Are you padding them with leading zeroes to five characters? If you have padded them so that the first five characters are always the country code, then you ca

Re: multiple mysql servers

Resolved.

Re: Accessing remote machine (Ubuntu) from Window

Do you have skip networkin in my.cnf ? No, no skip-networking is in the my.cnf file. Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: UPDATE rows based on multiple WHERE values?

Thanks, I'll take a look at that. Appreciate the help, Waynn On Sat, Jul 12, 2008 at 9:02 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Sat, Jul 12, 2008 at 8:01 PM, Waynn Lue <[EMAIL PROTECTED]> wrote: > > Is there any way to have an UPDATE statement change a column value based > on > > the WH

Error number 5 means 'Input/output error'.

Hi when i start mysql db server on a particular host. 080718 3:29:09 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this

Re: counting by countrycode

Hi Ron ! Ron wrote: - | customercode | customer name | customerphonenumber | callednumber | calldate | callstart | callend | callduration | callcost | -