[NaterGator]

Also, good bump of this thread. Help and advice is still free, despite the economy

[NaterGator]

Bump Again.

I created a Firefox extension today that seamlessly transloads images from other websites directly to imageshack without actually rendering their page, and copies the direct link to the imageshack mirror of the image to the clipboard.

Tentatively you can get it here if you have a Mozilla account (still in the sandbox):
https://addons.mozilla.org/en-US/firefox/addon/9264
http://nate-online.com/install_transloader.html (alternatively: here is a direct install link on my domain, no signup required)

I'm going to write a page in a sec and put it on my domain to make it easier until it's out of the Mozilla sandbox (if it ever makes it out). Anyways, it's pretty simple. When you right click on an image, you'll see "Transload to ImageShack..." just click that and watch in your status bar and it will show you imageshack's progress. Once it says it's good to go, you simply paste the image URL where you need it. (Usually wrapped in [img][/img] tags inside a post)

Ex image:


Enjoy, now you have no excuse for getting caught hotlinking, because now it's equally easy to transload

Oh, I've only tested it against my Firefox (3.0.3) so if you are using another version (especially 2.0.0.*) let me know if it works; if not I'll patch accordingly.

[Tapage]

Hello Nater .. old thread ..

I was dealing with bluehost past 4 days with pourly server performance .. since it's a shared server they told me that they will check if it's other user messing out the server.

Long story short they block my account due to slow mysql queries .. but my DB it's barely 60 MB .. !

The best part it's I perform a repare and optimice on my forum tables ( vBulletin ) but since they don't allow me get in I can't test it ..

Well that's not the issue here ..

Did you ave any experience with those mysq slow queries issue .. ?

And if I decide choose another hosting Co . . which you recomend with the same shema ..? ( price, space etc .. )

thanks dude .. !

[TJDIV]

Originally Posted by Junk

[warning] Junk will be needing mucho help in the near future [/warning]

You seem like an iWeb kinda guy.

[bpassmore]

Originally Posted by Tapage

Hello Nater .. old thread ..

I was dealing with bluehost past 4 days with pourly server performance .. since it's a shared server they told me that they will check if it's other user messing out the server.

Long story short they block my account due to slow mysql queries .. but my DB it's barely 60 MB .. !

The best part it's I perform a repare and optimice on my forum tables ( vBulletin ) but since they don't allow me get in I can't test it ..

Well that's not the issue here ..



Did you ave any experience with those mysq slow queries issue .. ?

And if I decide choose another hosting Co . . which you recomend with the same shema ..? ( price, space etc .. )

thanks dude .. !

Try Media Temple:
(mt) Media Temple - Web Hosting Built to Scale.

i host several dozen site, all of them use DB access, and I use the lowest plan. no speed issues.

[NaterGator]

I do not like mediaTemple that much, I use them for a few corporate sites I manage. They have good ping times (= strong routes to major backbones) but their service is only and their prices are double .

Personally I like dreamhost for non-essential (like: my financial well-being does not depend entirely on the site's 99.999% uptime) quality shared hosting: right now it's unlimited storage and unlimited throughput for ~$10/mo. Their mysql servers implement query caching which may help you; not sure how your forum is setup though. Dreamhost is very forward about what their are doing and the status of their network (something that makes them seem less reliable, but in actuality other hosts widely have the same problems, they just don't report them). They do like to implement less hardened apps and optimizations which can sometimes take you offline, but most of the time you have to sign up to pilot such programs (where most of the problems happen. For ex: I signed up to be moved to a brand new set of servers in a pilot program and my site was offline for about 8 hrs due to a scripting glitch. None the less it wouldn't have happened if I didn't opt-in, but my hosting package got upgraded for free as a result of my willingness to participate. Doesn't bother me!)

There are some important considerations though: are specific queries running slowly? Have you modified the vBulletin "standard" package at all (any mods or add-ins? if so, what)? There are many various reasons why a server will perform slowly, but MySQL can be finicky and you must strive for a highly normalized database.

I think the first thing I'd determine is to run some control queries outside of the actual vBulletin source to determine how long they take to execute and if you can pinpoint a specific problem. Also, see if you can get the load averages from the mysql server; obviously if they are too high you know your host is overselling their capacity.

[Tapage]

thanks for all comments ..

Now ( few hours ago ) they allow me back to the bussiness .. no big deal, I perform a maintenance procedure that it's in theyr cpanel and other onto my vBulletin .. everithinks come ok ..

I have few hacks ( but are not new ) on my forum .. simple things like youtube embeded videos and automatic reduction for big pics that user paste onto the forum ..

thay was working nice from at least year ago ..

Now I'm up again running no hacks ( or all disabled on my config.php ) and seems to be good ..

I will keep as is for a few days and then start to enable hack by hack ..

[Tapage]

this it's a part of the log .. it tell you somethig . ?

# Thu Dec 11 00:03:42 2008
# Query_time: 3 Lock_time: 0 Rows_sent: 2 Rows_examined: 2
use fouxfoup_foro;
SELECT COUNT(*) AS count, threadid, MAX(dateline) AS lastpost
FROM post AS post
WHERE post.userid = 70 AND
post.visible = 1 AND
post.threadid IN (0,1429,1434,1427,1428,1418,1426,1411,1388,1403,13 60,1364,1371,1375,1245,1370,1362,1354,1349,1339,13 47)
GROUP BY threadid

# Thu Dec 11 00:03:49 2008
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 4
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'emailbody'
AND varname = 'birthday'

# Thu Dec 11 00:04:09 2008
# Query_time: 18 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('birthday',
1228979024,
'Jaime A',
1)

[yooper]

Nate the transloader needs updating. Firefox 3.5.2 says it's incompatible and won't let us use it...

[NaterGator]

Hrm... I shall double check this.

[NaterGator]

[NaterGator]

You'll need to wait for AMO to propagate the changes, but I have updated V1.1.9 to work with FF3.5.2
https://addons.mozilla.org/en-US/fir.../versions/9264

[yooper]

Originally Posted by NaterGator

You'll need to wait for AMO to propagate the changes, but I have updated V1.1.9 to work with FF3.5.2
https://addons.mozilla.org/en-US/fir.../versions/9264

awesome, thanks! I'll watch for it...

EDIT: working fine



!

[raydouble]

Thanks

[TJDIV]

Can you fix stupid?

Like when I just want to install Wordpress using fantastico's idiot proof option and somehow break your whole site...as in, no recent backup....

Me = Idiot. Just when you get comfortable doing something....



*edit: backup complete