PDA

View Full Version: Rezoud VBET SEGONDÈ CPU / memwa l 'akòz MySQL



magmf
04-06-10, 13:00
Guys,

Mwen reyèlman bezwen gen plis vbet optimisé pou sit entènèt mwen an.

VBet a ap resevwa m 'yon anpil nan itilizatè nouvo Mwen vrèman renmen zouti ki Men, se lè l sèvi avèk twò anpil resous.


Chaj CPU mwen anvan VBET te begle 2 e kounye a, se pi plis pase 4 tout tan tout tan

kounye a pou egzanp
08:32:18 moute 11 jou, 2:27, 1 itilizatè, mwayèn chaj: 7,45, 8,24, 8,26

tache tikè kèk nan anvan ak apre vbet pèmèt nan sit entènèt mwen an


Mwen vle pataje ou ke mwen sote soti nan 70,000 paj Catalogue sou Google nan plis pase 500,000

ran mwen an Alexa vole tou
Anba-linux.org - Sit Info soti nan Alexa (http://www.alexa.com/siteinfo/under-linux.org)

epi mwen resevwa plis vizit chak jou men mwen toujou bezwen yon optimize pi bon sou ki jan vbet manyen ak queries.

pran yon gade sou tèt mwen an



top - 08:53:46 up 11 days, 2:49, 1 user, load average: 10.77, 9.81, 9.06
Tasks: 423 total, 5 running, 418 sleeping, 0 stopped, 0 zombie
Cpu(s): 15.7%us, 2.4%sy, 0.0%ni, 66.6%id, 9.8%wa, 0.1%hi, 5.4%si, 0.0%st
Mem: 12330536k total, 11619688k used, 710848k free, 24064k buffers
Swap: 995988k total, 994972k used, 1016k free, 2917568k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29384 mysql 20 0 5722m 2.5g 4552 S 99 20.9 3661:46 mysqld



jan ou ka wè MySQL nan tèt paske yo te vbet


MySQL montre processlist;



mysql> show processlist;
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| Id | User | Host | db | Command | Time | State | Info |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
| 3102552 | underlinux | localhost:49801 | underlinux | Query | 16 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102570 | underlinux | localhost:49843 | underlinux | Query | 12 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102597 | underlinux | localhost:49901 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102600 | underlinux | localhost:49907 | underlinux | Query | 9 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102617 | underlinux | localhost:49944 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102620 | underlinux | localhost:49953 | underlinux | Query | 6 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102632 | underlinux | localhost:49986 | underlinux | Query | 3 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102633 | underlinux | localhost:49988 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102636 | underlinux | localhost:49994 | underlinux | Sleep | 1 | | NULL |
| 3102639 | underlinux | localhost:50000 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102641 | underlinux | localhost:50005 | underlinux | Query | 0 | Sending data | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102648 | underlinux | localhost:50021 | underlinux | Sleep | 1 | | NULL |
| 3102649 | underlinux | localhost:50022 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102651 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 3102652 | underlinux | localhost:50027 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_vi WHERE originaltext='Cadastrar+200+cl |
| 3102660 | underlinux | localhost:50044 | underlinux | Query | 0 | statistics | SELECT translated FROM vbvbenterprisetranslator_cache_medium_fa WHERE originaltext='BackTrack+4+%28F |
| 3102661 | underlinux | localhost:50047 | underlinux | Query | 0 | statistics | SELECT cache.originaltext as originaltext, cache.translated as translated FROM vbvbenterprisetransla |
| 3102663 | underlinux | localhost:50051 | underlinux | Sleep | 1 | | NULL |
| 3102664 | underlinux | localhost:50052 | underlinux | Query | 1 | end | UPDATE vbuser SET
profilevisits = profilevisits + 1
WHERE userid = 61484 |
| 3102666 | underlinux | localhost:50056 | underlinux | Query | 0 | update | REPLACE INTO vbdatastore
(title, data, unserialize)
VALUES
('cron', '1275652500', 0) |
+********-+************+****************-+************+********-+****--+************--+****************************************************************************************************--+
20 rows in set (0.16 sec)

mysql>




MySQL ak itilizasyon CPU anvan ak apre vbet

http://under-linux.org/wiki/images/1/14/Mysql-vbet.png

http://under-linux.org/wiki/images/f/f0/Vbetmysql2.png

http://under-linux.org/wiki/images/6/65/Vbet-cpuusage.png

vBET
04-06-10, 14:34
Hello.

Kòm ou wrote vBET te ban nou anpil nan trafik nouvo. Se konsa, konpare CPU ak itilizasyon mem anvan ak apre vBET, se reyèlman konpare CPU ak itilizasyon mem anvan ak aprè li te fin pi gwo trafik ...
Se konsa, sa a se pa konparezon ki apwopriye yo. Pa gen okenn posibilite yo gen menm l 'resous ak pi gwo trafik yo. Epitou tanpri sonje ke vBET pratikman pa pran resous pou paj nòmal (sèlman jenere drapo) pou tout itilizasyon resous adisyonèl ou soti nan trafik an plis - trafik sou tradui paj. Plis trafik = plis resous ki nesesè

Tanpri note ke queries vBET yo optimised, yo tout gen lè l sèvi avèk endis yo epi pran tout done nan queries kèk. Tanpri tcheke queries ralanti ou louvri sesyon detèmine sa ki vrèman pran pi fò nan tan MySQL ou. Epitou - ou ka toujou rebati endis nan ka si gen yon bagay te fè aksidan nan DB MySQL ou.

Tanpri, di ki sa ki gwosè a nan tab kachèt ou a? Epitou tanpri di ki vèsyon an vBET w ap itilize epi bay URL fowòm ou.

Tanpri tcheke sijesyon pèfòmans nou an: http://www.vbenterprisetranslator.com/forum/vbet4-general-discussions/408-vbet-performance.html

Natirèlman nou yo ap amelyore vBET kontinyèlman. Nan vèsyon pwochen nou pral pi gwo sipò kachèt name:) Se konsa, amelyorasyon pèfòmans pral rive:) Toujou tanpri sonje ke konparezon fason ou li pa apwopriye epi yo pa montre konbyen lajan plis resous pran vBET - li montre kouman pi plis resous fowòm ou pran avèk ou pi gwo trafik yo.

