Guest KyleCannon Posted December 17, 2008 Report 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.
doug118 Posted December 17, 2008 Report 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/
Dr. Johnson Posted December 19, 2008 Author Report 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.
Guest KyleCannon Posted December 19, 2008 Report 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.
Torres Posted December 19, 2008 Report 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
Guest KyleCannon Posted December 19, 2008 Report Posted December 19, 2008 MySQL is so fun, you can do so many things with it
Diablo Audio Technologies Posted December 19, 2008 Report 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
Gq85 Posted December 19, 2008 Report Posted December 19, 2008 No pop ups here either but I have received the IPS error quite a few times.
Guest KyleCannon Posted December 19, 2008 Report 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.