Do you have any log messages associated with it?
(not sure for win / os x for linux look in /var/lib/mysql/.err)
Hi.
For clarity, I'm running mysql 4.0.20
And I did start the mysql daemon.
Luke Vanderfluit wrote:
Hi.
I have a database that is used with wordpress blogging software.
Yesterda
Hi
I have a number of clients connecting to a DB in order to take jobs off a
queue, mark them active, then run them. In pseudo code, each client executes
the following sequence of queries:
a-- select test_id from tests where status=1 and priority < 11 order by
priority
b-- update tests set st
one know if its possible to reconfigure the master to
observe the old replication setup? Or do I need to look at upgrading
the slave to version 4 (which leads to the next question: does anyone
fancy my chances of getting mysql 4 built and running under redhat 7.1
:) ??)
Cheers
Tim
--
Tim Wood
P
, othervalue
1,4
3,4
I basically want to know if there's a query that return's 2 and 4 as
key_id's in A but missing from B?
Any sql gurus out there?
Cheers
Tim
--
Tim Wood
Predictive Technologies
ph +61 3 8344 0395 (BH) +61 413 845 317
Everyone talks about apathy, but no one does
Hi Peter
We use the mysql replication stuff here. Its very reliable, and the
synchronization between master & slave is pretty much instant.
There does seem to be one problem when the master rotates its transaction
logs, the slave does not pick it up and you need to manually issue "reset
slave"
> In the last episode (Dec 13), Tim Wood said:
> > Does anyone out there know of any
> > - future plans by the mysql development crew to increase table size
> > limits by eg using their own custom filesystem type?
>
> You mean the MyISAM RAID table extension, or the
he 4G limit imposed
by the linux kernel
- any alternative filesystems (JFS?) that might permit greater table
sizes under mysql
- any other tested and functioning workarounds to this issue?
Any suggestions will be appreciated
Cheers
Tim
--
Tim Wood
Predictive Technologies
ph +61 3 8344 0395 (BH) +61
