We are having technical difficulties please stand by AGD

[hitech]

Originally posted by Rich
It's not the forum software, but a database limitation for the size of the tables. The attachment table is at the largest that it can be. I am working with Mr. AGD himself to get this resolved.

[shameless plug]
You should have used an AS/400 (iSeries)
[/shameless plug]

[jayloo]

Re: Hosting Pictures

Originally posted by StygShore
Anyone have a machine they could use to host pictures for AGD? Then we can just use hyperlinks to the pictures for our posts?

Styg

This is not a software problem (neither PHP, OS or Apache) it is a size limitation of a table in MySQL problem. I am sure the field in the table in question is a longblob (a datatype capable of storing binary data). This is a preferred method of storing MANY files like images. You can put the file on the OS but you dill destroy your file access times because of the MANY number of files. Putting the files on the HD is a huge mistake for your dedicated server.

Contact the vBullitin folks and see hat they say, I am sure this is not the first time this has happened to someone. Or hack the vBullitin code and find a way to spread out the attachments over multiple tables. This is the point where a great FREE product like MySQL can't compete with Oracle. But oracle and its admin comes with a HUGE price.

BTW, I am a webmaster, Oracle DBA and Unix Sysadmin for a fortune 500 company. I am not bragging (I don't get paid crap) I just know a thing or 2 about Unix and databases.

[SuiciDal Sn Y p ER]

official hot girls
official automags pics
My pictures thread

i think those threads have over 100 pics on em

[hitech]

Re: Re: Hosting Pictures

Originally posted by jayloo

This is the point where a great FREE product like MySQL can't compete with Oracle. But oracle and its admin comes with a HUGE price.

DB2/400 comes "free" with the AS/400 (iSeries) and has VERY LOW admin costs.

[shameless plug]
Should have used an AS/400.
[/shameless plug]

[Rich]

If the server interface was updated to support mysql 4.2 we could switch the table type to InnoDB and bypass the 4.0 gb limit. But that's just another boatload of stuff to work on.

What I'm working on doing (and will result in more down time) is upgrading the forums to vbulletin version 3.0 and then switching the attachments to a file based storage method with database links and we won't have this problem (until they really fill up the hard drive)

[cphilip]

(cphilip goes to get another beer while the geeks talk amongst themselves of things he does not understand...)

[jayloo]

Originally posted by Rich
If the server interface was updated to support mysql 4.2 we could switch the table type to InnoDB and bypass the 4.0 gb limit. But that's just another boatload of stuff to work on.

What I'm working on doing (and will result in more down time) is upgrading the forums to vbulletin version 3.0 and then switching the attachments to a file based storage method with database links and we won't have this problem (until they really fill up the hard drive)

Yeah but won't you have bigger problems with file access times since you will have MANY small files on a filesystem?

[WARPED1]

Upgrade to the lates vb. I think it's 3. Angel-owners.com uses it so yall can see it.

[1stdeadeye]

Techno-Geek to english Translations please?

[WARPED1]

This is a vbulletin board, version like 2. 6 or something. Many vb boards have upgraded to version 3, maybe it'll fix any problems...............

[jayloo]

Um, computers have limits. Hardware and software, in this case you have many pieces to the AO puzzle. To run vBullitin you need a database (MySQL) and something to access the database (apache - web server and PHP - programming language used to access the database and make dynamic web pages).

The weak link here is the database. There is a limit on a single table size and I believe it is 4G. Hope this helps

For the geeks here this is a description from netcraft about the AO server....

Apache/1.3.26 (Unix) mod_perl/1.26 mod_throttle/2.11 PHP/4.1.0 FrontPage/4.0.4.3 mod_ssl/2.8.9 OpenSSL/0.9.6f

[cphilip]

V2.2.5 is what we running. We had it a while though. Times change.

[jayloo]

This has little to nothing to do with the software (vBullitin) and everything to do with the database (MySQL). Change the database and all could be good.

[cphilip]

Thats partialy the case Jayloo. As I understand it. Maybe easier said than done but yea...

[WARPED1]

Git it.............sorta.