| Page: 1 | Rating: Unrated [0] |
Site Downtime
| Good [+1]Toggle ReplyLink» Nuclear replied on Sun Jan 28, 2007 @ 10:55pm |
 Coolness: 2750380 | Well there seems to be a problem with the image upload script and a PHP bug. I'm going to try and figure out another way to get this working so the server stops crashing... The people who know my phone number feel free to call me when the server goes down. |
| I'm feeling relax right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Sun Jan 28, 2007 @ 11:31pm |
 Coolness: 340570 | noah sucks! |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Sun Jan 28, 2007 @ 11:40pm |
| Coolness: 2750380 | Here is the bug: [ bugs.php.net ] Update » Nuclear wrote on Sun Jan 28, 2007 @ 11:59pm I replaced:
ob_start(); imagejpeg($newHandle, '', 90); $imgData = ob_get_contents(); ob_end_clean(); With: $temp = make_cache_code(); imagejpeg($newHandle, 'data/temp/' . $temp, 90); $imgData = file_get_contents('data/temp/' . $temp); unlink('data/temp/' . $temp); Let's see if this helps stop the crashing ;) |
| I'm feeling relax right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Mon Jan 29, 2007 @ 12:29am |
| Coolness: 340570 | shoulda never switched to storing images in a database.. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Mon Jan 29, 2007 @ 12:46am |
| Coolness: 2750380 | It's better then having a million files on the server... |
| I'm feeling relax right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Mon Jan 29, 2007 @ 1:07am |
| Coolness: 340570 | million files = faster website
slower backup. meh. i'll take the faster website. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Mon Jan 29, 2007 @ 8:51am |
| Coolness: 2750380 | [ bugs.php.net ] |
| I'm feeling relax right now.. | |
| Good [+1]Toggle ReplyLink» AlienZeD replied on Mon Jan 29, 2007 @ 2:11pm |
 Coolness: 510465 | seriously! that toolbar was gone until about 12:30 today... it COULDN'T have been my fault... any clue what happened? |
| I'm feeling tuckered out right now.. | |
| Good [+1]Toggle ReplyLink» throwawayguy replied on Thu Mar 8, 2007 @ 1:26am |
 Coolness: 45735 | Neoform: learn your shit! a database *IS* faster than a million files as it will reduce IOs. At least if you have plenty of ram an the server doesn't end up swapping continuously.
I'm just wondering, is this only part or are you also handling pngs/gifs somewhere else? |
| I'm feeling very lonely right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Mar 8, 2007 @ 1:47am |
| Coolness: 2750380 | PNG, GIF is handled also, I'm not going to post all the code and bore people... |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» throwawayguy replied on Thu Mar 8, 2007 @ 7:29am |
| Coolness: 45735 | Code bores people? jezz these people sometimes :P |
| I'm feeling very lonely right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Thu Mar 8, 2007 @ 8:41am |
| Coolness: 340570 | Originally Posted By XSMURF
Neoform: learn your shit! a database *IS* faster than a million files as it will reduce IOs. At least if you have plenty of ram an the server doesn't end up swapping continuously. I'm just wondering, is this only part or are you also handling pngs/gifs somewhere else? You clearly have no idea what you're talking about. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» throwawayguy replied on Thu Mar 8, 2007 @ 1:50pm |
| Coolness: 45735 | Well you're right in the case of images. I take it back. And on second thought, files can be made pretty easy to manage too if you do something like /images/f/fi/fil/filename.jpg and store filenames and metadata in the DB. You'd want to have the filenames based on the hash of a random seed + the actual file name. This also allows you to have dedicated servers for hosting images and makes it easy to split images between different servers. Caching the thumbs in the DB seems like a good idea though. |
| I'm feeling very lonely right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Thu Mar 8, 2007 @ 3:30pm |
| Coolness: 340570 | Originally Posted By XSMURF
Well you're right in the case of images. I take it back. And on second thought, files can be made pretty easy to manage too if you do something like /images/f/fi/fil/filename.jpg and store filenames and metadata in the DB. You'd want to have the filenames based on the hash of a random seed + the actual file name. This also allows you to have dedicated servers for hosting images and makes it easy to split images between different servers. Caching the thumbs in the DB seems like a good idea though. That would be one way to do it. Noah splits them up into dirs with 5000 pictures each (before he moved them into a database). I think it's stupid to add an extra layer of work on the cpu just so that it's easy to back up.. having massive databases like that just adds more load to mysql.. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Mar 8, 2007 @ 4:19pm |
| Coolness: 2750380 | Each of my tables for images holds 5000 images max... This also means you can have images 1-200,000 on one server and 200,001,400,000 on another server... And your not having 20 gig tables... |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Thu Mar 8, 2007 @ 4:24pm |
| Coolness: 340570 | what if table 70,000 to 75,000 is the most popular? what then bitch..? |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Thu Mar 8, 2007 @ 7:11pm |
| Coolness: 2750380 | The newest ones are always the most popular ;) Now that I have ample space, I'll try to try it both ways and see how the results are. |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Thu Mar 8, 2007 @ 7:44pm |
| Coolness: 340570 | Hey! I said what IF?! |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» throwawayguy replied on Sat Mar 10, 2007 @ 12:50pm |
| Coolness: 45735 | On other point... It's a lot easier of recovery... You don't want to be browsing through a database with entries of almost several megabytes of binary data now do you? |
| I'm feeling very lonely right now.. | |
Site Downtime
| Page: 1 |
[ Top Of Page ] |
Post A Reply |
You must be logged in to post a reply.
[ Top Of Page ] |
