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
[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:
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
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
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 said variable
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
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
to then define columns like this:
CREATE TABLE [dbo].[tableName]
(
[statusColumn] [dbo].[status]
)
Is there such a thing in MySQL?
Thanks,
Jeff
, 2:39 PM
Nope
-Original Message-
From: Jeff Lanzarotta [mailto:delux256-my...@yahoo.com]
Sent: Tuesday, July 28, 2009 11:37 AM
To: mysql@lists.mysql.com
Subject: User Defined Types
Hello,
I am evaluating MySQL. I am coming from Microsoft SQL Server 2005.
This may have been discussed
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
DEFAULT NULL,
`Zip` VARCHAR DEFAULT NULL,
`HomePhone` VARCHAR DEFAULT NULL,
`CellPhone` VARCHAR DEFAULT NULL,
PRIMARY KEY (`RecNo`)
)
CHARACTER SET utf8
COMMENT = 'Sample';
Jeff
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]
-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 key
relationship between the two
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 = table1.ID
Table2 is a many to 1 relationship
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
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 adding a semi
or not
-Krishna Chandra Prajapati
On Dec 5, 2007 8:56 PM, Jeff Mckeon [EMAIL PROTECTED]
wrote:
-Original Message-
From: Krishna Chandra Prajapati
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 05, 2007 8:09 AM
To: MySql
Subject
-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 being
-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 comparing a
-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 option when mysqldumping
innodb
-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:
Mysqldump don't back up your index, that's your data only
-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, Jeff Mckeon wrote:
Ok, so what would
-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:55 AM, Jeff Mckeon [EMAIL PROTECTED] wrote
/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://lists.mysql.com/[EMAIL
-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, so what would be the command to get
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
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
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 Bestellung
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
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
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: [EMAIL PROTECTED
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,
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 with a subquery which does
(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',null );
when the application tries to connect
(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]
-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 is do I have to set an
. 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.mysql.com/mysql
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
.
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:
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 in decimal--if you don't use your
thumbs
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 archives: http://lists.mysql.com/mysql
To unsubscribe
) 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
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.mysql.com/mysql
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.com/mysql
like '%venu%'
jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-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 irritating me most.Actually if i got venu-kkk
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]
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 PROTECTED]
Subject: Re
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]
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/mysql
.
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 = @maximum_column;
Perhaps someone else has a better solution.
--
Jeff Shapiro
listserv only address
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 unsubscribe
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
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]
-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 million
-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've got a table that just hit the 4gig limit
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(){
',unix_timestamp(now()),'[EMAIL PROTECTED]
[EMAIL PROTECTED]','Medium','Open',unix_timestamp(now()),'Jeff
McKeon','Jeff McKeon','','','ks5hslajdfasd','1','[EMAIL PROTECTED]')
The error:
You have an error in your SQL syntax near
'from,department,subject,body,lastaction,lastpost,priority,status,create
d
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 run, it keeps compaining
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
Thanks,
Jeff
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
to auto_increment and stop doing max.. Its
not needed. innodb properly handles auto_increment now.
Jeff
pgpApFheY1YGC.pgp
Description: PGP signature
= '' on insert..
Jeff
pgpIHzJjqrxJ0.pgp
Description: PGP signature
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
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 mysql?
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
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
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
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://lists.mysql.com/[EMAIL
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:53
To: Jeff
Cc: mysql
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
are you getting?
Jeff
pgpZjgXtyciGn.pgp
Description: PGP signature
the '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 like 'ver
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
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,
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
Also a show status gave me a max_used_connections of 236.
If that's the case
Jeff [EMAIL PROTECTED] wrote on 09/29/2005 08:47:52 AM:
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
Also a show
-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 persistant connections is a
touchy subject.
Our apps send
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 to a newer one
but not the other way around.
Jeff McKeon wrote:
Jeff wrote
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/mysql
To unsubscribe
-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 increase in
future, try to estimate how
-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
The system is only used as a database server
-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
The system is only used as a database server
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 master server. It complains
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 master server. It complains
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
--
MySQL
-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: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September
-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
actually do what
you proposed to do, yet
-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 09:57:06 AM:
-Original Message-
From: [EMAIL
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: 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 web-based
-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
file and you have enough space built
-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 that the
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: Avg row length is varying a lot from oracle to MySQL
-Original
-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 replicate
certain queries
like alter table
-Original Message-
From: Bruce Dembecki [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 20, 2005 23:05
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: Circular Replication
On Sep 16, 2005, at 11:07 AM, Jeff wrote:
There shouldn't be a problem if:
server A is ver 4.0
1 - 100 of 828 matches
Mail list logo