magmf
04-06-10, 20:49
vBET,

kachèt dosye oswa MySQL ki pa queries cached sèvi ak yon anpil nan I / O fè chaj aparèy dwe segondè.

Sijesyon m 'devan ou se itilize Memcache kachèt pote olye o ak MySQL oswa konekte vbet ak vboptimise ki te deja gen sipò pou anpil kalite kachèt

egzanp vboptimise l 'ak vbet pral yon bagay tankou sa


if ($cache = vb_optimise::$cache->get('unique language key'))
{
***//use cache
}
else
{
***// get from elsewhere
***vb_optimise::$cache->set('unique language key');
}



poukisa ou Dont eseye pale ak Deceptor soti nan DragonByte Forums Tech - DragonByte Technologies Kay (http://www.dragonbyte-tech.com/)

sou sit wèb mwen, se yon ekonomize plis pase 10 milyon dola queries nan yon jounen ak vboptimise ak si ou travay avè l 'nan pi bon tout moun vbet sipò ka gen kè kontan

pran yon gade
VB Optimize - Resous Estatistik (http://www.dragonbyte-tech.com/vboptimisesites.php)

vBET
04-06-10, 21:29
Mèsi pou konsèy ou a:) mwen mete Post dènye fwa ou te nan lis todo.

Tanpri reponn kesyon yo bay - ki sa ki URL fowòm ou ak itilize vèsyon vBET. Nou vle tcheke fè ou gen ki apwopriye enstalasyon - vèsyon vBET anvan yo itilize redireksyon yo doub ki pa itilize ankò, nan ka ta gen vBSEO li mande pou entegrasyon ki apwopriye yo.

magmf
04-06-10, 21:38
url mwen an se anba-linux.org
vbet 4.2.2
vBulletin 4.0.3
vbseo 3.5 final

vBET
04-06-10, 21:49
OK - ou pa gen doub redireksyon yo ak dènye vèsyon vBET. Nan moman sa a mwen ka sèlman ba ou konsèy yo itilize sijesyon pèfòmans nou (lyen an nan reply premye) - espesyalman blòk petinan kontni nan robots.txt - paj manm tankou, kalandriye, ak kèk lòt moun (note ke moun ki pral disparèt nan paj endis yo, men li ki bon pou SEO ou yo, paske sa yo se sitou konsidere kòm repetisyon kontni).

Epitou - si sèvè ou a pral cho okipe tout lang 52 - tanpri konsidere vin enfim kèk nan sa yo. Nan moman sa a mwen konprann ke se manch li, ou jis ta gen plis kè kontan si ki gen mwens resous;)

