Hi All:
I'm a newbie and I'm trying to understand how can I increase or set
the size of the table in Oracle database. I'm trying to migrate the database
from oracle to MySQL and was successful in that. But, few of the tables are
not created and when I checked back in the oracle database
Hi All:
As the GUI tools archive doesn't help, I wanted to seek some help
from here. I was migrating the database from oracle to mysql. I was having
an issue migrating a table from oracle to mysql figured out that the table
size on the MySQL has to be set. I'm using the migration kit
In the last episode (Mar 13), Tangirala, Srikalyan said:
I'm a newbie and I'm trying to understand how can I increase or set
the size of the table in Oracle database. I'm trying to migrate the
database from oracle to MySQL and was successful in that. But, few of
the tables are not created
Hi Dan:
Thanks for your time. Actually you are right. I was migrating the
database from oracle to MySQL and had issues with migrating few tables in it.
I saw that the reason was that the size of the table. So, I changed the
settings in the migration kit with the Dynamic settings
Qus 2. Is there any other way to compute the db size (other
than disk
quota).
du -s mysql_data_directory
If you want to know the size of a /single/ database (i.e. schema) then
this method works if there's just one database in the
mysql_data_directory. If there are multiple databases
Jaspreet Singh wrote:
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Qus 2. Is there any other way
Hi Joshua,
the BLOB or TEXT is stored separately from the row. What is stored is
a pointer to where the BLOB/TEXT is located.
/Johan
Joshua Beall wrote:
Hi All,
I am a bit confused by the MySQL documentation on this subject. From
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
The
Hi All,
I am a bit confused by the MySQL documentation on this subject. From
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and
TEXT column accounts for only five to nine bytes toward this size.
So, the
Joshua Beall wrote:
Hi All,
I am a bit confused by the MySQL documentation on this subject. From
http://dev.mysql.com/doc/mysql/en/Storage_requirements.html
The maximum size of a row in a MyISAM table is 65,534 bytes. Each BLOB and
TEXT column accounts for only five to nine bytes toward this
I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.
I've been trying various ALTER TABLES commands but none have worked, and I'm
even sure the alter tables is the way to go with this.
What is the proper way to raise that variable
At 11:17 -0500 11/14/02, Richard Idalski wrote:
I'm looking for the proper way to raise the Max Datafile size for a table of
mine that's just about maxed out.
What's the table type, and are you sure you're reaching the max table
size rather than running into a limit on your file system's file
please,
is there a way to get the size of a mysql table through
an SQL query ?
thank you
karel pitra
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
13 matches
Mail list logo