Hello, I have read through several pages of the reference manual, and
I've seen several instances where it is stated that LOCK TABLES (and
UNLOCK TABLES) is not allowed in a stored procedure, but so far, I
haven't found an explanation as to *why* that is. Could someone please
enlighten me?
Thanks
= 300
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 512M
sort_buffer_size = 512M
read_buffer = 8M
write_buffer = 8M
[mysqlhotcopy]
interactive-timeout
[mysqld_safe]
Thanks,
Jeff
Hello,
I got the two picutures attached from mycheckpoint's web graph.
They are showing the threads_connected have been increasing from 24th.
But threads_cached have been decreasing from the same day.
What does this mean for my mysql?
Thanks.
--
MySQL General Mailing List
For list archives: ht
Hello,
I have a question that, if I add the index to the table in slave, but
don't do it in master, will it make problems?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello,
In last day I inserted a SQL which is about 5M to the master, the
max_allowed_packet in both master and slave was 4M at that time.
Then the replication crached, and the info is below:
110928 23:31:53 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.002730' at pos
Hey All,
Can anyone provide some guidance as to what the practical connection limits
to MySQL 5.1/5.5 are under linux?
We're running a ruby on rails application that establishes 50 to 100
connections to our database upon startup resulting in around 1,000
persistent db connections. I've been told
An additional field is pretty much impossible since that case would change
throughout the day unfortunately. But thank you all for your assistance, will
do some testing.
Jeff
-Original Message-
From: Jaime Crespo Rincón [mailto:jcre...@warp.es]
Sent: Monday, October 26, 2009 12:52 PM
ould be. I originally wanted
to use mySQL as the part that did this processing as opposed to outputting the
results then sorting an array.
Jeff
From: 卢钧轶 [mailto:cenal...@gmail.com]
Sent: Sunday, October 25, 2009 1:19 AM
To: Jeff
Subject: Re: Using IF in a query to set a variable then sort on sai
ible in a mySQL query directly? The only other option I guess I
have is to run a mass update on a field then doing the normal order but doing
three updates just to make one select work seems kind of unfortunate :(
Jeff
Darn, oh well.
Thanks for the quick response.
--- On Tue, 7/28/09, Gavin Towey wrote:
From: Gavin Towey
Subject: RE: User Defined Types
To: "delux256-my...@yahoo.com" ,
"mysql@lists.mysql.com"
Date: Tuesday, July 28, 2009, 2:39 PM
Nope
-Original Message-
F
define columns like this:
CREATE TABLE [dbo].[tableName]
(
[statusColumn] [dbo].[status]
)
Is there such a thing in MySQL?
Thanks,
Jeff
e` VARCHAR DEFAULT NULL,
`Zip` VARCHAR DEFAULT NULL,
`HomePhone` VARCHAR DEFAULT NULL,
`CellPhone` VARCHAR DEFAULT NULL,
PRIMARY KEY (`RecNo`)
)
CHARACTER SET utf8
COMMENT = 'Sample';
Jeff
I am brand new to MySQL and JAVA/Netbeans 6.5 so please excuse the
stupid questions ...
1. I have just downloaded and successfully installed MySQL v5.1 on my
MacBook Pro running OS X 10.5.6
2. I have also downloaded and installed MySQL Tools: Administrator &
Query Browser
(I come from
Thanks, that did it!
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2008 11:57 AM
> To: Jeff Mckeon
> Cc: mysql@lists.mysql.com
> Subject: Re: delete query question
>
> Jeff,
>
> >Table2.ticket = t
> -Original Message-
> From: Ian Simpson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 08, 2008 11:27 AM
> To: Jeff Mckeon
> Cc: mysql@lists.mysql.com
> Subject: Re: delete query question
>
> If the tables are InnoDB, you could temporarily set up a foreign ke
ows from table2 where Table2.ticket = Table1.ID (of the deleted
rows..)
Can't this be done in one query? Or two?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DUH!!!
LOL, I'm an idiot..
Gonna go flush my head down the toilet now.
Thanks guys.
From: William Newton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 1:29 PM
To: Jeff Mckeon; MySql
Subject: Re: Error: No query specified
I'm guessing you are addi
y body has tried this
> > >
> > > On Dec 6, 2007 10:08 AM, Krishna Chandra Prajapati <
> > > [EMAIL PROTECTED]>
> > > wrote:
> > >
> > > > Yes, Is it possible or not
> > > >
> > > > -Krishna Chandra Prajapati
> >
When I run a "Show slave status \G" I get a message at the bottom that says
"Error: No query specified"
I don't recall ever seeing this before and can't find anything online about
it. Anyone know what it means?
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Repli
-Original Message-
> From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 05, 2007 8:09 AM
> To: MySql
> Subject: REPLICATION
>
> Hi,
>
> I am working on production and thinking of implementing chain
> replication
> A->B->C. A is replicated to B. B is bei
> -Original Message-
> From: Marcus Claesson [mailto:[EMAIL PROTECTED]
> Sent: Monday, December 03, 2007 7:49 AM
> To: mysql@lists.mysql.com
> Subject: Help with SQL query construction
>
> Hi!
>
> I have a "SQL query construction" question that I hope someone can help
> me with. After c
> -Original Message-
> From: Osvaldo Sommer [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 01, 2007 8:23 AM
> To: 'Jeff Mckeon'; 'David Campbell'; mysql@lists.mysql.com
> Subject: RE: backup InnoDB db to another server
>
> Jeff:
>
>
> -Original Message-
> From: js [mailto:[EMAIL PROTECTED]
> Sent: Saturday, December 01, 2007 8:11 PM
> To: Jeff Mckeon
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> You might want to use --single-transaction
> -Original Message-
> From: David Campbell [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 30, 2007 11:29 AM
> To: mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> Jørn Dahl-Stamnes wrote:
> > On Friday 30 November 2007 17:12, Jef
> -Original Message-
> From: Jørn Dahl-Stamnes [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 30, 2007 11:16 AM
> To: mysql@lists.mysql.com
> Subject: Re: backup InnoDB db to another server
>
> On Friday 30 November 2007 17:12, Jeff Mckeon wrote:
> > Ok, s
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Baron Schwartz
> Sent: Friday, November 30, 2007 11:06 AM
> To: Jeff Mckeon
> Cc: mysql list
> Subject: Re: backup InnoDB db to another server
>
> On Nov 30, 2007 10
ord DB1 > /DATA/DB1backup.sql
I see a /DATA/DB1backup.sql file created on the source server with 0 size,
but nothing on the destination server.
What am I screwing up here?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
weeking to the my.conf that will give me the best
performance on this platform?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello list,
I have a table whose 'default charset=utf8'.
I insert a record into it with non-utf8 charset,like GBK.Then I select
this record,it print GBK characters correctly.
Then I insert a utf8 record into it,and read this record in scripts and
decode it with utf8_decode,the result is also corre
hello,
When saying 'exit' in mysql shell,mysqld would release the lock which was made
before.
But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld also
release the lock or not?
Thank you.
Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren
ohne Zeit- und Vol
hello list,
I saw this article for the suitable filesystem for mysql.
http://www.bullopensource.org/ext4/sqlbench/
>From what I saw,the best filesystem for MyISAM is ext3,the best filesystem for
>InnoDB is Reiserfs.
How about your thought on it?Thanks.
50 AMAZON-Einkaufsgutschein bei Bestellun
Hello list,
I want to get the counter for db-items by each day,so I wrote this sql:
select count(*) as dd from items group by updatetime;
But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get the
correct result.
How can I do this?Thanks.
50 AMAZON-Einkaufsgutschein bei
Thanks!
I think I'm in business. I changed some privileges, examined the logs
(which helped a lot), and initialized the database again using
"mysql_install_db --user=mysql --datadir=/opt/mysql/mysql/data"
now onto PHP
take care
Jeff
From: [EMAIL PROTECTED]
Reply-To: [
Hi!
I'm a rookie, so bear with me...
Keep getting:
Starting mysqld daemon with databases from /opt/mysql/mysql/data
Stopping server from pid file /opt/mysql/mysql/data/unknown.pid
061228 17:16:04 mysqld ended
After this command > bin/safe_mysqld --user=mysql &
Very open to suggestions
Th
Thanks for the detailed feedback. I do not create the data so I can't
modify it. Your illustration of the table is correct. I'll try to
implement some of your feedback.
Thanks
On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote:
Jeff Drew wrote:
> I have a query wi
I have a query with a subquery which does not throw an error, but does not
return either. I've been testing the query using mysql Query Browser and
the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent
error documentation heavily so if the query doesn't throw an error, I'm
insert into user (user,host) values ('jeff','localhost');
flush privileges;
grant all on databaseName.* to jeff;
select user,host from user; returns
jeff localhost
In Java, I use:
DriverManager.getConnection( /localhost/databaseName , 'jeff&#x
> -Original Message-
> From: Dominik Klein [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 18, 2006 11:06
> To: mysql@lists.mysql.com
> Subject: Re: Multi master replication question
>
>
> > Replication setup:
> >
> > A -> B -> A
> > |
> > C
> >
> > One thing I can't remember i
pdates setting (there are
downstream servers doing one way replication off of server B) and then
replicated back to A?
Just having a brain fart here...
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Excellent Dan!
Thanks!
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thu 6/29/2006 4:35 PM
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Mysqlhotcopy and replication
Jeff, that is
7;s my question. While the
tables are flushed with read lock, what becomes of all the Insert,Update
and delete queries that come in via replication? Will they be applied
after the backup is done and the tables unlocked?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.
ems I need to be aware of?
Thanks in advance.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Sunday 04 June 2006 20:38, Marcus Bointon scribble on about:
> On 4 Jun 2006, at 23:25, Marcus Bointon wrote:
> > I'm having trouble with the prefpane in OS X
>
> It seems I'm not alone - there are several reports of this in the
> MySQL bug tracker. Looks like a bug in the prefpane:
>
> http://b
the parent table and use it as
the relationship key for all child tables. This way I know that the value
will never change and it's not part of data important to the end user or the
application. This is basically what Peter suggested.
jeff
--
MySQL General Mailing List
For list a
the parent table and use it as
the relationship key for all child tables. This way I know that the value
will never change and it's not part of data important to the end user or the
application. This is basically what Peter suggested.
jeff
--
Counting in octal is just like counting i
father) references t1(id) on update restrict on delete
> restrict );
> create trigger tg_t1
> before update on t1
> for each row
> begin
> update t1 set c=c+1 where father=NEW.id;
> end;
set NEW.c = NEW.c + 1;
or whatever. You dont update on a before trigger..
Jeff
pgpeUL5J7xa3l.pgp
Description: PGP signature
own in about a minute. Does
anyone know of any way I can log these connections or some other way of
catching it in progress from myslq so I can figure out which website is
causing it and then go correct the code?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mys
>-Original Message-
>From: VenuGopal Papasani [mailto:[EMAIL PROTECTED]
>Sent: Monday, March 13, 2006 11:48
>To: Jeff
>Subject: Re: Help regarding a simple query
>
>
>Hi Jeff,
> This is venu again.Last mail i did not include a constraint that is
what irritatin
Thanks in Advance,
>
> Regards,
> venu.
> (sorry for my poor English)
>
Won't this work?
Select * from X where name like '%venu%'
jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
some way to have this work? Someone on another msg board told me
to look at Auto_increment_increment and Auto_increment_offset to
accompish this but I don't see anything like that in the MySQL docs.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
move the old binlogs to the /data/ prior to restarting
mysql
2) should I move the binlog index as well?
3) will moving the binlog location throw the slaves off?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
f I'm tar'ing a
file while mysql has it open?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sorry for the top post, just saying thanks, that's what I thought
Back to the drawing board...
Jeff
> -Original Message-
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 01, 2006 18:13
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROT
Does anyone know if it's possible to replicate to a single slave from
different databases on different masters?
For instance:
M1:dbAM2:dbB
\ /
rep rep
\ /
Slave
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
ot; Currently, you cannot update a table and select from the same table in a
subquery."
<http://dev.mysql.com/doc/refman/5.0/en/update.html>
However, you can to something like:
select @maximum_column :=max(col_1) from table_1;
UPDATE table_1
SET col_3 = 'bbb'
WHERE col_1 = @m
Anyone know if it's possible to do replication from more than one
database?
Example:
System A: Database 1
System B: Database 2
System C: Replication of SYSA:DB1, Replication SYSB:DB2
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Like the subject says, I am looking for any info regarding positive
or negative effects of using CPU affinity to lock the MySQL process
to a single processor (possibly hyperthreaded).
Anyone tried this? Learn anything interesting?
Thanks,
Jeff;
--
MySQL General Mailing List
For list archives
> -Original Message-
> From: Michael Stassen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 08, 2005 14:34
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: Alter MyISAM table to adjust max_rows and Avg_row_length
>
>
> Jeff wrote:
> > I'
> -Original Message-
> From: Nathan Gross [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 08, 2005 13:58
> To: mysql@lists.mysql.com
> Subject: Optimize: 14 hours and still running!
>
>
> On a 1.6ghz, 1gb ram, Linux machine running Mysql 4.1x.
> I have an Innodb table with over 20
etting for Avg_row_length or even what the measurement is. Bytes?
Columns?
Any help is much appreciated.
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sporadically, the last few entries of a batch are not written. I'm writing
to a mysql database using JDBC. Here's a short version of my code. Does
anyone have suggestions on possible causes or other diagnostics?
class DatabaseWriter{
int writeCount=0;
public DatabaseWriter(){
PreparedStat
Nevermind, found that usig `from` works.
Jeff
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 29, 2005 11:43
> To: mysql@lists.mysql.com
> Subject: Insert query problem
>
>
> All,
>
> I can't get this query to
1','test','test
test',unix_timestamp(now()),'"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now()),'Jeff
McKeon','Jeff McKeon','','','ks5hslajdfasd','1',
Hey all,
I need to do some repairs on a replication master/slave and can't
remember the command to turn off bin logging on the master for a single
session.
Set session log_bin = off;
Just returns an error: ERROR 1193: Unknown system variable 'LOG_BIN'
MySQL ver 4.1.13
5.0.15 version.
> Can anyone help me?
Mysql 5 is much more picky on things you shouldnt have been able to do in the
first place.. Just change idrow to auto_increment and stop doing max.. Its
not needed. innodb properly handles auto_increment now.
Jeff
pgpApFheY1YGC.pgp
Description: PGP signature
306
> --socket=/var/run/mysqld/mysqld.sock
Isnt this just nptl showing 1 process instead of 9 because it shared? Just add
H to the ps command and you will see them.
Jeff
pgpOWtrPWgKxg.pgp
Description: PGP signature
ng. Because a
> server I like has this version and I need to deploy an international
> application, so I really need to store data in utf-8.
> please help if you know. thank you!
No, You need 4.1 and above for that.
Jeff
pgpp1CF3G0AeG.pgp
Description: PGP signature
efaulting it to ''.. so null = '' on insert..
Jeff
pgpIHzJjqrxJ0.pgp
Description: PGP signature
On Friday 21 October 2005 07:04 pm, Stever wrote:
> Is there any reason why there isn't a source rpm for mysql 4.1.15? I
> need to compile my own version since (annoyingly), there doesn't seem to
> be a binary rpm version that works with glibc 2.2.5.
>
> Anyone out there created a source rpm for my
; blocks.
>
> Not sure why they say that ARCHIVE storage engine is a new feature in 5.0?
I had to take a double take, as I thought it was.. That could be why its not
working 100%, as its actually a feature of 5.0. However, I am guessing that
this point..
Jeff
pgpv8zNukrx9v.pgp
Description: PGP signature
ata.
Mysql, nor any DB for that matter, should not, and do not, assume anything.
It just happens in the case your dealing with numeric data. If thats the
case, you should have made the column numeric in type. (int whatever)
Jeff
Jeff
pgpNnLJGNfYAz.pgp
Description: PGP signature
et:utf8
Client characterset:utf8
Conn. characterset:utf8
I've seen some stuff that versions before 4.1.11 suffered from
collation issues - is this likely to my case or can anyone see some
other path through this - we have a single production database that we
are very reluctant to update at this time.
should i just switch back to latin1 ?
thanks mysql list - you guys rock,
lost in translation
Jeff
from that server. I guess
that could be easily spoofed though.
In any event, thanks for a thorough answer, at least I know the behavior
is truly by design.
Jeff
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 12, 2005 09
the db from the local system, fails until I actually
create another grant record for [EMAIL PROTECTED]
It's not a huge problem but I'd like to understand it better.
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
.
4.1, you can show tables like '%tab%' and you will get a row back if exists..
WARNING, myisam will be quick, innodb will be really slow, specially if the
tables are big..
Jeff
pgphkfOW9sFUY.pgp
Description: PGP signature
s running into..
So what error are you getting?
Jeff
pgpZjgXtyciGn.pgp
Description: PGP signature
'password' and the 128 bit
key...correct?
Where might I find the key so that I can send it along to them? any
suggestions on this?
Thank you for your help.
Jeff
[EMAIL PROTECTED] wrote:
Make sure your upgrade actually took:
SHOW VARIABLES
Anybody have an idea why I might be getting the following message:
ERROR 1064 (0): You have an error in your SQL syntax near
'('hello','password')' at line 1
When I type this in at the command line:
SELECT AES_ENCRYPT('hello','password');
Version info: mysql Ver 14.7 Distrib 4.1.12,
Hi,
I need to encrypt data as I insert it into a mySQL database.
The data will then be sent as a text file to another institution to be
decrypted.
I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
I cannot find a single encryption function in the documentation that
seems to not cr
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 29, 2005 14:56
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> >
> > Well the applications with persis
> "Jeff" <[EMAIL PROTECTED]> wrote on 09/29/2005 08:47:52 AM:
>
> >
> > > Jeff wrote:
> > > >
> > > > Ugh...
> > > > mysqladmin -uroot -ptelaurus processlist | grep -c
> "Sleep" And it
> > > > re
> Jeff wrote:
> >
> > Ugh...
> >
> > mysqladmin -uroot -ptelaurus processlist | grep -c "Sleep"
> >
> > And it returned 200 sleeping connections, all persistant
> connections
> > from our app servers and 4 threads_running
> &g
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 13:06
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> >> Cut orignal thread because it was too long
>
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 13:06
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> >> Cut orignal thread because it was too long
>
> -Original Message-
> From: Sujay Koduri [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 28, 2005 11:04
> To: Jeff; mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Subject: RE: MyISAM to InnoDB
>
>
>
> If you think your storage requiremnets will
threads = 4
But what happens if the ibdata2 fills up to the max of 2G?
I've got 50 gig available on the partition where the db data is stored.
Is there anything else here that looks incorrect?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
laves are
> up to 4.1.13.
>
> If you can - upgrade the master server.
>
It's in the plans but that is our main production server so it's not
something we can just do at any time. I've upgraded the slaves first
because generally you can replicate from an older version
> Jeff wrote:
> > Had problem with our database this weekend, apparently an
> app did an
> > insert query that was huge size wise and this totally boogered up
> > replication downstream. Also I cant read past that point in the
> > binlog using mysqlbinlog on the mas
> Jeff wrote:
> > Had problem with our database this weekend, apparently an
> app did an
> > insert query that was huge size wise and this totally boogered up
> > replication downstream. Also I cant read past that point in the
> > binlog using mysqlbinlog on th
lmysql 14K Sep 12 11:50
#sql-7c1c_217c.frm
-rw-rw1 mysqlmysql1.8G Sep 12 11:54
#sql-7c1c_217c.MYD
-rw-rw1 mysqlmysql 92M Sep 12 12:09
#sql-7c1c_217c.MYI
Anyone ever see something like this before? Are they files for a temp
table maybe?
Jeff
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 23, 2005 10:25
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: RE: MyISAM to InnoDB
>
>
> "Jeff" <[EMAIL PROTECTED]> wrote on 09/23/2005
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 23, 2005 09:40
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: RE: MyISAM to InnoDB
>
>
> Sorry to butt in but I wanted to make sure you didn't do
>
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 19:03
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> >>-Original Message-
> >>From:
> -Original Message-
> From: Devananda [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 16:14
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> Jeff wrote:
> > True, is there a way to tell a slave to not repli
w. I
believe there is also some paging overhead so generally take your
calculated row size and multiply by 1.1.
> sujay
>
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 23, 2005 1:12 AM
> To: mysql@lists.mysql.com
> Subject: RE:
> -Original Message-
> From: Sujay Koduri [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 15:23
> To: mysql@lists.mysql.com
> Subject: Avg row length is varying a lot from oracle to MySQL
>
>
> hi ,,
>
> we are converting our oracle DB to MySQL DB. One problem i
> see is
> -Original Message-
> From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 11:41
> To: Jeff
> Cc: mysql@lists.mysql.com
> Subject: Re: MyISAM to InnoDB
>
>
> You will need to make sure you have innodb configured in the my.cnf
> -Original Message-
> From: Warrick Wilson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 22, 2005 12:09
> To: mysql@lists.mysql.com
> Subject: Web-based reporting tool?
>
>
> This seems to be a common question, but answers aren't that common...
>
> What are people using as a we
ems replicating from A -> B -> A (circular
replication) when A had Table1= InnoDB and B has Table1=MyISAM?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 21, 2005 08:55
> To: mysql@lists.mysql.com
> Subject: Timezone setting wrong?
>
>
> I've got a RHEL3 server I just installed with mysql 4.0.16.
>
> The hardware
1 - 100 of 866 matches
Mail list logo
