Guest KyleCannon Posted December 17, 2008 Report Share Posted December 17, 2008 I don't know about how you guys have the database set up but if you are pretty MySQL savvy switch from MyISAM to InnoDB... it does multiple transactions at once and row level versus table level locking. It will improve a lot of speed if done correctly and most likely fix the IPS Driver Error. http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html http://dev.mysql.com/doc/refman/5.0/en/innodb.html If you need more insight, I can provide it.. very savvy with PHP/MySQL. Link to comment Share on other sites More sharing options...
doug118 Posted December 17, 2008 Report Share Posted December 17, 2008 never got a pop up from this site until 2 minutes ago. when I posted a reply, about 38 new windows opened up all with the same topic and just kept coming until I ctrl+alt+delt and ended the process for iexplorer. idk if it was due to the site or just my computer acting up but my laptop is less then a week old so who knows 2001 Tahoe. Huge front stage and 55+ substage http://www.stevemeadedesigns.com/board/topic/196418-another-tahoe-build-huge-front-stage-and-155-substage/ Link to comment Share on other sites More sharing options...
Dr. Johnson Posted December 19, 2008 Author Report Share Posted December 19, 2008 Wow massive IPS Errors tonight one right after another and it sure seems like the site is taking forever to load. I hope it is a fluke. Link to comment Share on other sites More sharing options...
Guest KyleCannon Posted December 19, 2008 Report Share Posted December 19, 2008 If an admin is reading this, Repair the database and it will optimize and fix any problems with the database. Also, check out my other post. Link to comment Share on other sites More sharing options...
Torres Posted December 19, 2008 Report Share Posted December 19, 2008 I don't know about how you guys have the database set up but if you are pretty MySQL savvy switch from MyISAM to InnoDB... it does multiple transactions at once and row level versus table level locking. It will improve a lot of speed if done correctly and most likely fix the IPS Driver Error. http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html http://dev.mysql.com/doc/refman/5.0/en/innodb.html If you need more insight, I can provide it.. very savvy with PHP/MySQL. just finished a mysql class. oh how that site looks familiar i got one pop up. it was like a windows pop up, and it said 'test' so i just clicked ok and went on about my business Link to comment Share on other sites More sharing options...
Guest KyleCannon Posted December 19, 2008 Report Share Posted December 19, 2008 MySQL is so fun, you can do so many things with it Link to comment Share on other sites More sharing options...
Diablo Audio Technologies Posted December 19, 2008 Report Share Posted December 19, 2008 If an admin is reading this, Repair the database and it will optimize and fix any problems with the database. Also, check out my other post. there is no repair database option. only repair tables, and there are 100 table(s) and 728,688 records, thats gonna take a minute. steve, if you need help on repairing the db lmk Edit, i havent seen any pop up's. David Link to comment Share on other sites More sharing options...
Gq85 Posted December 19, 2008 Report Share Posted December 19, 2008 No pop ups here either but I have received the IPS error quite a few times. Link to comment Share on other sites More sharing options...
Guest KyleCannon Posted December 19, 2008 Report Share Posted December 19, 2008 never said run the repair database option... i just said repair it in general... repairing the tables will help it significantly... i have run table repairs on 500 million record tables... it takes a minute or two... or twenty (depending on your hard drive speeds and i/o load) but it will fix a lot of problems if there are inconsistencies. InnoDB is another option to help with the site slowness. Link to comment Share on other sites More sharing options...
manueltrem Posted December 19, 2008 Report Share Posted December 19, 2008 never ever had a pop up in here Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.