Bukkit

What steps will reproduce the problem?
1. Use a remote MySQL server
2. Break a block
3. See the lag

What is the expected output? What do you see instead?
I would expect that the plugin would work slower because of the MySQL being on a remote location, but it slows down the entire server and not just the plugin. Block_break has a 1.5 second delay etc.
WHY does a slow MySQL connection affect the entire server instead of just the plugin? I'm already trying to get it working for at least 2 weeks, tried almost everything! Even got the server host to whitelist my website for remote access but the website still can't connect to the MySQL.

Solution to that would be using a other MySQL server, but as I mentioned it laggs the whole server to .

What version of the product are you using?
The latest one.

Do you have an error log of what happened?
No error logs, just extreme lag.

Please provide any additional information below.
auction.dimitrias.com - the webinterface files.

And I use the MySQL server of fragnet, they have whitelisted the IP of the website to connect to the MySQL but it still won't work.

Could you either explain why the site can't connect to the server even after whitelisting or is it possible to fix so that the slow connection won't affect the entire server?

Try allowing all hosts to connect to the database using "%" wildcard.

<<reply 411554>>

I did from the very beginning. So that doesn't help.

If you have any Recent or Shout signs, those require continous connection. I use an external database myself and when I removed the Recent and Shout signs it all worked like a charm.

<<reply 411826>>

What are that? Recent and Shout signs?

<<reply 411826="">>

What are Recent or Shout signs?

http://dev.bukkit.org/server-mods/webauction/#w-important-signs

Last two signs, if you don't have those within your server then ignore my comment =)

I don't have those, so the problem is something else...?

Yes, sadly I lack experience with the way this plugin works. I'll post if I think of something that might fix this for you. Meanwhile, try to get Exote to figure it out ;)

Not sure how often this plugin check for new transactions and if it does it in a separate thread.