Hi,
I am seeing a large lock contention on a production database (A large
table_locks_waited against table_locks_immediate).
I want to set low priority updates, but I don't want to shut the
database down to do it.
Is,
set global LOW_PRIORITY_UPDATES=1;
the same as starting mysql with --low_pr
th using a query cache when using so many HANDLER ..
NEXT calls.
Again if so, is it recommended to set a small "query_cache_limit".
--
Regards,
Ian Collins
Systems Manager
KIWIPLAN Group
Tel: +64 (0)9 2727622
Mob: +64 (0)21 761144
--
MySQL General Mailing List
For list archives: ht
(of course, I may be wrong). Are there any
recommendations for HPUX kernel tuning with MySQL?
--
Regards,
Ian Collins
Systems Manager
KIWIPLAN Group
Tel: +64 (0)9 2727622
Mob: +64 (0)21 761144
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
)
Any ideas?
(It may sound trivial but we have automated test suites that break
because of this).
Regards,
Ian Collins.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql, try this
mysql -u root -p < file.sql
HTH,
Dan
On 10/11/06, Ian Collins <[EMAIL PROTECTED]> wrote:
Hi,
I have 2 identical Linux machines setup with identical my.cnf files
(except for server-id) and both running 5.0.26.
On server A, I run,
mysqldump -h localhost -u root -p... --sing
e on!!)
What am I missing here? Has anyone else seen this?
Regards,
Ian Collins.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
te, I altered some my.cnf parameters, and then
the site stayed up for 14 days before doing the same.
This site is identical to others I have seen - that are running with no
issues.
Could this be hardware (memory related)?
Regards,
Ian Collins.
Hi,
I have a customer who wants to be able to replicate their live MySQL
database to a second server, but not to have any data deleted.
i.e., they want to accumulate the data.
I don't believe you can do this with replication. Does anyone know a way
of doing this?
Cheers,
Ian.
--
MySQL Gener
Hi,
I have a customer who wants to be able to replicate their live MySQL
database to a second server, but not to have any data deleted.
i.e., they want to accumulate the data.
I don't believe you can do this with replication. Does anyone know a way
of doing this?
Cheers,
Ian.
--
MySQL Gene
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query faile
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query faile
r reading communication packets)
051004 22:08:34 Aborted connection 314 to db: 'sqllive' user: 'sqllive'
host: `localhost' (Got an error reading communication packets)
My /etc/my.cnf is:
cat /etc/my.cnf
[client]
port=3306
socket=/tmp/mysql.sock
[mysqld]
port=3306
socket
Hi,
I am running an application using the C-API against mysql 4.0.20 on a
redhat AS 3 server.
The users using this application are getting numerous (and seemingly
random) query errors.
Has anyone seen these before? The frm files do exist.
It's not from just this table.
mysql_real_query faile
existed as part of a stored
procedure.
The only way I can see to do it is to use "show index from table", but
that gives all indexes and then parsing the results.
We are after a more efficient way (like the sqlserver query "select *
from sysindexes where name=.")
--
Many
=1000
binlog-do-db=maindata
replicate-do-db=maindata
--
Many Regards,
Ian Collins
System Manager
KIWIPLAN NZ Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
arted mysql.
What is the alarm queue. The documentation says it creates a queue for
alarms, but little else. What was the alarm queue full of? and how do I
stop it?
--
Many Regards,
Ian Collins
System Manager
KIWIPLAN NZ Ltd.
There are always alternatives.
-- Spock
similiar check in MySQL? I know I can just do a
DROP FUNCTION InfDropCurrentParametersTable;
and live with the error if it doesn't exist, but it would be nice to
make the script tidy.
Many regards,
Ian Collins.
-
Bef
Can anyone see any problems with using the HPUX 10.20 MySQL binaries on
HPUX 11.00- it seems to work fine in small scale tests.
Regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php
ed).
2. has anyone already implemented such an advisory locking system? (rather
than reinventing the wheel).
3. Is what I am trying to do just plain dumb!
Many regards,
Ian Collins.
System Manager
KIWIPLAN NZ Ltd.
-
Before posting, p
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotco
presume (again ??) that the above line is trying to strip out all ../
matches.
If so, then wouldn't { $_ !~ m:\.\./: } do just as well?
I changed the
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
to
my @non_raid = grep { $_ !~ m:\.\./: } @$files;
and it seemed to fix my problems.
Regards
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotco
presume (again ??) that the above line is trying to strip out all ../
matches.
If so, then wouldn't { $_ !~ m:\.\./: } do just as well?
I changed the
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
to
my @non_raid = grep { $_ !~ m:\.\./: } @$files;
and it seemed to fix my problems.
Regards
ustomers wanting to (or being able
to!) install from source code.
Can KIWIPLAN act as resellers of mysql, or would our customers purchase
mysql individually?
Cheers,
Ian Collins.
-
Before posting, please check:
http://www.mysq
s(3,'abc\\0def\0gh', 4);
select * from junk5;
--
-- snip
By running this snippet, you will see that you need to "double escape" the
null to get it in the database.
But mysql_real_escape_string doesn't do this.
Is this
any regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsub
the
program).
I hadn't even used a HANDLER READ when it had crashed - just the OPEN.
I guess it's kind of understandable, and not something that happens a lot,
but it may be worth adding this caveat to the documentation (to save some
other lost soul hours of screen kicking).
Re
only obtain one lock at a time).
Does anyone know if this can be extended (parameterised)?
Alternatively, has anyone setup an alternative advisiory locking system
withing mysql?
Many regards,
Ian Collins.
-
Before posting
surmise, off on a tangent)?
Are there any examples anywhere of how to use these?
Many regards,
Ian Collins.
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 15, 2001 11:49 AM
To: Ian Collins
Cc: [EMAIL PROTECTED]
Subject: Re: Help - Migration to
29 matches
Mail list logo