136 reputation
4
bio website synchromedia.co.uk
location France
age 45
visits member for 3 years, 2 months
seen May 19 at 6:44

Skier, Biker, PHP coder, Email wiz, Sysadmin


Mar
15
comment Install/bootstrap mysql without name-based users
hostname comes back with hostname.localdomain, but resolveip says "Unable to find hostid for 'hostname.localdomain': host not found". I guess it could do with a line in the hosts file to let that resolve, but I don't see why it's even looking up the name in the first place.
Mar
10
asked Install/bootstrap mysql without name-based users
Feb
21
awarded  Student
Feb
21
asked Upgrading from MySQL 5.5 to 5.6 - timestamp issue?
Jun
15
comment Update rows with a range of dates
There is an autoincrement column, but it doesn't increment by one because the database is part of a replicated cluster. Within a given set of records, IDs should be consistent and consecutive. It might be possible to do arithmetic using the IDs, but it will be a little fragile as offsets will vary according to which server runs it, though that value can be obtained dynamically.
Jun
13
comment Update rows with a range of dates
Yes I have the row count on hand. One optimisation for the naive case would be to group row updates that have the same timestamp - in the 10k/hour scenario that would reduce the query count by about 60%.
Jun
10
comment Update rows with a range of dates
Within a particular batch, the order doesn't matter, so long as they are evenly spread out over the desired duration - it's a kind of rate-limiter that has the ability to catch up should it fall behind. Any given batch may contain more or less than 3600 records and the rate may be variable between say 1000 and 2 million/hour.
Jun
10
asked Update rows with a range of dates
Sep
26
awarded  Teacher
Sep
26
awarded  Supporter
Sep
26
answered What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
Sep
20
awarded  Autobiographer