Professional Web Applications Themes

LARGE tables in mysql-standard-5.0.18-linux-i686? - MySQL

Ignoramus1130 wrote: > I have a website algebra.com. In it, I have a big table with cached > data. When I used Mysql 3.22, it would often exceed the 4 GB limit. > > I hated that and finally upgraded to mysql-standard-5.0.18-linux-i686 > this morning. I did all the steps listed and it seems that the new > mysql is running, pointing to the old data directory: > > mysql 28330 0.4 0.8 38012 17252 pts/5 S 11:15 0:00 > /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql > --datadir=/var/lib/mysql --user=mysql > --pid-file=/var/run/mysqld/mysqld.pid --skip-locking > --socket=/var/lib/mysql/mysql.sock > > I kind of like this, since it is ...

  1. #1

    Default Re: LARGE tables in mysql-standard-5.0.18-linux-i686?

    Ignoramus1130 wrote:
    > I have a website algebra.com. In it, I have a big table with cached
    > data. When I used Mysql 3.22, it would often exceed the 4 GB limit.
    >
    > I hated that and finally upgraded to mysql-standard-5.0.18-linux-i686
    > this morning. I did all the steps listed and it seems that the new
    > mysql is running, pointing to the old data directory:
    >
    > mysql 28330 0.4 0.8 38012 17252 pts/5 S 11:15 0:00
    > /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql
    > --datadir=/var/lib/mysql --user=mysql
    > --pid-file=/var/run/mysqld/mysqld.pid --skip-locking
    > --socket=/var/lib/mysql/mysql.sock
    >
    > I kind of like this, since it is very compatible with my existing
    > apache, DBD::mysql, perl stuff, etc etc etc.
    >
    > My only issue is that I suspect that I have NOT accomplished what
    > I wanted, namely converting my table to bigger capacity. I recreated
    > it using my old commands that I had:
    >
    > create table bincache (
    > id VARCHAR(250) PRIMARY KEY,
    > dataclass VARCHAR(32),
    > lastdate DATETIME,
    > lastused DATETIME,
    > dataitem blob
    > )
    >
    > The files seems to me just like my old files:
    >
    > -rw-rw---- 1 mysql mysql 7412532 Feb 13 11:17 bincache.MYD
    > -rw-rw---- 1 mysql mysql 60416 Feb 13 11:17 bincache.MYI
    > -rw-rw---- 1 mysql mysql 8710 Feb 13 10:57 bincache.frm
    >
    > Am I fooling myself here? How do I specify a large table that can
    > exceed 4 GB?
    From [url]http://dev.mysql.com/doc/refman/5.0/en/table-size.html[/url]

    "MySQL 3.22 had a 4GB (4 gigabyte) limit on table size. With the MyISAM
    storage engine in MySQL 3.23, the maximum table size was increased to 65536
    terabytes (2567 ? 1 bytes). With this larger allowed table size, the
    maximum effective table size for MySQL databases is usually determined by
    operating system constraints on file sizes, not by MySQL internal limits."

    Operating System File-size Limit
    Linux 2.4+ (using ext3 filesystem) 4TB



    --
    Brian Wakem
    Email: [url]http://homepage.ntlworld.com/b.wakem/myemail.png[/url]
    Brian Wakem Guest

  2. #2

    Default Re: LARGE tables in mysql-standard-5.0.18-linux-i686?

    "Ignoramus7443" <ignoramus7443NOSPAM.7443.invalid> wrote in message
    news:gvKIf.19451$Bh5.11970fe32.usenetserver.com.. .
    > While we are at it, is the BLOB size limit also removed on MySQL 5?
    The maximum data lengths for BLOB types have not changed between MySQL 4.x
    and 5.

    BLOB can store up to 2^16 bytes (64KB),
    MEDIUMBLOB can store up to 2^24 bytes (16MB),
    LONGBLOB can store up to 2^32 bytes (4GB).

    Read these pages for more details:
    [url]http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html[/url]
    [url]http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html[/url]

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. Split large tables
    By Daniel Onnen in forum MySQL
    Replies: 1
    Last Post: March 8th, 08:10 PM
  2. ColdfusionMX 7 standard and Informix support on Linux
    By CheapEnergy in forum Coldfusion Server Administration
    Replies: 0
    Last Post: February 19th, 04:08 PM
  3. Replies: 0
    Last Post: September 17th, 05:09 PM
  4. Large sites running PHP (or Apache, or MySQL, or Linux)
    By Evan Nemerson in forum PHP Development
    Replies: 0
    Last Post: August 11th, 06:13 PM
  5. MX: Standard View on, but Tables tab buttons unavailable
    By laloula webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 23rd, 03:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139