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 fr
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 or
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 sing
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
: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 posi
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 = fa
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" :
That is intentional. I want to write the log to a non-standard location.
--
Quoting John Daisley :
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 interface.
Just to chip in on th
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 a
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
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 be
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 exi
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 applie
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). I'm not 100%
> sure about that, but it may be worth looki
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,
> > > &
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 d
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
> >
> > L
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
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 man
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
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
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 (it's
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, o
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 ru
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
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 wh
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 ref
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 i
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 comple
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 r
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 connec
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 = skip
-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
35 matches
Mail list logo
