PM
Subject: How Do I Know If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using
MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing
Kruckenberg <[EMAIL PROTECTED]>
To: John Kopanas <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Friday, November 17, 2006 12:32:19 PM GMT-0500 US/Eastern
Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB?
For any specific table if you do:
show create table ;
It will te
nas wrote:
Is there a command at the command line that can tell me if I am using
MyISAM
or InnoDB? Thanks :-).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> show variables like 'table_type';
+---++
| Variable_name | Value |
+---++
| table_type| MYISAM |
+---++
1 row in set (0.00 sec)
John Kopanas wrote:
Is there a command at the command line that can tell me if I am using
MyIS
stern
Subject: Re: How Do I Know If mySQL is using MyISAM or InnoDB?
This is will tell you your default storage engine type
should you create a table without specifying an engine:
show variables like 'storage engine';
If you want to create a table with a specific engine,
specify it at
How Do I Know If mySQL is using MyISAM or InnoDB?
Is there a command at the command line that can tell me if I am using MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
--
MySQL General Mailing List
For lis
Is there a command at the command line that can tell me if I am using MyISAM
or InnoDB? Thanks :-).
--
John Kopanas
[EMAIL PROTECTED]
http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
For high volume discussion board type work InnoDB is faster. Our
"slow query" log droped 66% just by switching engine types.
Earlier comments about innoDB not supporting "full text" are actually
supposed to read InnoDB doesn't support full text indexes... This is
only important if you reall
Scott Haneda <[EMAIL PROTECTED]> wrote on 15/09/2005 10:31:48:
> I have moved my data from mysql 3 to 4, across various updates, over the
> past few years. I use phpmyadmin generally, and it defaults to making
tables
> myisam.
>
> I can not seem to find a really clear answer as to why I want to
I have moved my data from mysql 3 to 4, across various updates, over the
past few years. I use phpmyadmin generally, and it defaults to making tables
myisam.
I can not seem to find a really clear answer as to why I want to use one
over the other. Generally, I use myisam and change it only when I
On Wed, 2005-07-13 at 15:02 +0100, zzapper wrote:
> Is myisam still dominant for web applications?
depends on your application, if you're running a bulliten board or a
simple catalogue site, then myisam is a good choice as it is faster.
However for an ecommerce site i would definately go for inn
Hi,
I created the "same" database on two different servers (with different versions
of mysql).
I found one db had been created as innodb and the myisam without me
"apparently" having a say in the
matter.
I've Googled and found that Innodb has record locking, roll back, but that
MYISAM is quick
Hi
I have a table with about 20m rows. It is a MyISAM table. I do a alter
table disable keys before loading with "LOAD DATA". Re-creating the
primary key after import takes a long time. I have increased the
myISAM sort buffer to 75MB and the Key buffer is 100MB.
Is there anything else I can do t
> > > > I have a curious issue here, maybe someone can help.
> > > >
> > > > I have a single process that inserts data into tables that contain
> > > > purely logging information. This table is then searched by our Care
> > > > department to troubleshoot issues. I am looking for the best way to
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 01/19/2005 03:33:32 AM:
> Hello Jeremy,
>
> > > I have a curious issue here, maybe someone can help.
> > >
> > > I have a single process that inserts data into tables that contain
> > > purely logging information. This table is then searched by our C
Martijn Tonies wrote:
Hello Jeremy,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
st
Hello Jeremy,
> > I have a curious issue here, maybe someone can help.
> >
> > I have a single process that inserts data into tables that contain
> > purely logging information. This table is then searched by our Care
> > department to troubleshoot issues. I am looking for the best way to
> > st
: Tuesday, January 18, 2005 3:30 PM
To: Thomas Lekai
Cc: mysql@lists.mysql.com
Subject: Re: Logging Data: Should I use MyIsam or InnoDB?
Hi Thomas,
> Thanks, this is what I was originally thinking of, but how I am
> getting rid of the data in log_view_today? OR, are you saying that
> log_view
Hi Thomas,
Thanks, this is what I was originally thinking of, but how I am
getting rid of the data in log_view_today? OR, are you saying that
log_view_today is a merge table for only the current day? That table
def is defined every night? Then I would go about dropping
everything in whatever fas
omas Lekai
Cc: mysql@lists.mysql.com
Subject: Re: Logging Data: Should I use MyIsam or InnoDB?
Hi Thomas,
> I have a curious issue here, maybe someone can help.
>
> I have a single process that inserts data into tables that contain
> purely logging information. This table is then sear
Hi Thomas,
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain
purely logging information. This table is then searched by our Care
department to troubleshoot issues. I am looking for the best way to
store this data, and the struc
I have a curious issue here, maybe someone can help.
I have a single process that inserts data into tables that contain purely
logging information. This table is then searched by our Care department to
troubleshoot issues. I am looking for the best way to store this data, and the
structure on
y, October 10, 2003 4:17 PM
To: Holly Chamberlain
Subject: Re: What do you recommend: MyISAM or INNODB?
No question. MyISAM.
_M
At 02:01 PM 10/10/2003, you wrote:
>Hi Group,
>I'm requesting feedback - should I use MyISAM or Innodb tables, or a
>mix? My database (currently in Sybase) ty
ct: What do you recommend: MyISAM or INNODB?
-->
-->Hi Group,
-->I'm requesting feedback - should I use MyISAM or Innodb tables, or a
-->mix? My database (currently in Sybase) typically gets no larger than
50
-->gigs, but 99% of the data is in one table.
-->
-->(The app is a
Hi Group,
I'm requesting feedback - should I use MyISAM or Innodb tables, or a
mix? My database (currently in Sybase) typically gets no larger than 50
gigs, but 99% of the data is in one table.
(The app is an cleanroom monitoring system, we collect 3-5,000 records a
minute from environm
Randy:
Tuesday, October 7, 2003, 4:49:44 PM, você escreveu:
---[inicio]--
RC> Apologies for the length of this post.
RC> We started off this little proof of concept project using MySQL
RC> InnoDB
RC> tables, in part because we figured we needed foreign key constrain
Apologies for the length of this post.
We started off this little proof of concept project using MySQL
InnoDB
tables, in part because we figured we needed foreign key constraints,
row locking, and all the other bells and whistles that one gets with
DB2 (our production DB on a big - for us - proje
Frank,
- Original Message -
From: "Dr. Frank Ullrich" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 11:18 AM
Subject: Re: MyISAM or InnoDB
> Heikki,
>
> Heikki Tu
Heikki,
Heikki Tuuri schrieb:
>
> Hi!
>
> - Original Message -
> From: ""Orr, Steve"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Thursday, September 26, 2002 9:56 PM
> Subject: RE: MyISAM or InnoDB
>
&g
Hi!
- Original Message -
From: ""Orr, Steve"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 9:56 PM
Subject: RE: MyISAM or InnoDB
>
>
> MySQL doesn't provide "native" support for transac
t they say benchmarking is important? Give me a break!
What we desperately need are some TPC benchmarks for the open-source
databases. Benchmarks which are independenttly audited and verified.
-Original Message-
From: Josh Trutwin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September
On Wed, Sep 25, 2002 at 08:26:25AM -0600, Scott Pippin wrote:
> We are moving a databse over from Oracle to MySQL 4.0.3 and I was
> wondering if I should use MyISAM or InnoDb. The databse currently has
> 800-900 updates and inserts done to it in a day along with about 1000
> selec
> We are moving a databse over from Oracle to MySQL 4.0.3 and I was
> wondering if I should use MyISAM or InnoDb. The databse currently has
> 800-900 updates and inserts done to it in a day along with about 1000
> selects. Would I run in to any table locking problems with MyISAM?
We are moving a databse over from Oracle to MySQL 4.0.3 and I was
wondering if I should use MyISAM or InnoDb. The databse currently has
800-900 updates and inserts done to it in a day along with about 1000
selects. Would I run in to any table locking problems with MyISAM?
Thanks in advance
34 matches
Mail list logo
