Hi,
Mroonga 6.08 has been released!
Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.
Document:
http://mroonga.org/docs/
How to install: Install Guide
http://mroonga.org
Hi,
Mroonga 6.06 has been released!
## What is Mroonga?
Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search. It is CJK ready. It uses Groonga as a storage
and fulltext search engine.
Document:
http://mroonga.org/docs/
The characteristics of Mroonga
>
> On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman
> wrote:
>
>>
>> - Original Message -
>> > From: "geetanjali mehra"
>> > Subject: Changing storage engine in dump file.
>> >
>> > Is there any implications in doin
Depending on the version of MySQL and InnoDB engine, the max key length can
be 3072 for InnoDB..
On Wed, Aug 12, 2015 at 9:21 AM, Johan De Meersman
wrote:
>
> - Original Message -
> > From: "geetanjali mehra"
> > Subject: Changing storage engine in dum
is a mix
>> of innodb and myisam tables. I want all my tables to be created in innodb
>> on slave.
>>
>> I have planned to change the value of storage engine from innodb to myisam
>> in dump file itself using sed .
>>
>> Running that dump file on the slave
it is better to take the dump as it is on the master, restore it on the
salve and then change the storage engine through alter table commands that
will be the right way of doing and you could see any issues while
converting from MyISAM to InnoDB.
On Wed, Aug 12, 2015 at 6:51 PM, Johan De Meersman
Am 12.08.2015 um 15:07 schrieb geetanjali mehra:
I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
on slave.
I have planned to change the value of storage engine from innodb to myisam
in dump file
- Original Message -
> From: "geetanjali mehra"
> Subject: Changing storage engine in dump file.
>
> Is there any implications in doing so. Is this approach correct? Will I
> face any problem in syncing the slave?
The first thing that occurs to me, is that t
Hi,
I am in the process of creating a new slave. On my master, there is a mix
of innodb and myisam tables. I want all my tables to be created in innodb
on slave.
I have planned to change the value of storage engine from innodb to myisam
in dump file itself using sed .
Running that dump file on
oad" speed.
> -Original Message-
> From: Lorenzo Milesi [mailto:max...@ufficyo.com]
> Sent: Tuesday, November 20, 2012 7:10 AM
> To: mysql@lists.mysql.com
> Subject: Re: Change storage engine to InnoDB
>
> > InnoDB is _often_ faster than MyISAM.
>
> I rest
> Here is my doc on all the issues (I could think about):
> https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/
Thank you very much, very exaustive guide!
I must review my google search method ;)
--
Lorenzo Milesi - lorenzo.mil...@yetopen.it
GPG/PGP Key-Id: 0xE704E230 - ht
riaDB site, it all applies to regular MySQL,
with or without XtraDB.)
> -Original Message-
> From: Lorenzo Milesi [mailto:max...@ufficyo.com]
> Sent: Monday, November 05, 2012 2:20 PM
> To: mysql@lists.mysql.com
> Subject: Change storage engine to InnoDB
>
> Hi.
>
Yes, InnoDB is the default storage engine for MySQL as of MySQL 5.5.MyISAM
and InnoDB has its own features.
InnoDB probably the best RDBMS out there. InnoDB is default engine might be
due nowadays most of the application required fully ACID-compliant modes,
self recovery from a crash, and many
2011/05/25 10:53 +0200, Reindl Harald
if there is no good reason i will never enable innodb because
MyISAM is enough for most web-apps
And also MyISAM supports auto-increment in a lesser part of a primary key and
InnoDB not--but although it is of interest, I have not tryed it.
Am 25.05.2011 10:35, schrieb Brent Clark:
> Hiya
>
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 / 5.1.
> Have any of you set the mysql def
On 2011-05-25 10:35:45 Brent Clark wrote:
> I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
> default storage engine.
>
> The question I would like to ask is. For those still running Mysql 5.0 /
> 5.1. Have any of you set the mysql default variable to be / u
Hiya
I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its
default storage engine.
The question I would like to ask is. For those still running Mysql 5.0 /
5.1. Have any of you set the mysql default variable to be / use Innodb?
Regards
Brent Clark
--
MySQL General Mailing
be active again I need to
>>> restart the database, however aftewards I assume the tables will still
>>> be MyIsam.
>>>
>>> In this event I will need to manually alter each table, and I am
>>> concerned about the impact of this on the sy
I will need to manually alter each table, and I am
>> concerned about the impact of this on the system performance.
>>
>> Regards
>> Machiel
>>
>>
>> -Original Message-
>> From: John Daisley
>> To: Machiel Richards
>> Cc: mysql mailing list
mance.
Regards
Machiel
-Original Message-
From: John Daisley
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Changing database tables to different storage engine.
Date: Mon, 22 Nov 2010 10:51:23 +
I have frequently seen Innodb 'silently' disabled if the
innodb_l
On Mon, Nov 22, 2010 at 11:55 AM, Machiel Richards <
machiel.richa...@gmail.com> wrote:
>In this event I will need to manually alter each table, and I am
> concerned about the impact of this on the system performance.
>
That will indeed make for quite some locking time, depending on the
database tables to different storage engine.
Date: Mon, 22 Nov 2010 10:51:23 +
I have frequently seen Innodb 'silently' disabled if the
innodb_log_file_size is different to the files size on disk (quite
common when moving systems about). You wont be able to use innodb until
you re
created or changing the innodb_log_file_size to match the size of the
files on disk.
If the Innodb engine is not available then MySQL will use the default
(usually MyISAM) storage engine even if Innodb was specified. You can stop
this behaviour by setting sql-mode=NO_ENGINE_SUBSTITUTION
Regards
Jo
To: mysql mailing list
Subject: Changing database tables to different storage engine.
Date: Mon, 22 Nov 2010 11:59:03 +0200
Good day all
Hope all is well.
I have something to ask as someone might have done this as
well and may have a good solution on how to fix this
restore of the
database.
However, form my part I made a mistake by overlooking the
fact that the windows database was configured to use default storage
engine as Innodb.
On the new server, the default was set to MyIsam.
This resulted in all the tables being
ing Databases in which the tables are created using
> MYISSAM
> storage engine.
>
>
> Now i have another database which will use INNODB engine.
>
> My question is, If i set default engine as INNODB Whether it will make any
> misconduct on other MYISSAM databases?
>
> Th
Hi,
I have one doubt; Please can any one give your view?
I have MYSQL version 5.1.x.
I have some existing Databases in which the tables are created using MYISSAM
storage engine.
Now i have another database which will use INNODB engine.
My question is, If i set default engine as INNODB
Hi All,
> >
> > I have received error message "ERROR 1030 (HY000) at line 167: Got error
> 139
> > from storage engine" when importing dump database to MySQL server. The
> MySQL
> > server is using InnoDB. I have google it and it's something problem on
&g
James, all,
James Corteciano wrote:
> Hi All,
>
> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139
> from storage engine" when importing dump database to MySQL server. The MySQL
> server is using InnoDB. I have google it and it's someth
On Mon, Jul 5, 2010 at 9:06 AM, Rob Wultsch wrote:
> On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano
> wrote:
>> Hi All,
>>
>> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139
>> from storage engine" when importing dump datab
ource and restore ie target
are of different versions .
Thanks,
On Mon, Jul 5, 2010 at 9:36 PM, Rob Wultsch wrote:
> On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano
> wrote:
> > Hi All,
> >
> > I have received error message "ERROR 1030 (HY000) at line 167: Got e
On Sun, Jul 4, 2010 at 8:35 PM, James Corteciano wrote:
> Hi All,
>
> I have received error message "ERROR 1030 (HY000) at line 167: Got error 139
> from storage engine" when importing dump database to MySQL server. The MySQL
> server is using InnoDB. I have google it a
Hi All,
I have received error message "ERROR 1030 (HY000) at line 167: Got error 139
from storage engine" when importing dump database to MySQL server. The MySQL
server is using InnoDB. I have google it and it's something problem on
exceeding
a row-length limit in the InnoDB table.
e
its default storage engine is InnoDB. but it will not change any existing
table storage engine to Innodb.
To do this there is two way.
a. You can change storage engine by alter command of tables, but one by one.
eg. *Alter table [tablename] engine=myisam; *
b. export the database , an then re
On Sun, Apr 18, 2010 at 8:31 PM, Angelina Paul wrote:
> I want to change the mysql default storage engine from MyISAM to InnoDB.
> What are the steps involved .Is it edit my.cnf file and add a line
> default-storage-engine=innodb and restart the mysql server?
If you do not want to c
I want to change the mysql default storage engine from MyISAM to InnoDB.
What are the steps involved .Is it edit my.cnf file and add a line
default-storage-engine=innodb and restart the mysql server? How I can bring
my databases with mixed storage engine down without any data loss. What
steps I
Thanks for all the responses and useful information.
Cheers
Neil
On Thu, Mar 18, 2010 at 6:35 PM, mos wrote:
> At 04:18 AM 3/18/2010, Tompkins Neil wrote:
>
>> Hi
>>
>> I'm currently looking to develop an on line web application - which is
>> going
>> to be used by around 200+ concurrent users
At 04:18 AM 3/18/2010, Tompkins Neil wrote:
Hi
I'm currently looking to develop an on line web application - which is going
to be used by around 200+ concurrent users at any one time. Can
you recommend to me the best/preferred MySQL database engine to use for
example MyISAM ?
Also, in your exp
gt;
>> On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati <
>> prajapat...@gmail.com> wrote:
>>
>>> Hi Neil,
>>>
>>> Recommend : Innodb storage engine
>>>
>>> Even, i would suggest inner join select query (if report query might
&g
rajapati <
> prajapat...@gmail.com> wrote:
>
>> Hi Neil,
>>
>> Recommend : Innodb storage engine
>>
>> Even, i would suggest inner join select query (if report query might takes
>> few seconds) should be executed on slave.
>>
>> Before do
Hi
How do you mean "executed on slave" ?
Neil
On Thu, Mar 18, 2010 at 9:32 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Neil,
>
> Recommend : Innodb storage engine
>
> Even, i would suggest inner join select query (if report query might
Hi Neil,
As Krishna said, Innodb is generally always superior to MyISAM unless
you need full-text search (and even if you do there are alternatives to
MyISAMs full-text search, which I've often found to be lacking in
performance).
A poorly optimised query will be slow whether it is called from a
Hi Neil,
Recommend : Innodb storage engine
Even, i would suggest inner join select query (if report query might takes
few seconds) should be executed on slave.
Before doing any thing. Plan out all the requirement.
Regards,
Krishna
On Thu, Mar 18, 2010 at 2:48 PM, Tompkins Neil wrote:
>
Hi
I'm currently looking to develop an on line web application - which is going
to be used by around 200+ concurrent users at any one time. Can
you recommend to me the best/preferred MySQL database engine to use for
example MyISAM ?
Also, in your experiences, do you recommend that SELECT stateme
The Spider Storage Engine
http://forge.mysql.com/wiki/The_Spider_Storage_Engine
This Thursday (November 26th, 14:00 UTC), Giuseppe Maxia will present
the Spider Storage Engine. This session was originally scheduled for
October 15th but had to be postponed for technical reasons.
Here's fro
The Spider Storage Engine
http://forge.mysql.com/wiki/The_Spider_Storage_Engine
This Thursday (October 15th, 13:00 UTC), Giuseppe Maxia will present the
Spider Storage Engine. Here's from the abstract: Everybody needs
sharding. Which is not easy to maintain. Being tied to the application
l get errors.
Regards,
Gavin Towey
-Original Message-
From: stutiredboy [mailto:stutired...@gmail.com]
Sent: Tuesday, August 25, 2009 12:23 AM
To: mysql@lists.mysql.com
Subject: Got error 124 from storage engine
hi, all:
i have met an question as below:
table A1,A2
A1 has been *pack
Gavin Towey
-Original Message-
From: stutiredboy [mailto:stutired...@gmail.com]
Sent: Tuesday, August 25, 2009 12:23 AM
To: mysql@lists.mysql.com
Subject: Got error 124 from storage engine
hi, all:
i have met an question as below:
table A1,A2
A1 has been *packed by myisampack, and re
030 (HY000): Got error 124 from storage engine
+---+---+--+-+---++
| Field | Type | Null | Key | Default | Extra |
+---+---+--+-+---++
| id | bigint
Hi,
Is there anybody using infobright storage engine on production. Please let
me know the performance.
Thanks
Krishna Chandra Prajapati
In the last episode (Feb 20), Jim Lyons said:
> On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati wrote:
> > On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons wrote:
> >> We have 5.0.22 installed on a test machine and for some reason the
> >> innodb storage engine w
yes, but how does one add engines to an existing install? Is it possible?
I might want/need to add a storage engine that was not in the initial
install.
On Fri, Feb 20, 2009 at 12:59 AM, Krishna Chandra Prajapati <
prajapat...@gmail.com> wrote:
> Hi Jim,
>
> mysql rpm installa
se.
>
> We have 5.0.22 installed on a test machine and for some reason the innodb
> storage engine was not installed with it. We install from RPMs so I'm not
> sure how to install the storage engine. If we compiled ourselves, we'd
> recompile but that's not an option.
can be used for table
handlers.
>
> On Thu, Feb 19, 2009 at 10:08 PM, Baron Schwartz wrote:
>
>> [[...]]
>>
>> On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons wrote:
>>> [[...]]
>>>
>>> We have 5.0.22 installed on a test machine and for some
les |
| InnoDB | YES | Supports transactions, row-level locking, and
foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level
locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it
disappears) |
| EXAMPLE|
Hi Jim,
mysql rpm installation comes with default storage engine myism and innodb.
Just verify show engines on mysql prompt.
On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons wrote:
> We have 5.0.22 installed on a test machine and for some reason the innodb
> storage engine was not enable
The answer is no
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 23:50:13
To:
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
What configuration parameter in the config file could have an impact on
whether a
What configuration parameter in the config file could have an impact on
whether a particular storage engine is supported? The binaries are built
before the config is even used. I don't mind posting the file, but I don't
see the point.
The question is pretty simple, can one add a stor
Can you post you my.cnf please
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 23:06:33
To:
Cc: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
How does one do that in my.cnf?
It is possible to disable a supported
y.cnf. I would love
it, if I could, though.
On Thu, Feb 19, 2009 at 10:47 PM, wrote:
> Perhaps you disabled it via my.cnf
>
>
> Sent via BlackBerry from T-Mobile
>
> -Original Message-
> From: Jim Lyons
>
> Date: Thu, 19 Feb 2009 22:45:01
> To: MySQL
> S
Perhaps you disabled it via my.cnf
Sent via BlackBerry from T-Mobile
-Original Message-
From: Jim Lyons
Date: Thu, 19 Feb 2009 22:45:01
To: MySQL
Subject: Re: Resend: enabling storage engine with RPM install
Yes, I had a slip of the mind. The engine that was not supported by the
gt; be clear. The problem isn't that innodb is "DISABLED" on the database.
> The
> > innodb engine is not supported by the database.
> >
> > We have 5.0.22 installed on a test machine and for some reason the innodb
> > storage engine was not installed w
gy and want to
> be clear. The problem isn't that innodb is "DISABLED" on the database. The
> innodb engine is not supported by the database.
>
> We have 5.0.22 installed on a test machine and for some reason the innodb
> storage engine was not installed with it. We insta
Sorry, but I'm resending because I made a mistake in terminology and want to
be clear. The problem isn't that innodb is "DISABLED" on the database. The
innodb engine is not supported by the database.
We have 5.0.22 installed on a test machine and for some reason the innod
We have 5.0.22 installed on a test machine and for some reason the innodb
storage engine was not enabled. We install from RPMs so I'm not sure how to
enable the storage engine. If we compiled ourselves, we'd recompile but
that's not an option.
Does anyone know how to enable a stor
All,
I can't find the following informations on the MySQL Docs to see if there
are limits on data types using NDB6.2:
[1] What is the maximum length for one record of a NDB 6.2 storage engine
table? (65k like MyISAM?)
[2] Is it possible to use TEXT and BLOB fields without any problem?
T
s the default storage engine so it should not be specified.
Cheers
Claudio Nanni
2009/1/14 Walter Heck
> You can only copy files liek that for MyISAM tables. Are you sure you
> didn't
> accidentally convert to INNODB somewhere along the line? If so, go back to
> your old insta
ad because WAMPSERVER defaults
> to INNODB and ALL my work is MYISAM so after I figured out that I just
> need to change the default storage engine, everything worked as
> expected, copy the files, fire it up and it works. THIS TIME, I have a
> real problem because the default storage en
he default storage engine, everything worked as
expected, copy the files, fire it up and it works. THIS TIME, I have a
real problem because the default storage engine has disappeared from
the my.ini file and if I put it in MySQL does not even start anymore.
Not only that, when I copy the database
.
Not using a multi-character character set. This is regular old english
(latin, I think it's called?)
What storage engine type are you using? I found some issues with InnoDB
regarding this error. Please check the .err log of mysqld as well.
InnoDB is the engine I'm using, and searc
Thanks,
> Jesse
Hi Jesse
I was running the 'perror' command from the bash command line of a Linux
system.
A column of type text will allow a maximum of 65'535 characters being
stored, but this could be less when a multibyte character set is used.
What storage engine type are
prompt> perror 139
MySQL error code 139: Too big row
Seems you are exceeding some limit.
Where did you run the "perror" command from? I tried to run that in the
MySQL command line utility and got an error?
At any rate, the field in question is a Text field. My understanding is
that the li
ags. When
> it tries to save the text to the table in the database, I get the error,
> "#HY000Got error 139 from storage engine". Does anyone know what this is and
> how to fix it?
prompt> perror 139
MySQL error code 139: Too big row
Seems you are exceeding some limit
the database, I get the error,
"#HY000Got error 139 from storage engine". Does anyone know what this is and
how to fix it?
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---+--+
> >
> >
> >
> >
> >
> >
> >
> > On 4/2/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> >
> >
> > > Hi All,
> > > Thanks a lot for you reply. Will do this setup.
> > &g
his setup.
regards
anandkl
On 4/2/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi,
Enter in my.cnf file
[mysqld]
skip-bdb
skip-innodb
Regards
Rakesh
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 9:59 AM
To: MySql
Sub
8, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> > Enter in my.cnf file
> > [mysqld]
> > skip-bdb
> > skip-innodb
> >
> > Regards
> > Rakesh
> >
> > -Original Message-
> > From: Ananda Kumar [mailto:[E
rom: Ananda Kumar [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2008 9:59 AM
> To: MySql
> Subject: only myisam storage engine
>
> Hi All,
> We have a linux box running debain, with 8 cpu and 8 GB RAM, we want
> only myisam engine to be running on this.
>
> So, sh
Hi,
Enter in my.cnf file
[mysqld]
skip-bdb
skip-innodb
Regards
Rakesh
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2008 9:59 AM
To: MySql
Subject: only myisam storage engine
Hi All,
We have a linux box running debain, with 8 cpu and 8 GB RAM
You can set the skip-innodb option in my.cnf
-Eric
On Tue, Apr 1, 2008 at 9:28 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only
> myisam engine to be running on this.
>
> So, should i not setup any innodb paramete
Hi All,
We have a linux box running debain, with 8 cpu and 8 GB RAM, we want only
myisam engine to be running on this.
So, should i not setup any innodb parameters or is there any other way to
have only myisam engine running on this machine, please let me know.
regards
anandkl
learnt
On Tue, Mar 18, 2008 at 3:39 PM, Paul McCullagh <
[EMAIL PROTECTED]> wrote:
> Yes, definitely. Previous versions of PBXT built on Windows, so there
> can't be much work to get it going.
>
> But I don't think I will get around to firing up my Windows VM until
> after the conference...
>
> O
Yes, definitely. Previous versions of PBXT built on Windows, so there
can't be much work to get it going.
But I don't think I will get around to firing up my Windows VM until
after the conference...
On Mar 18, 2008, at 8:30 AM, Sebastian Mendel wrote:
Paul McCullagh schrieb:
Hi All,
I ha
Paul McCullagh schrieb:
Hi All,
I have just released the first fully durable version of PBXT. Because of
the amount of new code I have reverted PBXT to Alpha status. This
version, 1.0-alpha, can be downloaded from:
http://www.primebase.org/download.
will there be any Windows builds availabl
l,
I have just released the first fully durable version of PBXT.
Because of the amount of new code I have reverted PBXT to Alpha
status.
This version, 1.0-alpha, can be downloaded from: http://
www.primebase.org/download.
PBXT is a highly scalable, transactional storage engine for MySQL.
The
Hi All,
I have just released the first fully durable version of PBXT. Because
of the amount of new code I have reverted PBXT to Alpha status. This
version, 1.0-alpha, can be downloaded from: http://www.primebase.org/
download.
PBXT is a highly scalable, transactional storage engine for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, Dec 02, 2007 at 09:55:23AM +0530, Alex Arul Lurthu wrote:
>How about looking at the .frm file of the table.
A couple of quickie tests shows something promising:
strings table.frm | egrep 'MyISAM|InnoDB|engineA|engineB|etc'
Unknonwn whethe
this will work:
> >
> > SHOW CREATE TABLE table_name;
> >
> >
> > On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
> >
> > > Hey everybody,
> > >
> > > Hopefully some of you are already enjoying time off. I am not...yet :)
&
rner wrote:
>>
>> > Hey everybody,
>> >
>> > Hopefully some of you are already enjoying time off. I am not...yet :)
>> >
>> > Anyway, is there a way to determine what storage engine a tabl
> >
> > Hopefully some of you are already enjoying time off. I am not...yet :)
> >
> > Anyway, is there a way to determine what storage engine a table is
> > using if it's crashed? When it'
ody,
> >
> > Hopefully some of you are already enjoying time off. I am not...yet :)
> >
> > Anyway, is there a way to determine what storage engine a table is
> > using if it's crashed? When it&
; Hey everybody,
> >
> > Hopefully some of you are already enjoying time off. I am not...yet :)
> >
> > Anyway, is there a way to determine what storage engine a table is
> > using if
Maybe this will work:
SHOW CREATE TABLE table_name;
On Nov 21, 2007, at 9:42 PM, Richard Edward Horner wrote:
Hey everybody,
Hopefully some of you are already enjoying time off. I am not...yet :)
Anyway, is there a way to determine what storage engine a table is
using if it's crashed?
Look at the data files. The extension of the file will tell you.
On 11/21/2007 12:42 PM, Richard Edward Horner wrote:
Hey everybody,
Hopefully some of you are already enjoying time off. I am not...yet :)
Anyway, is there a way to determine what storage engine a table is
using if it's cr
Hey everybody,
Hopefully some of you are already enjoying time off. I am not...yet :)
Anyway, is there a way to determine what storage engine a table is
using if it's crashed? When it's fine, I can just run:
mysql> show table status lik
Hi All,
I am configuring mysql on a system for keeping only data of myisam storage
engine type. So what component of my.cnf should i increase to get a good
performance. Is it key_buffer or some more components are there. If yes then
Please, let me know
Thanks
--
Krishna Chandra Prajapati
MySQL
k and copied the data dir from the old one but when we want to
access to our databases we get this in error in the client:
ERROR 1030 (HY000): Got error 1 from storage engine
looking at the error log I've seen that there was some differences between
ibdata files, so I deleted them, then I got thi
went out.
-
I'd like to do full text search on some fields of some tables, but
I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use a specific storage
engine for
a table)?
b)What storage engine(s) are required?
c)Are there
;d like to do full text search on some fields of some tables, but I'm a
bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use a specific storage engine for
a table)?
Yes, MyISAM only.
b)What storage engine(s) are required?
c)Are there any restricti
.e. do I need to use a specific storage engine for
a table)?
b)What storage engine(s) are required?
c)Are there any restrictions on "mixing and matching" tables that use
different storage engines in the same database?
d)Do table locking and transactions work the same (for example, s
1 - 100 of 172 matches
Mail list logo