N ap travay tou sou sipòte pa sèlman kachèt ranpli, men tou, bibliyotèk kachèt ki egziste deja:) Mèsi ankò pou allusion ou.

magmf
04-06-10, 21:58
VBET,

Mwen jis enkyete ak lavni an. Pou kounye a sou sit mwen an ka okipe men depi vbet ap travay mwen ka jwenn anpil nan itilizatè nouvo yo ak sa ka fè m 'desann sèvè: (

tou mwen deja bloke petinan kontni nan robots.txt m '

vBET
05-06-10, 20:27
Hawing anpil nan itilizatè nouvo pral fè ou panse sou nenpòt lè w gen évolutivité vBET oswa ou pa. Nou byen kontan ke yo se reyèlman vBET an, ban nou anpil nan itilizatè nouvo ak lajan yo rantre reklam ki posib:) Kòm mwen deja wrote nou pral amelyore sistèm caching:)

vBET
10-06-10, 22:45
Next lage yo pral gen tout kachèt dosye ki pral fè paj ou jenere pi vit pou envite - menm moun pa tradui:)

bhanuprasad1981
14-06-10, 18:12
Next lage yo pral gen tout kachèt dosye ki pral fè paj ou jenere pi vit pou envite - menm moun pa tradui:)

espwa nou jwenn sa a bonè:)

vBET
14-06-10, 23:11
Mwa sa a pou asire w:) konplè kachèt dosye pou envite ap travay amann sou fowòm nou an, jis vle ajoute kèk lòt fonksyonalisi nouvo:)

bhanuprasad1981
20-06-10, 17:03
nenpòt ki dènye nouvèl sou:)

vBET
21-06-10, 14:50
Jodi a nou pral gen lage pou vBET3.x - pou vBET4.x nan semèn premye nan mwa pwochen:)

bhanuprasad1981
21-06-10, 18:53
ohhh pa gen okenn jou 15 plis: (

vBET
22-06-10, 22:32
Nou gen plis fè nan ka ta gen vB4 (sipò Zanmitay URL + plis kalite tradui lyen pou VBSEO). Epitou tan sa a pral ban nou remak sou sa a fonctionnalités nouvo (sa vle di nou deja leve soti nan yon lide itilizatè yo ki pèmèt vin enfim li pou paj nòmal). Se konsa, li pral pran kèk plis tan, men nan fen a ou pral jwenn solisyon ki se pi bon teste ak ak karakteristik anplis:)

Automatic Translations (Powered by Google, Microsoft®, Yandex, SDL Language Cloud, IBM Watson and Apertium):
AfrikaansAlbanianArabicBelarusianBulgarianCatalanChineseCroatianCzechDanishDutchEnglishEstonianFilipinoFinnishFrenchGalicianGermanGreekHaitian CreoleHebrewHindiHungarianIcelandicIndonesianIrishItalianJapaneseKoreanLatvianLithuanianMacedonianMalayMalteseNorwegianPersianPolishPortugueseRomanianRussianSerbianSlovakSlovenianSpanishSwahiliSwedishTaiwaneseThaiTurkishUkrainianVietnameseWelshYiddish
Translations made by vB Enterprise Translator 4.10.1