So, we have a webmail application that uses a mysql server for holding
it's session information. Obviously this causes many
reads,updates,inserts, and deletes to happen. Here are my lock
statistics.
| Table_locks_immediate| 73099 |
| Table_locks_waited | 32187 |
This ratio see
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
-James
On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote:
> On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
> > So, we have a
t;
> > > > This ratio seems REALLY bad to me.
> > >
> > > It's not good. Especially if that's a small number of tables.
> > >
> > > > I'm wondering if there is anything I can do to tune the server a
> > > > little. I
Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M.
-James
On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote:
> On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
> > Whoa, ok. Sorry. I didn't read the questions about the data and index
> > files.
I was wondering of there is a way to kill multiple processes in MySQL
rather than one at a time?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ount(am_rtr) from ArpMon, I get 111 entries as well as
select am_rtr from ArpMon.
But! It I run select am_mac from ArpMon, I get the 27498 entries.
What's up with that? Can someone help me to figure this one out?
-James
James Kelty
E-Commerce / Financial Systems Administrator
Portland
|
Corrupt |
+--+---+--+-+
5 rows in set (0.85 sec)
-James
On Wed, 2003-09-03 at 18:41, Paul DuBois wrote:
> At 16:49 -0700 9/3/03, James Kelty wrote:
> >So, we have this table: ArpMon that looks like this:
> >
Hello,
We had a strange instance happen here with one of our MySQL servers.
We have multiple MySQL installations, and one of the MySQL servers had a
problem with daylight savings time.
Basically, when we ran a select now(); MySQL reported time that was two
hours ahead of the actual time. The syst
Hello,
We have currently tuned MySQL for a high rate of traffic. But, now we are
seeing issues with memory usage. It reaches about 2GB and the server becomed
wildly unstable. Below is our my.cnf file. Can anyone point out any glarring
errors? We are running this on a Dell 2650 with Red Had Adva
Try /usr/bin/safe_mysqld
The mysqld_safe is 4.0.x version.
Also, try reading the installtion instructions and check out the manual
online at mysql.com
-James
-Original Message-
From: Claritinet.com [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 11:28 AM
To: [EMAIL PROTECTED]
How is 'next-key' locking correctly advertised as 'row-level' locking? I
don't actually see that InnoDB has row-level locking at all. Am I totally
wrong on that?
-James
Does it have exclusive and shared?
-James
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 16, 2004 4:52 AM
To: James Kelty
Cc: [EMAIL PROTECTED]
Subject: Re: Locking
Hi!
Next-key locking essentially doesn't work on rows - it works on indexe
Check the max_connections variable
Mysql> show variables liks '%connection%';
-James
-Original Message-
From: Christof Egner [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: Can't create a new thread (errno 11)
Hello,
I'm having problem
As a DBA I have a few questions about what you said here.
You have worked with both PostgreSQL and MySQL, and yet you say that MySQL
is 'signifigantly' faster than Oracle? Can you PROVE that? And how is it
faster to chase down data problems when MySQL has no native constraints in
it data design?
Hello,
Is there a compile option or startup option to make mysql ignore table name
case? So that the tables security and Security would be seen as the same
table?
-James
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801
ilesh
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: Mysql Table Case
Hello,
Is there a compile option or startup option to make mysql ignore table
name
case? So that the tables security and Security wou
and that the password in
/etc/my.cnf if correct. Any other reason that this is failing?
-James
sql query
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801
---
Apparently I had list File permissions with my user. Thanks anyway.
-James
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Replication Problem
Hello,
I have this replication problem. I am getting
Hello,
Does anyone know, off the top of their head, what server_errno=1159 on a
SLAVE means? Replication is working, but I just want to know what that is.
Thanks.
-James
sql query
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED
Thanks alot!
-James
-Original Message-
From: Oscar Rylin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 3:05 PM
To: 'James Kelty'; [EMAIL PROTECTED]
Subject: RE: Server Error
http://www.geocrawler.com/archives/3/8/2002/6/0/9054036/
/ Oscar Rylin
-Origin
mysql,query
Hello,
Maybe I'm an idiot, but I can't find any documentation on how to stop
running queries interactively. The only thing I can come up with is to stop
and restart the server. I don't want to do that. Basically, if a user does
something stupid, and sparks off a query that is hoggin
sql,query
Ok, this is a little weird.
>From system A I can access the Database on System B via the mysql
command line with the -h option. I can insert into a table, create a
table, and drop tables. But! Through the JDBC interface using the same
user/pass, I get an access denied message.
I beli
Thanks to those on the list that looked into it. Apparently the
developer was trying to do an insert on a read only connection.
Damn.
Thanks again!
-James
On Wed, 2002-10-02 at 11:26, James Kelty wrote:
> sql,query
>
> Ok, this is a little weird.
>
> >From system
sql,query
Hello.
Is there an option for the slave server to NOT stop when an error
inducing query is run on the master?
For instance, if someone tries in insert a duplicate entry, and the
master shows the error, but updates the binlog, how can I keep the slave
from seeing the same error, and NO
Hello,
We have compiled in InnoDB support for MySQL 3.23.51. We would LOVE to take
advantage of the transactions and foreign key assignments that it provides.
We are having an issue, with the following SQL, however:
All of the alter table statements are ending with this error:
ERROR 1005: Can't
t! But!
MySQL to the rescue! It errored out (as you would expect). Thanks for all
the help!
-James
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 1:11 AM
To: [EMAIL PROTECTED]
Subject: Re: Error 150 on 3.23.51
James,
- Original Message
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?
The reason I ask is that I am getting a the 1189: Net Read Error when I run:
LOAD TABLE name FROM MASTER;
Is there a work around
Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I
got it to ACTUALLY replicate InnoDB tables, eh?
This is my /etc/my.cnf file from the master server:
[mysqld]
log-bin=/storage/mysql/replication.log
server-id=1
default-table-type=innodb
innodb_data_home_dir=/storage/inno
28 matches
Mail list logo