Merhaba arkadaşlar benim 1,5 gb ramli yüksek özellikli kullandığım bir vps var bu vps'yi uzun zamandır kullanıyorum ve sitemde 4-5 tane site var ve toplam hitleri 1k'yı bile geçmez önceden günlük 25k idi toplamda o sürede hiç bir şekilde ram yetmezliği yapmıyordu. Olay şöyle gerçekleşiyor sitelerim arasında 2 adet smf kurulu forum sitem birisinin üye sayısı 115k birisi 12k falan 115k'lık sitem durduk yere bazen öyle bir sorgu yapıyor ki tek başına ram'in tamamını kullanıyor ve ram tavan yapıp vps'yi kilitliyor. Bu kilitleme de diğer siteler açılıyor bu sitenin açılması bazen 8-9 dakikayı buluyorç Mysql'i durdurup tekrar başlatmadan düzelme yapmıyor yapıyorsa bile ram'in geri boşalması 15 dakikayı geçiyor. Önceden böyle birşey yoktu hitler yüksek iken vps kaldırıyordu da şuan hitlerim düştü neden böyle bir ani artış oluyor sitede gereksiz tüm modifikasyonları kaldırdım sildim mysql'i 1,2 gb'den 400mb'ye kadar indirdim ama bir türlü düzeltmedim.
SMF 1.0.12 / 1.1.4 / 2.0 b1.1 Update 1.0
Karma Description Mod 2.3
Custom Profile Field Mod 3.16
Move Old Topics 1.0
Googlebot & Spiders Mod 2.0.3
Profile Comments 1.2.1
SMF Gallery Lite 1.8.3
Custom Action Mod 2.04
SMF 1.0.13 / 1.1.5 / 2.0 b3.1 Update 1.0
SMF Sitemap 1.2.1
Banner Mod 1.2 1.2
Registered Copy 1.0
Member List Position Filter 1.0.0
Member Color Link 2.0.0
Expand Pages Mod 1.0
Who Voted What? 1.1
Contact Page 1.1
Limit A Guests Daily PageViews Mod 1.0
Thank-O-Matic Add On: Karma 1.0.0
Auto Email Inactive Ordinary Users 1.6
Seo 4 SMF 0.2.9.9
SSI Membergroup 1.0
Kategori Reklam 1.0
Board Viewers Mod 1.0
ShowTopics 1.1
Tagging System 1.0.3
SMF Ajax Kayıt Modu 1.0.0 TR
Post_As_An_Alternate_User 2.0
User Control Panel By Alan S 1.2
AJAX Instant Quick Reply 1.0.1
Global Announcements 1.0
Registered Links 1.0
ssi_boardNews Multiple Boards 1.0
boardicon1.1 1.1
Allowed Groups Embedded Flash 1.2.3
Profil Moderator Managment 1.0.0
Select All And Copy Code To Clipboard 1.2
User Email System 1.3
GoogleTagged 1.2
SMFShop 3.0
Change_All_Subjects 1.0
VisualWarning Türkçe Yaması 1.29
Hide SMF Version 1.0.1
VisualWarning
Sitemde kurulu modlar bunlar forum scripti Smf 1.1.5 ne yapmam gerekir arkadaşlar ne önerirsiniz.
Site tavan yaptığında aşağıdaki gibi fazlası ile sorgu yapıyor.
8668 433 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8669 433 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8667 434 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8658 445 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8649 454 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8647 455 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8642 466 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8636 474 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8634 477 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8633 480 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8632 488 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8621 492 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8622 492 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8618 507 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8615 516 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8606 524 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8603 529 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8602 537 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8601 540 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8600 543 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8597 550 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8596 557 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8592 564 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8590 571 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8586 579 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8581 585 Query SELECT COUNT(DISTINCT t.ID_TOPIC) FROM smf_topics AS t, smf_googletagged as g W
8576 593 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
8573 599 Query SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, IFNULL(mem.r
8571 603 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
550 10 Query UPDATE smf_topics SET numViews = numViews + 1 WHERE ID_TOPIC = 11076 LIMIT 1
542 20 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
544 20 Query SELECT ID_FIRST_MSG FROM smf_topics WHERE ID_BOARD = 32 ORDER BY ID_FIRST_MSG D
540 21 Query SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, IFNULL(mem.r
534 31 Query UPDATE smf_topics SET numViews = numViews + 1 WHERE ID_TOPIC = 11076 LIMIT 1
524 41 Query SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, IFNULL(mem.r
528 41 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
519 48 Query DELETE FROM smf_log_search_results WHERE ID_SEARCH = 179
513 52 Query UPDATE smf_topics SET numViews = numViews + 1 WHERE ID_TOPIC = 11076 LIMIT 1
511 56 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
506 62 Query SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, IFNULL(mem.r
507 62 Query SELECT m.subject, t.numReplies, b.name, b.ID_BOARD, m.ID_BOARD FROM smf_message
508 62 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
503 68 Query DELETE FROM smf_log_search_results WHERE ID_SEARCH = 178
500 73 Query UPDATE smf_topics SET numViews = numViews + 1 WHERE ID_TOPIC = 11076 LIMIT 1
498 76 Query SELECT ID_FIRST_MSG FROM smf_topics WHERE ID_BOARD = 32 ORDER BY ID_FIRST_MSG D
486 90 Query DELETE FROM smf_log_search_results WHERE ID_SEARCH = 177
482 94 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
469 109 Query DELETE FROM smf_log_search_results WHERE ID_SEARCH = 176
456 115 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
442 129 Query SELECT ID_FIRST_MSG FROM smf_topics WHERE ID_BOARD = 32 ORDER BY ID_FIRST_MSG D
440 131 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
435 136 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
415 155 Query SELECT m.posterTime, m.subject, m.ID_TOPIC, m.ID_MEMBER, m.ID_MSG, IFNULL(mem.r
414 157 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
408 159 Query SELECT c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups, b
401 176 Query SELECT t.numReplies,t.numViews,m.ID_MEMBER,m.posterName,m.subject,m.ID_TOPIC,m.
396 179 Query UPDATE smf_topics SET numViews = numViews + 1 WHERE ID_TOPIC = 11076 LIMIT 1