[Ruby] My table, it is full

[John Wulff]

Thanks Pete, that was the problem.  I'm running Gentoo as well.  However, my
default conf was limited to 128M.  No wonder...
On 10/17/07, Pete Higgins <PHiggins at melodeo.com> wrote:
>
> I've run into this problem before, and it was the fault of my linux
> distro's default configuration for mysql. Check your mysql configuration
> (/etc/mysql/my.cnf on my system). Gentoo's default is to have a max of 2
> gigs for innodb data, so I turned that off:
>
> #innodb_data_file_path = ibdata1:10M:autoextend:max:2048M
> innodb_data_file_path = ibdata1:10M:autoextend
>
>
>
> Pete Higgins
>
> -----Original Message-----
> From: ruby-bounces at zenspider.com [mailto:ruby-bounces at zenspider.com] On
> Behalf Of John Wulff
> Sent: Wednesday, October 17, 2007 1:46 PM
> To: Seattle Ruby Brigade!
> Subject: [Ruby] My table, it is full
>
> I'm getting this nasty error:Mysql::Error: The table 'content_terms' is
> full: INSERT INTO content_terms...
>
> Here is some extra info:
> mysql> show table status like 'content_terms';
> +---------------+--------+---------+------------+---------+-
> ---------------+-------------+-----------------+------------
> --+-----------+----------------+---------------------+------
> -------+------------+-------------------+----------+--------
> --------+----------------------+
> | Name          | Engine | Version | Row_format | Rows    | Avg_row_length
> |
> Data_length | Max_data_length | Index_length | Data_free | Auto_increment
> |
> Create_time         | Update_time | Check_time | Collation         |
> Checksum | Create_options | Comment              |
> +---------------+--------+---------+------------+---------+-
> ---------------+-------------+-----------------+------------
> --+-----------+----------------+---------------------+------
> -------+------------+-------------------+----------+--------
> --------+----------------------+
> | content_terms | InnoDB |      10 | Compact    | 1069946 |             49
> |
>    53035008 |               0 |     57786368 |         0 |        1244152
> |
> 2007-10-15 10:45:58 | NULL        | NULL       | latin1_swedish_ci |
> NULL |                | InnoDB free: 4096 kB |
> +---------------+--------+---------+------------+---------+-
> ---------------+-------------+-----------------+------------
> --+-----------+----------------+---------------------+------
> -------+------------+-------------------+----------+--------
> --------+----------------------+
> 1 row in set (0.06 sec)
>
> Any tips or direction towards an applicable reference?
>
> Google hasn't been very helpful so far.
>
>
> Thanks.
>
> --
> John Wulff
>
> _______________________________________________
> Ruby at zenspider.com - Seattle.rb non-commercial list
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby
> _______________________________________________
> Ruby at zenspider.com - Seattle.rb non-commercial list
> http://www.zenspider.com/seattle.rb
> http://www.zenspider.com/mailman/listinfo/ruby
>



-- 
John Wulff