MySQL (Innodb vs MyISAM) - Printable Version +- Support Forums (https://www.supportforums.net) +-- Forum: Categories (https://www.supportforums.net/forumdisplay.php?fid=87) +--- Forum: Coding Support Forums (https://www.supportforums.net/forumdisplay.php?fid=18) +---- Forum: Database Programming (https://www.supportforums.net/forumdisplay.php?fid=28) +---- Thread: MySQL (Innodb vs MyISAM) (/showthread.php?tid=4386) Pages:
1
2
|
RE: MySQL (Innodb vs MyISAM) - Omniscient - 05-24-2010 DB restores of that size pretty much have to be done from the command line (SSH). mysql -uUSERNAME -pPASSWORD DATABASE < backup.sql That pretty much does it but of course replace with your own info. RE: MySQL (Innodb vs MyISAM) - Camgaertner - 05-24-2010 (05-24-2010, 06:19 PM)Omniscient Wrote: DB restores of that size pretty much have to be done from the command line (SSH). Thanks, I've been curious about this for a while RE: MySQL (Innodb vs MyISAM) - fabay - 08-23-2010 (01-16-2010, 06:30 PM)Omniscient Wrote: Recently I was having severe mysql problems with my biggest forum. I would have constant crashes and I tried just about everything. Thanks for the information. Looks this will sort out my problem also. Hope to get some more advise from you. I have a site www.bigbrotherafrica.com with over 29,000 members hosted on my own dedicated server with Intel Xeon 3450 (Quad Core ), and 8 GB RAM ( on this server, I also have some other sites, but with little traffic ). The site has 81,169 posts in 6,331 threads and growing . It is a fan site for big brother africa show ( a reality show in Africa ). Every year , it has 91 days show on the tv 24x7. So these 91 days are the busy days for my site. During these 3 month, normal from Monday to Friday, Africa time 9:00 am - 4:00 pm , my site has very heavy traffic. Especially on every Monday, it can get 4000-5000 visitors online same time . But other time is not very busy, it can get less than 1000 visitors online same time every 15 minutes. For last 2 weeks, I started getting too much connection errors. My server support team told me that my server is processing a significant amount of traffic, driving the load average well over 100 (under 1 is preferred): It is generating a very large number of "defunct" php processes, which are adding to this load. Database traffic is a major component of the problem: the numerous queries that are starting with "UPDATE mybb_users SET lastactive=" have locked each other for table access. at any given time, there are 150+ database interactions occurring: When I checked the server load from for admin cp page, it can be over 200.00. Most time was around 100. Currently I have around 2000 new posts daily ( at the moment, my site is always crash , it can crash 10 times a day. I have to keep restart mysql ) . Everyday, around 6-8 hours, the site has heavy traffic, other time is not much. Do you think my type of site can use your way to release the load? Will your way suit for my site? Am not a technical people. Actually I even dont know much about the server. Hope to get some advise from you. Thanks. RE: MySQL (Innodb vs MyISAM) - Omniscient - 08-23-2010 Sounds like you have enough hardware. You may want to review the changes I've made. A few optimizations would probably keep you on that server for a long time. RE: MySQL (Innodb vs MyISAM) - Splodge0007 - 03-24-2011 So, in a more rudimentary sense. You essentially changed your DB's "OS" from Windows to Linux. RE: MySQL (Innodb vs MyISAM) - developer99 - 07-22-2011 MyISAM OR InnoDB Required full text Search myISAM Require Transactions innoDB frequent select queries myISAM frequent insert,update,delete innoDB Row Locking (multi processing on single table) innoDB Relational base design innoDB Hi, I have briefly discuss this matter by table so you can conclude which has to be chosen either innodb or MyISAM. http://developer99.blogspot.com/2011/07/mysql-innodb-vs-myisam.html |