On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote:
Jeremy, Jocelyn,
can you try the following this patch?
I'm building a new binary row.
The flag which bans MySQL using a descending cursor to calculate
column LIKE 'jhghj%' ORDER BY column DESC
queries was apparently put to
On Wed, Sep 25, 2002 at 08:26:25AM -0600, Scott Pippin wrote:
We are moving a databse over from Oracle to MySQL 4.0.3 and I was
wondering if I should use MyISAM or InnoDb. The databse currently has
800-900 updates and inserts done to it in a day along with about 1000
selects. Would I run in
On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote:
The variables record_buffer,join_buffer and sort_buffer are alocated
every user connect ?
No, their are allocated on an as-needed basis for each thread. If a
thread doesn't need to join anything, there will be no join
On Wed, Sep 25, 2002 at 11:33:37PM +0300, Gergely Imre wrote:
hi all
i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000
records in it (4 field/record). i have 256megs of RAM, and the linux
version is RedHat 7.3. i do a simple delete, like:
delete from foo_db
Heikki and others,
One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled
yesterday) on FreeBSD. I'm getting an assertion failure on line 2180,
which appears to be:
case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE);
What can I do to help debug this?
Thanks,
Jeremy
--
On Tue, Sep 24, 2002 at 05:08:30PM +0200, José Fernández wrote:
Do you know if is a frequent problem that the mysql database damages
suddenly?
It is not.
Have you experience with this type of problems?
Never. Even running alpha MySQL code I don't see anything that nasty
happening.
Jeremy
On Tue, Sep 24, 2002 at 10:36:31AM +0200, David Bordas wrote:
DBI still have performance problem with my big MyISAM table.
DBIn fact, mysql keep locking my table, even for doing select :(
PDB That's how MyISAM works -- it uses table locks for everything.
PDB Given that fact, if it didn't
On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote:
Joseph,
Thanks for the quick answer.
Very nice to know that adding an index forces a rebuild of all indices!
(Side note -- I was going to configure the database with a minimal set
of indices, and then watch to see how
On Fri, Sep 20, 2002 at 01:12:48PM +0600, Asaf Maruf Ali wrote:
Hello Everyone
I have been using MySQL on Linux for over two years and am a devoted fan. I
have been using MySQL for very ordinary applications till now.
Now there may be a requirement that we need to build an enterprise
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote:
Hi All;
Is there any way to get a real time queries per second in MySQL as opposed
to the average given when I request the server status?
Use mytop:
http://jeremy.zawodny.com/mysql/mytop/
That's partly what I wrote it to do.
On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote:
Hi Yuri,
Money talks. Point out that MySQL is an open source initiative and
can save them money. As for knowing another product, such as MS-SQL,
being a deciding factor; it really isn't an issue. All databases, at
their core
On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote:
Version: MySQL.3.22.32-log
Does this problem ring a bell with anyone?
I'm seeing two undesired behaviors, both, *I think*
seem to be because I'm pounding a lot of connections
against the same server/table, all from the same
On Mon, Sep 09, 2002 at 12:35:10PM -0500, Jeremy Tinley wrote:
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle.
Sure
On Thu, Sep 05, 2002 at 09:52:05AM -0400, Jamie Beu wrote:
I am attempting to setup MySQL replication between the ctiadb1 (master)
server and the ctiadb2 (slave) server.
When I look at the mysql.log file on the slave, I see the following
(repeated every 60 seconds):
020904 12:00:30
On Sun, Sep 08, 2002 at 11:53:41PM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) wrote:
Does multi-master mean master to master, imagine you have 3 MySQL
servers, A, B, C, with a load balancer in front end, if we make an
update on A, is it possible to replicate/sync
On Fri, Sep 06, 2002 at 04:25:42PM -0400, Mark Hennessy wrote:
Is there any way to just force the MySQL server to reload from the
table data on disk? The recipient servers are read-only, and the
sending server has a relatively infrequent rate of change, but just
enough that it's important
On Fri, Sep 06, 2002 at 04:29:24PM -0400, Mark Hennessy wrote:
I don't want to use replication as IIRC it would require that the
sending MySQL server be listening externally.
Why not setup an SSH tunnel, since you're planning to use SSH anyway.
Then you can use MySQL's native replication.
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster ?
Multi-master replication works as well in 4.x as it does in 3.23.xx.
Jeremy
--
Jeremy D. Zawodny | Perl, Web,
On Sun, Sep 08, 2002 at 03:30:35AM +, Sam Przyswa wrote:
Jeremy Zawodny ([EMAIL PROTECTED]) écrivait:
On Fri, Sep 06, 2002 at 03:52:24PM +, Sam Przyswa wrote:
Hi,
Does the next MySQL 4.x version will support cross replications
between several master servers in cluster
On Wed, Sep 04, 2002 at 10:28:36AM +0530, Sekhar.Thota wrote:
Hi,
I have did setup for MySQL - Innodb tables. But I am not getting support for
row level locks. Whenever I am issuing a update the innodb tables are
locking my tables. Please help me whether I need to set any variables in
sqld
On Mon, Sep 02, 2002 at 03:35:28AM -0700, John Stanforth wrote:
Jeremy and Michael,
What compiler versions are you using? (just the gcc -v) I'm
wondering especially since MySQL has a warning posted about gcc 2.96
with 2.4 kernels.
gcc version 2.95.4 20011002 (Debian prerelease)
Which
On Fri, Aug 30, 2002 at 10:24:13PM -0700, Jefferson Cowart wrote:
I just downloaded 3.23.52 from the mysql servers and the version of
mysqlbinlog in there doesn't have the -d option you are talking about.
Yeah, looks like it's in 4.0.2 and later. I may have the patch still
floating around if
On Sat, Aug 31, 2002 at 09:58:58AM -0400, Michael Bacarella wrote:
We experienced a similar problem with 3.23.51 which went away
once we compiled from source. Assume this is Linux 2.4?
I've also had good luck with 3.23.51 built from source. I build on a
Debian testing box and run the server
On Fri, Aug 30, 2002 at 04:39:08PM -0700, Jefferson Cowart wrote:
Is there a way to parse the binary update logs and get separate
binary files for each database? I am hosting mysql databases for
people and I want to be able to give each of them binary logs but
only want updates for their DB
On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote:
Howdy,
Before I run off and try it, can anyone offer up any problems with
doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB
of DB tables from a slave to a tape?
That should work. I assume you're going to use
On Wed, Aug 28, 2002 at 04:50:22PM -0400, Mihail Manolov wrote:
I have strange problem - I get Segmentation fault error when I am trying to
execute mysqlhotcopy.
When I remove the [mysqlhotcopy] section in my /etc/my.cnf
configuration it works. Meanwhile, on another server it works just
On Tue, Aug 27, 2002 at 05:40:48PM -0400, Marc Prewitt wrote:
I'm trying to put together some statistics on our queries and am wondering
what percentage of our queries involve a full table scan. The variable
which kind of tracks this is Handler_read_rnd_next. However, since a
query may
On Tue, Aug 27, 2002 at 10:51:09PM -0400, Will French wrote:
Obviously you don't agree with me and that is something I readily
accept. I do have difficulty with the fact that you clearly spent
more time typing your response than considering my points, which
were intended to be constructive.
On Wed, Aug 28, 2002 at 01:02:11PM -0400, Will French wrote:
So they gave you all the details they could.
Did they? That was my whole argument. Over the past 6 months I have read
no fewer than 10 responses from the team which have, in effect, said we
don't know, quit bugging us.
I
On Tue, Aug 27, 2002 at 09:17:46AM -0600, Scott Pippin wrote:
When will MySQL 4.0 be released as a stable version?
Where there have been no reported bugs for a sufficient amount of
time.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] |
On Tue, Aug 27, 2002 at 05:45:07PM -0400, Will French wrote:
When will 4.0.x finally be released to beta?
The facts as I understand them:
- 4.0 went alpha in Nov or Dec of '01
- At the time, Monty and his gang projected stabilization by Jan or Feb
- More than 6 months have passed since and
On Sun, Aug 25, 2002 at 01:11:16PM -0400, Andy Leung wrote:
Hi,
Could anyone tell me what are the differences between MySQL 4 and
MySQL Max 4, now that MySQL 4 has InnoDB built in as standard? I
couldn't find the answer in the manual or the download section. I'd
like to download MySQL and
On Thu, Aug 22, 2002 at 02:40:54PM +1000, Jerry van Leeuwen wrote:
I find myself in the position where I really would like to use 4.0.x in a
production environment where currently 3.23.x is being used. (Mainly because
of the ability of 4.0.x to use indexes on ORDER BY ... DESC, which are
On Wed, Aug 21, 2002 at 11:57:53PM -0500, Brian Moon wrote:
I have a table:
CREATE TABLE `single_table` (
`forum_id` int(10) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`datestamp` datetime NOT NULL default '-00-00 00:00:00',
`thread` int(10)
On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote:
I have a web based ad hoc query builder I built for running
against SQL Server databases. I am trying to port it to mysql. I
need a way to return table info through a query. Is there a way to
return syscolumns type info in
On Mon, Aug 19, 2002 at 02:54:02PM -0400, Brent Baisley wrote:
You might want to lookup MySQL and RAID. MySQL does support a
database RAID setup.
If you change support to provide, I'd agree. We use MySQL on RAID
systems all the time, so it certainly supports it.
Jeremy
--
Jeremy D. Zawodny
On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
Hi Jeremy;
I didn't think my server would be doing any name resolution, particularly
while replace()ing millions of rows in a table. That said,
--skip-name-resolve *seems* to have
On Fri, Aug 09, 2002 at 10:36:09AM -0700, Steven Roussey wrote:
I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty!
Can someone at MySQL email me the file, please. Pretty please. Thanks!
Ugh, that happened with 3.23.49 too, I think. :-(
Jeremy
--
Jeremy D. Zawodny |
On Fri, Aug 09, 2002 at 09:21:13PM +0200, Thomas Seifert wrote:
On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny [EMAIL PROTECTED] wrote:
Excellent. MySQL 4.0.{2,3} is working well for us too.
Is there 4.0.3 already somewhere to download?
Not yet. I believe there will be a 4.0.3 beta
On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
[snip]
COMMIT
we are using the highest level of transactional security -- the term for
it eludes me at the moment.
You mean the isolation level? Are you running at SERIALIZABLE rather
than READ-COMMITTED? IF so, why? You will
On Fri, Aug 09, 2002 at 04:04:10PM -0500, Dan Nelson wrote:
A coredump of this state + gdb thread apply all bt might be interesting.
Hmm. Looks like a problem we solve recently, but yours is a bit
different. We found that FreeBSD's not-so-thread-safe
gethostbyname_r() causes
On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
Symptoms:
mysqld locks itself in a tight loop, consuming all available CPU cycles.
a simple kill sometimes kills the daemon, other times a -9 is required.
While in this state, any access to the daemon stops - mysql queries
On Sun, Aug 04, 2002 at 11:45:27AM +0200, Hussein Morsy wrote:
Is it possible to reload changes of my.cnf without restarting the
Server ?
The reason is, that i want to toggle the log-file output of mysqld.
Some changes are going into MySQL 4.0.3 to allow many server settings to
be changed
On Fri, Aug 02, 2002 at 02:53:38PM -0400, Mihail Manolov wrote:
Thanks Paul,
I am confused with these two variables in the server status:
Connections: 114577
Threads_created: 12759
Could you explain the difference between these two variables?
Thread caching. MySQL doesn't always need
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
Hi guys
I know that you can import data into a table by using 'load data infile' or
'mysql' import.
however, is there something that allows you to export the create statemtns
for the table schema and the data of a database
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote:
The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3)
(again, I acknowledge this is an old article) says flat out that MySQL tends to die
under high load. Also, when I say high load, I am talking 15-30. I
On Mon, Jul 29, 2002 at 12:15:50PM -0700, [EMAIL PROTECTED] wrote:
After many headaches, rantings, and emails, i have FINALLY figured out how
to get 64 indexes out
of MySQL tables.
[snip]
I think its a sad situation that i could find numerous references to using
64 keys, none
more
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL
4.0.x server on FreeBSD?
I seem to be able to induce the problem on FreeBSD but not Linux. I
have a lot more testing to do yet, but if someone else is seeing it
that would really help to narrow the bug down.
Thanks,
Jeremy
On Thu, Aug 01, 2002 at 06:15:16PM +0200, Joseph Bueno wrote:
According to MySQL documentation, indexes are not used with OR:
http://www.mysql.com/doc/M/y/MySQL_indexes.html
You can't speed up your query by adding indexes.
Running 2 separate queries is the best you can do if you want to go
On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote:
Hi,
I've read the performance tuning tips for InnoDB
(http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
when the log files are full and the buffer pool is checkpointed.
By 'geting bit', I mean for several
On Fri, Aug 02, 2002 at 10:41:12AM +0800, Kenneth Gomez wrote:
Dear All,
My web host provider says that he cannot allow me to have a MySQL account
on the server. However, he asks me to set up my tables offline and ftp them
across and asses them using Php.
Can this be done?
Yes.
--
On Thu, Aug 01, 2002 at 09:50:33PM -0400, Quinten Steenhuis wrote:
Hello all,
Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running
into problems if I use alien to convert the RPMs. I could install from
source, but I want to avoid cruftiness and make it easy to upgrade.
On Tue, Jul 30, 2002 at 01:37:26PM +0200, Mozzi wrote:
Hallo all
I have a database that corrupted.
I managed to save the
radacct.frm
radacct.MYD
radacct.MYI
radacct.TMD
files and recreate the table.This is just a logging file so no real
crisis if I lose some data.
How do I import
On Tue, Jul 30, 2002 at 10:34:36AM +0200, Inbal Ovadia wrote:
Hi All
Is MySQL works with XML?
Yes.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 62 days, processed 1,313,326,706 queries (242/sec. avg)
On Tue, Jul 30, 2002 at 10:35:06PM -0700, Bhavin Vyas wrote:
Is there a way to have DB-A and DB-B such that DB-A is the master and DB-B
is the slave. However, I also want to make DB-B the master and DB-A it's
slave so that if I have to fail over to DB-B then DB-A is automatically
following
On Wed, Jul 31, 2002 at 10:54:54AM +0200, mr wrote:
Hello everybody
I'd like to know what does that means: Writing to net in the state row of
processlist.
I have to launch a perl script which do traitement on a mysql table with
1.750.000 records.
It means just what it says--MySQL is
On Tue, Jul 30, 2002 at 10:04:33AM +0100, Andrew Bryant wrote:
How big have people pushed MySQL databases. Has anyone attempted
terabyte size databases, especially large database that are not just
read-only resources. Databases with some OLTP activity.
Well, I just got access to 0.8TB that
On Thu, Jul 25, 2002 at 12:07:48PM -0300, João Paulo Vasconcellos wrote:
Hello everybody,
someone can tell me the best FS to run MyISAM along with InnoDB tables ?
I don't know that there is a best one, but I use ReiserFS and it works
quite well. I'd stay away from a non-journaling
On Mon, Jul 29, 2002 at 06:05:02PM -0400, Keith C. Ivey wrote:
On 28 Jul 2002, at 17:56, Paul DuBois wrote:
At 14:34 -0700 7/28/02, Charlie wrote:
Is there any storage / performance penalty for specifying '' or 0 as
default values, as opposed to allowing null's in the table structure?
On Tue, Jul 30, 2002 at 01:05:18AM +, Jeremy Hiatt wrote:
Hi,
Were planning on buying more hardware soon and have been pondering the
machine configuration mentioned in Rasmus Lerdorfs Programming PHP book
(OReilly): a squid cache redirector sending traffic to multiple Apache
On Tue, Jul 30, 2002 at 01:45:59PM +0900, Takanori Ugai wrote:
Dear Folks,
I'm not sure this is a bug or the SQL syntax.
I created a db named a-b that includes a hyphen.
% mysql a-b
mysql show tables ;
+-+
| Tables_in_a-b |
+-+
On Fri, Jul 19, 2002 at 05:40:21AM +, Jimmy Fernandez wrote:
Hi jeremy Thanks for the quick response.
Appreciate it.
One more clarification though...
How about bringing the database from Unix/liux to
Windows. Still OK?
Yes, all MyISAM tables are stored in a platfor-neurtal format.
--
If you're going to be at the Open Source Convention next week in San
Diego, California, drop by and say hi at some point. I've met
several folks from the mysql mailing lists in years past and would like
to do so again this year.
Just for the record, I have a few MySQL talks that I'll be giving:
On Fri, Jul 19, 2002 at 08:16:06AM +0200, Daniel Kiss wrote:
Hi,
How can I ask the MySQL server how much free space is in InnoDB tablespaces?
SHOW TABLE STATUS will tell you
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
On Thu, Jul 18, 2002 at 04:40:39PM +0100, Pete French wrote:
Maybe BDB tables are not for me after all...
Yeah, just go with InnoDB. :-)
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 3.23.51: up 50 days, processed
On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote:
Jon,
replication 4.0.1 - 4.0.2 does not work because the format in the 4.0
series has evolved. Currently, if your master of the 4.0 series, your slave
must be of the exact same release.
How likely is that to happen again? I
On Thu, Jul 18, 2002 at 04:25:25PM -0700, Chuck Simmons wrote:
sql query
In addition to being able to specify an update lock or a shared mode
lock, one should be able to specify no lock. This is the moral
equivalent of the Sybase noholdlock option. This is useful if you
normally want
On Fri, Jul 19, 2002 at 03:24:34AM +, Jimmy Fernandez wrote:
Hi ALL,
I just wanted to clarify something:
1. Can I upgrade the MySQL version from one older version to a newer
version? For example if I have data base in ver 3.0 can I import over to
newly downloaded ver 4.0 ? Will it
On Tue, Jul 16, 2002 at 07:49:27PM -0500, mos wrote:
With InnoDb you need to pre-allocate file space so all the tables get put
into one file. This is a good idea when you have a lot of people accessing
the database because it reduces the file handles (less work for the
operating system).
On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote:
Hi,
I've compiled mysql-4.0.2-alpha from source, and I cannot seem to
get it to bind to an interface and allow TCP connections.
When I do a SHOW VARIABLES I see skip_networking=ON yet I am not
starting mysql with
On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote:
Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe?
Ah, you're absolutely right. In /etc/my.conf there appears
skip-networking
The problem is, I need to run multiple mysql servers on this
machine. Is
On Wed, Jul 17, 2002 at 02:42:23PM -0700, Jeremy Zawodny wrote:
On Wed, Jul 17, 2002 at 09:33:37PM +0100, Andy Smith wrote:
Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe?
Ah, you're absolutely right. In /etc/my.conf there appears
skip-networking
On Wed, Jul 17, 2002 at 04:42:35PM -0700, James Kelty wrote:
Hello!
I found a small thread from 2 years ago that said that replication
was restricted to MyISAM table types. Is this true? Can I not
replicate InnoDB table types?
It is no longer true.
The reason I ask is that I am getting a
On Tue, Jul 16, 2002 at 02:51:59PM +0200, Mathias Bertelsen wrote:
Hello
Do you think MySQL is secure enough to keep peoples bookkeeping in?
is it safe enough to use without risk of losing important data? Is
it necessary to do anything to make it secure? (eg. use of
On Tue, Jul 16, 2002 at 03:52:35PM -0400, walt wrote:
I have an INNODB table which has 4 records in it. customer_number is the
primary key.
If I run
select count(cutomer_number) from customer;
It takes about 15 seconds to return the number of rows.
I ran explain on the query and
On Tue, Jul 16, 2002 at 08:59:12PM -0300, Alexander Burbello wrote:
I would like to know if MySQL has the same concept
like Oracle has about Instance? or phisical structure
like datafiles, control files, etc.
If you explain the concepts, we can probably help answer your
questions.
Jeremy
--
On Mon, Jul 15, 2002 at 01:52:46PM -0500, Chris Boget wrote:
When dealing with a considerable number of records (10s of
thousands) in a particular table, which is better to use? Currently
we are using MyISAM and the queries on those tables are kind of
slow.
Really? That's not a lot of
On Mon, Jul 15, 2002 at 04:55:18PM -0300, Alexander Burbello wrote:
Hi,
anybody have any presentation showing about mysql.
For example topics: History, Phisical structure, Logic
structure, etc.
I need to make a presentation about mysql.
If somebody could help me. I would appreciate
On Mon, Jul 15, 2002 at 10:21:25PM +0100, Nick Middleweek wrote:
Hello,
Here's what I'd like to do...
* Create a new user in mysql.
See the GRANT command in the manual.
* Let them login and create a new database.
Ditto.
* I want this database to be only viewable by the
user that
On Sat, Jul 13, 2002 at 09:25:32AM +0100, Richard Clarke wrote:
Heikki Others,
I read through the 4.0.2 Changelog but I couldn't find indication of
the following bug fixes.
1. Was the bug with drop/create tables causing assertaion errors fixed.
I think that the latest 3.x release
On Sat, Jul 13, 2002 at 11:12:11PM -0300, Alexander Burbello wrote:
Hi,
I need to make a presentation about MySQL (structure,
etc.)
Anybody can help me. If anybody have a presentation
(powerpoint, etc) would you be so kind to send me by
e-mail, please.
Can you be a little more
On Fri, Jul 12, 2002 at 01:43:02PM -0700, Jon Drukman wrote:
i am having the Error reading packet from server: (server_errno=1159)
replication problem.
in searching the archives for others experience replication problems, i
came across the suggestion of adding these lines to my.cnf
On Thu, Jul 11, 2002 at 10:28:39AM -0700, daniel wrote:
i'm just wondering why when i hit 'reply' to a message on this list,
that it goes to the individual sender, and not the list itself.
doesn't that defeat the purpose of a mailing list? aren't all
responses to a post supposed to be
On Wed, Jul 10, 2002 at 09:57:56AM -0700, Mark Hughes wrote:
Thanks, I had a look at that and it seems that slave_net_timeout is the
variable that should be used and this is set to 3600 seconds - however it
appears that the net_read_timeout is being used and by changing this from
30 to 3600
On Wed, Jul 10, 2002 at 03:13:55PM -0700, Jeff Kilbride wrote:
Is there a web-based interface for bug reporting? Or is there a way
to use the mysqlbug program when my database machine isn't connected
to the internet?
You can submit a but directly to [EMAIL PROTECTED] If your
message
On Tue, Jul 09, 2002 at 08:51:05PM -0700, Todd Cary wrote:
In my mysql dump of a DB using the -B switch, I get
CREATE DATABASE /*!32312 IF NOT EXISTS*/ sfyc;
What is the significance of /*!32312 IF NOT EXISTS*/ - the
/*!32312? Isn't the statement commented out?
That's a hint to MySQL
On Thu, Jul 04, 2002 at 09:33:54AM +0100, David Shields wrote:
The MySQL manual for 3.23.38, Section 11.4 states that you can have a
replication chain A - B - C - A.
I guess this means
A Master B Slave
B Master C Slave
C Master A Slave
Can this loop be reduced to the most trivial case A
On Wed, Jul 03, 2002 at 10:54:23AM -0700, Eric Frazier wrote:
From the manual 4.10.4
Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(),
and TIMESTAMP values.
I am somewhat fearful and curious about how this works. Say we have
a master web database that gets
On Tue, Jul 02, 2002 at 10:54:44AM -0500, Jim Crippen wrote:
In the my.cnf file on the off-site slave, can there be multiple masters
specified where it will replicate all 3 in-house servers to different
databases on itself?
No. A slave can only have one master.
Jeremy
--
Jeremy D.
On Tue, Jul 02, 2002 at 05:56:37PM +0100, Simon Windsor wrote:
Hi
We have just moved out test server from RedHat to Debian.
We have used the backup tapes to recover the data, and all went well to until
we tried to connect via a host name.
For example
mysql test -utest_user
On Mon, Jul 01, 2002 at 06:24:45PM +0200, Mathieu DESPRIEE - NO SPAM wrote:
Hi all,
I want to setup (on linux systems) a pair of redundant mysql servers,
working this way :
* one master and one backup
* the master handles all the requests, the backup updates its data
frequently (and, if
On Tue, Jun 11, 2002 at 03:58:14PM -0700, Jeff Kilbride wrote:
both InnoDB and MyISAM keep also dynamically statistics about tables. In
most cases running ANALYZE TABLE does not bring any benefit in query
optimization.
Personally, I'm pretty shocked to hear you say this. I was under the
On Sat, Jun 29, 2002 at 10:47:47PM -0700, Steven Roussey wrote:
Tomorrow I'll try doing my own compile with gcc3.1. Note the other
guy that had the same problem that went away after he compiled it
himself:
Even gcc 2.95.3 or .4 will work well based on what I've seen. We can
still sustain
On Fri, Jun 28, 2002 at 09:24:02AM +0530, Arul wrote:
Hi
Just was curious to know...
I saw a posting by one of the guys here that Yahoo uses MySQL. Is
this true..
Guilty as charged.
Any idea how many MySQL servers does Yahoo Use amd for which domain
they use MYSQL.
How many servers?
On Wed, Jun 26, 2002 at 08:15:11PM +0530, Arul wrote:
Hi
Any idea when MySQL 4.0 stable release will be made..
As of now only Alpha is released..
Rumor has it that 4.0.2 might be beta.
Also any sites which run on 4.0 Alpha
Yes. Half my servers have been moved to what will be 4.0.2.
--
On Thu, Jun 27, 2002 at 05:27:29PM +0930, G r e g L a w r i e wrote:
Jeremy,
Would you mind sharing how many machines 'half your servers' might
be, what type of work are they doing and how long have they been up
for / how stable would you consider them to be?
Half of my server is, uhm, 3
On Thu, Jun 27, 2002 at 04:21:43PM +0200, Sander Pilon wrote:
It has not been for us. Replication, query cache and fulltext stuff
is borked. But, it's an alpha. Alpha's aren't supposed to be stable.
What replication problems have you seen?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical
On Tue, Jun 25, 2002 at 06:52:36AM -0700, Zachary Denison wrote:
Hi,
I have setup successfully a mysql master / slave configuration
however I would like to setup a system whereby updates could be
performed on either system and then propagated to the other server
(a master/master
On Thu, Jun 27, 2002 at 05:21:55PM -0400, [EMAIL PROTECTED] wrote:
I've found a few useful commands for the MySQL Monitor:
SHOW PROCESSLIST;
SHOW VARIABLES;
Is there anything else I can use to track user usage loads?
Have a look at mytop:
http://jeremy.zawodny.com/mysql/mytop/
It
On Thu, Jun 27, 2002 at 08:16:52PM -0400, MikeParton wrote:
On the other hand, proclaimed native XML databases (eg, Software
AG's Tamino, Ixiasoft's TEXTML) store the XML-wrapped data in the
database...no need to wrap and unwrap the metadata, document/data
structure from the data.
That
701 - 800 of 1672 matches
Mail list logo