Hi,
try putting the full path to the init file, and also try putting
the update command after the two grant commands (if you put it first
and the user r...@173.8.172.53 didn't already exist then the password
will not be set for that user) and put a flush privileges as the last
line ,
Hi Dan,
Yes, actually, I already know that parallel performance will be much
improved, however, I was expecting more improvement on single threads as
well, since the specs say that it takes 40 clock cycles just to access the
FPU on the T1, but something like 6 clock cycles on the T2. So just
Only time will tell what will happen, but I have read a few articles
saying Oracle had been interested specifically in buying MySQL from
Sun as it gives them an open source DB offering (which they dont have
now right?), and that brings with it contact with potential customers
for support
Hi,
In what way can having more cores slow down MySQL (or any other app
for that matter)? Are you simlpy referring to the fact that some
mutlicore servers might be slower in single threaded preformance than
a higher clocked single core system? If I have a mutlicore system with
fast
:S
Hi Bryan
Actually changing the slave setup after a reboot is a very bad
idea, you will have inconsistent data on your slave because every
transaction made from when you rebooted the server to when you reset
the position will not be copied from the master. Thats the point of
the
BTW there is a list specially dedicated to replication configurations:
http://lists.mysql.com/replication
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
What RAID level to use, whether to use SCSI or SATA etc are all pretty
much how long is a piece of string? questions. If you have a really
high end hardware array RAID 5 may be faster than RAID1+0 is on a
cheaper system.
Basically
RAID 5 = slower
SATA = slower
RAID 1+0 = faster
SCSI =
It could be that your my.cnf isn't being read (permissions or in the
wrong directory), or that you have multiple my.cnf files.
Quoting csego...@gmail.com csego...@gmail.com:
That is intentional. I want to write the log to a non-standard location.
Hi Claudio,
I don't think its your English, I agree with you that its not just
confusing it is wrong.
Each server must have its own network interface
At least for my 10 years experience in IT and UNIX I would understand
network interface as physical network interface unless specified as
Quoting John Daisley john.dais...@mypostoffice.co.uk:
I would say in terms of the MySQL server the interface is either a TCP/IP
Port, a Named Pipe, shared memory or a UNIX Socket. Depending on the host
operating system it can use any of those interfaces but each instance must
have its own
Hi,
I'm not asking this as a specific question, more a general gripe
looking for some kind of explanation.
I don't do mysql restores very often, but many times when I have tried
I get nasty errors as if its bombing out due to dodgy characters, or
quote problems etc.
Normally I am doing
This is a known bug, Ive installed MySQL 4 client binaries as a work
around...
_
From: Andy Smith [mailto:[EMAIL PROTECTED]
Sent: 2008-10-30 18:26
To: 'mysql@lists.mysql.com'
Subject: mysql dump problems, no data dumped
Im having an issue using mysqldump to dump a DB from comercial
Hi Rick,
ok sorry, heres a bit more detail, and I see some more useful stuff I
didn't see before too (I still duno whats wrong but guess will be helpful to
those more knowledgeable!).
I believe its using InnoDB for the tables, previously I was seeing an error
24 which from digging around can
Hi,
Im having an issue using mysqldump to dump a DB from comercial app which
includes mysql 4.0.18-pro. It doesnt however include mysql dump for online
backups so Im using the one installed by default in my linux dist which as
you can see below is version 10.11. My problem is that the dump is
On Wed, Aug 06, 2003 at 12:16:40PM -0400, walt wrote:
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
$ cat mysql/master.info
angora-bin.001
20102800
127.0.0.1
repl
removed
3306
60
Looks fine to me. :(
Looks fine to me as well
Are you still getting the 1200
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
files? Hopefully you don't have one at a default location.
I don't
On Wed, Aug 06, 2003 at 11:23:31AM -0400, walt wrote:
On Wednesday 06 August 2003 11:13 am, Andy Smith wrote:
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master
On Wed, Aug 06, 2003 at 03:59:53PM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 10:52:54AM -0400, walt wrote:
Andy,
I don't see
log-slave-updates
in your master setup. I see log-bin, but I think that only applies to
updates done directly to the database (not replication updates
On Wed, Aug 06, 2003 at 11:39:26AM -0400, walt wrote:
On Wednesday 06 August 2003 11:26 am, Andy Smith wrote:
Andy,
I just noticed that you have
a mix of port numbers. Can you try
`netstat -an | grep 3306`
from the command line and see if the master is indeed listening
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
On Wed, Aug 06, 2003 at 02:19:21PM +0100, Andy Smith wrote:
Hi folks, trying to set up replication and I'm getting this problem
which I can't see how to fix despite reading of the manual and
google.
I
On Thu, Aug 07, 2003 at 07:54:18AM +0100, Andy Smith wrote:
On Wed, Aug 06, 2003 at 07:00:33PM -0700, Steven Roussey wrote:
So does anyone else have any ideas what is going on here? Shall I
report this as a bug?
Did you post how you setup the servers to load the different my.cnf
Hi folks, trying to set up replication and I'm getting this problem
which I can't see how to fix despite reading of the manual and
google.
I have set up a master and a slave according to the manual. The
master runs 4.0.12 and the slave runs 4.0.14, they are both actually
on the same machine
On Wed, Aug 06, 2003 at 10:32:23AM -0400, walt wrote:
Andy,
Can you send a copy of your my.cnf file for both the slave and master
database.
Sure.
Slave:
[client]
port=3307
socket=/data/mysql-backup/mysql.sock
[mysqld]
port=3307
socket=/data/mysql-backup/mysql.sock
server-id=4
log-warnings
Can replication be compressed?
Is it already in a binary format which could not be compressed
further?
If run through openssl would that serve to compress it too?
Also, there are a couple of references to compressed client
connections in the manual. Does this work and is it indeed
compressed,
On Tue, Feb 18, 2003 at 05:06:17PM +, Ben Clewett wrote:
This will be my last posting. I don't belive I am being constructive
and have no wish to instantly be hated by the whole of MySQL.
Probably wasn't wise to make a post about how you felt MySQL was
expensive (huh?) and their staff
On Fri, Feb 07, 2003 at 04:33:15PM -0700, [EMAIL PROTECTED] wrote:
Hi Doug Beyer [EMAIL PROTECTED],
I'm not sure if you have checked the manual yet, but following
links seem to be somewhat related to your query:
Please could these stop. Already I have noticed various people
reposting old
On Thu, Feb 06, 2003 at 09:52:11AM -0500, Brent Baisley wrote:
As long as the foreign keys are index it should be pretty quick. There
really is no way to get around processing every record in table data.
As that table grows, your query will get slower. But a 157K rows isn't
really a whole
Hi folks,
I have a problem that normally I'd want to use subselects on. Here
it goes:
Table t1 has a column data_id. Table t2 has a column data_id. Both
are foreign keys for the autoincrement primary column id of the
table called data.
I wish to delete every row from data which is NOT
Hi folks,
Where have the links to MySQL SRPM packages gone from
http://www.mysql.com/downloads/mysql-4.0.html ??
I found being able to build binary RPMs from your SRPMS to be
useful, please could you make these files available again?
(yes I am aware I could build them from a .spec file if that
Hi folks.
I have an application in which I require the only case equivalencies
to be a-z A-Z. What I mean is, e/E should be regarded as identical
in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute)
should be regarded as identical.
When the application was first written I was
On Tue, Jul 23, 2002 at 09:22:55PM -0600, Steve Dickey wrote:
Can anyone tell me how to get an RPM that provides the
libmysqlclient.so.10? I am trying to install the
php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
comes in an older version of the mysql database rpm
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 --skip-networking. To reverse this situation I
tried putting:
set-variable =
On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote:
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
-Original Message-
From: Jonas Norrman [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2001 01:23
To: Andy Smith
Cc: [EMAIL PROTECTED]
Subject:
Andy Smith [EMAIL PROTECTED] writes:
Can you use a mysql database with drumbeat2000
a smith
34 matches
Mail list logo