Re: Out of tablespace when using innodb_file_per_table
Hello. It is an unusual behaviour for InnoDB tables to create .MYD files. Execute 'show create table' statement on your table to see the type of storage engine. What output does the following statement produce: show variables like 'have_innodb'; Grumm, Carsten [EMAIL PROTECTED] wrote: Hello, I'm using InnoDB with the innodb_file_per_table option on. But now my .MYD-file has reached the maximum filesize of my filesystem and i have to add a new tablespace. Can someone tell me how? Thanks in advance for your help Carsten -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Out of tablespace when using innodb_file_per_table
Hello, I'm using InnoDB with the innodb_file_per_table option on. But now my .MYD-file has reached the maximum filesize of my filesystem and i have to add a new tablespace. Can someone tell me how? Thanks in advance for your help Carsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Out of tablespace when using innodb_file_per_table
Carsten, - Original Message - From: Grumm, Carsten [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Wednesday, January 26, 2005 4:22 PM Subject: Out of tablespace when using innodb_file_per_table Hello, I'm using InnoDB with the innodb_file_per_table option on. But now my .MYD-file has reached the maximum filesize of my filesystem and i have to add a new tablespace. .MYD file? That is a MyISAM type table. Can someone tell me how? http://dev.mysql.com/doc/mysql/en/adding-and-removing.html Thanks in advance for your help Carsten Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]