say at this point? It probably has a lot
more detail on exactly what caused it to end. This log is probably in
/var/lib/mysql/hostname.err (this is the default behavior). Possible
problems are there is no mysql user, or the data directory or the mysql
table isn't owned by the my
s much data in RAM as possible.
This is a good thing. A well-tuned loaded Linux system will frequently
have only 10% of memory free at any given time.
james montebello
On Fri, 1 Mar 2002, Joe Bifano wrote:
> Hi all,
>
> I have a seperate linux server with just mysql running on it. But ther
'show slave status',
which makes it much harder to monitor the slave's health.
james montebello
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
e box, since MySQL doesn't support file locking on Linux.
The servers have to be completely independent from one another.
james montebello
On Fri, 22 Feb 2002 [EMAIL PROTECTED] wrote:
> query
> Is it possible to set one SLAVE to handle two or multiple MASTERS???
> For example if I wa
x weeks of effort.
james montebello
On Thu, 7 Feb 2002, Brian Bray wrote:
>
> It seems to me like the best solution that could be implemented as-is
> would be to keep a random int column in your table (with a range of say
> 1-100) and then have fulltext server 1 psudo-replicate
.
james montebello
On 7 Feb 2002, Amir Aliabadi wrote:
> How do you make something like this fault tolerant?
> The answer is probably what I suspect, 2 of every thing.
> How does the aggregator handle this or are these machines in a cluster?
>
> We are thinking of how to rebuild our
change master to
master_mysql> unlock tables;
This is also a good way to re-sync a slave if it crashes and corrupts
its tables.
james montebello
On Thu, 7 Feb 2002, Mark M. Ito wrote:
> MySQL folks,
>
> I am planning on using MySQL replication to mirror a database at
> various
.
james montebello
On 7 Feb 2002, Amir Aliabadi wrote:
> How do you make something like this fault tolerant?
> The answer is probably what I suspect, 2 of every thing.
> How does the aggregator handle this or are these machines in a cluster?
>
> We are thinking of how to rebuild our
x weeks of effort.
james montebello
On Thu, 7 Feb 2002, Brian Bray wrote:
>
> It seems to me like the best solution that could be implemented as-is
> would be to keep a random int column in your table (with a range of say
> 1-100) and then have fulltext server 1 psudo-replicate
change master to
master_mysql> unlock tables;
This is also a good way to re-sync a slave if it crashes and corrupts
its tables.
james montebello
On Thu, 7 Feb 2002, Mark M. Ito wrote:
> MySQL folks,
>
> I am planning on using MySQL replication to mirror a database at
> various
UTC doesn't do daylight savings. One reason is that different places
do daylight savings at different times. We here in the Western US, for
example, are in standard time right now. In Arizona, they don't do
daylight savings at all.
james montebello
On Tue, 5 Feb 2002, Oliver Man
t you want.
james montebello
On Tue, 5 Feb 2002, Oliver Mannion wrote:
> Hi dn,
>
> Right. Having said that tho, is there a function
> in mysql that will return the GMT time from the operating
> system, that I can subsequently use in a query.
> I could use the GMT time f
mpared for
exact matches, and they can include fractional values.
james montebello
On Fri, 1 Feb 2002, Jim Dickenson wrote:
> Am I to assume that based on your response that one should never use a float
> field type if you ever want to select the data?
>
> This causes a big problem f
ons. Set up a mysql
user, and set all permissions on the dbfiles to mysql, and there you are.
james montebello
On Fri, 1 Feb 2002, Colin Boyan wrote:
> I am an experienced database developer (Sybase on Solaris mostly) but new to MySQL
>on Linux (so please feel free to redirect me to a
ing to be pushing the
limits of table sizes, it's best to simply test and find out what your
particular config will allow you do to.
james montebello
-
Before posting, please check:
http://www.mysql.com/manual.
t way to do that. No locks
required.
james montebello
On Tue, 29 Jan 2002, Paul DuBois wrote:
> The original question that started this thread was:
>
> >>
> >>I need to find out what the next value will be in an auto_increment field
> >>will be. could s
Of course, if you do LAST_INSERT_ID, then try to use the value while someone
else is doing an insert, you're in the same boat. Neither method is reliable
without a lock.
james montebello
On Tue, 29 Jan 2002, Paul DuBois wrote:
> At 15:16 -0800 1/29/02, James Montebello wrote:
>
le if you lock the table, do the select, do
whatever you're going do to with that value, and unlock the table.
As soon as you do the unlock, the value is useless.
james montebello
On Tue, 29 Jan 2002, Christopher Thompson wrote:
> Not _necessarily_ true, surely, if there's another
SELECT MAX(id) FROM table;
will get you the highest value for 'id', that +1 will be the 'next' value,
until someone inserts a new row into that table.
james montebello
On Tue, 29 Jan 2002, Joel Wickard wrote:
> database,sql,query,table
>
>
> I need to find
Crack the Perl book. A script to do this using SHOW DATABASES and
SHOW TABLES to get the lists would be fairly trivial to write.
james montebello
On Mon, 28 Jan 2002, Michael Collins wrote:
> >From: Michael Collins [mailto:[EMAIL PROTECTED]]
> >Can "describe" be used to
If this is on a Unix flavor, you can use 'cmp' to compare the data and
index files (off-line, of course). Once you know they are identical,
you can simply plot the difference between the slave's update log position
and the master's update log position. As long as it's always 0, the
two are in s
won't be cleaned up. If it can be determined these connections
really aren't in use, they can be KILL'd at the server.
james montebello
On Tue, 15 Jan 2002, Greer, Darren (MED) wrote:
> If say, that client closes the connection at some point in the
> future...that will clean
n until it
tries to write something to the connection. Since MySQL doesn't write
except in reply to a query, it's sitting there with one end of a dead
connection patiently waiting for a new query to arrive.
james montebello
On Tue, 15 Jan 2002, Greer, Darren (MED) wrote:
> Hello again
ay, you're increasing the number of heads per cylinder,
so you're decreasing the chance any given head will have to move, so
average access time drops.
james montebello
-
Before posting, please check:
http://www.mysql.c
d/or the update
rate is pretty low, this shouldn't be a problem. You could simply grab
as many pages as you wish to show into local memory and display the
data out of there instead of directly out of the database. Assumes some
local storage you can use across HTTP requests, of course.
jame
ve results that may not be useful, like skipped or duplicated rows
between "pages".
james montebello
On Fri, 11 Jan 2002, Bret Ewin wrote:
> My system tends to generate large result sets, with the first page of
> results being used and the rest thrown away. I expect this is typ
is when we tried to
use max table sizes above 4GB, and assume it's because of an internal
switch from 32-bit pointers to 64-bit pointers. May not make nearly as
much of a performance difference on a real 64-bit processor and OS.
james montebello
On Fri, 11 Jan 2002, Aaron Brick wrote:
The downside of the 64-bit version is it's considerably
slower. Better to split large datasets up into sub-4GB units.
james montebello
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
If this is a derivative of HTdig, we used it at a previous job, with
reasonable results, as long as the data set isn't too big.
james montebello
On Thu, 10 Jan 2002, Richard McNeil wrote:
> Does anyone use php.dig as a search engine with mysql? If so have you found
> any bugs
way to "corrupt user
accounts" is to corrupt this table in some way. There is no magic here.
james montebello
On Wed, 9 Jan 2002, Matthew Darcy wrote:
> I was doing a flush privileges.
>
> but this was coming up with the same thing no rows affected which to me was
> c
You must do a "FLUSH PRIVILEGES" after making any changes to the user
permissions before they will actually take effect. This is documented.
james montebello
On Wed, 9 Jan 2002, Matthew Darcy wrote:
> query ok I would expect to see, but "no rows affected" ??? this
than any other thread, except in cases like this, where it would be better
for the slave thread to have the same priority as non-slave writes (i.e.,
higher than reads).
Is there some option I'm overlooking?
james montebello
32 matches
Mail list logo
