Search found 7 matches

by Squiggles
Thu Dec 15, 2011 5:01 am
Forum: Webhosting
Topic: Adding more pages and limiting the amount shown to this list
Replies: 1
Views: 682

Adding more pages and limiting the amount shown to this list

<?php $con = mysql_connect("localhost","removed","removed"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("primary_petition", $con); $result = mysql_query("SELECT * FROM signatures ORDER BY id ASC"); echo " <br /> ...
by Squiggles
Sat Nov 12, 2011 9:25 am
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Thoughts on the latest security exploit?
Replies: 4
Views: 1348

Re: Thoughts on the latest security exploit?

Edge100x wrote:It's a scary one! Everyone should apply it ASAP.
I agree! I did as soon as I read about it, luckily it's only been noticed for a couple days.

And I wonder about that too globel..
by Squiggles
Tue Jul 26, 2011 11:15 pm
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Deadlock, mysql 5.5 with java application
Replies: 7
Views: 1741

Re: Deadlock, mysql 5.5 with java application

Splitting it wouldn't work, since the two tables share a data and they both insert it, it was executing in a weird way causing it to lag out even on my test server at home. Seeing as it normally runs perfectly fine on my test server - and two months ago I had a 2 core using the same server program w...
by Squiggles
Tue Jul 26, 2011 10:40 pm
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Deadlock, mysql 5.5 with java application
Replies: 7
Views: 1741

Re: Deadlock, mysql 5.5 with java application

He's lost as to what is causing the dead lock. His only suggestion is that the database is lagging. I'll try upgrading to mysql 5.6. Do you guys have any suggested versions that'll work best with windows server 2008 r2? Also, do you think backing up the data I have now will cause any issues with the...
by Squiggles
Tue Jul 26, 2011 10:25 pm
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Deadlock, mysql 5.5 with java application
Replies: 7
Views: 1741

Re: Deadlock, mysql 5.5 with java application

The application itself doesn't freeze - the connection does. The server freezes client sided, but the bat files (which you use to launch the server) run just fine, and are responding in taskmgr. They have no issues whatsoever - besides that of the deadlock. "Lock wait timeout exceeded, try rest...
by Squiggles
Tue Jul 26, 2011 10:10 pm
Forum: Dedicated servers and Virtual Dedicated Servers
Topic: Deadlock, mysql 5.5 with java application
Replies: 7
Views: 1741

Deadlock, mysql 5.5 with java application

Here is the InnoDB result - http://pastebin.com/RPccq2wy Basically, I'm running a game server for an MMO - and unfortunately I can't recreate the deadlock myself, so I don't know what in-game action is causing the deadlock, but the last 3 deadlocks have all revolved around the same two tables - inve...