وردپرس

Adrotate_tracker causes MySql crash | WordPress.org


Hello,

Recently I get periodic crashes on my website. Upon investigation I saw that during the server crash there are multiple queries that are stacked.

An excerpt (truncated) from the running MySQL processes:

496146 gas_lev_gas localhost wpdb Query 145 executing SELECT timer FROM lev_adrotate_tracker WHERE ipaddress="203288032500" AND stat="i" AND
496148 gas_lev_gas localhost wpdb Query 140 executing SELECTtimerFROMlev_adrotate_trackerWHEREipaddress="2032880327600" ANDstat="i" AND
496149 gas_lev_gas localhost wpdb Query 142 executing SELECTtimerFROMlev_adrotate_trackerWHEREipaddress="2032880327700" ANDstat="i" AND
496153 gas_lev_gas localhost wpdb Query 141 executing SELECTtimerFROMlev_adrotate_trackerWHEREipaddress="2032880327600" ANDstat="i" AND
496155 gas_lev_gas localhost wpdb Query 0 update INSERT INTOlev_adrotate_tracker(ipaddress,timer,bannerid,stat) VALUES ('2032880127600
496156 gas_lev_gas localhost wpdb Query 138 executing SELECTtimerFROMlev_adrotate_trackerWHEREipaddress="2032880247800" ANDstat="i" AND
496159 gas_lev_gas localhost wpdb Query 145 executing SELECTtimerFROMlev_adrotate_trackerWHEREipaddress="203288012300" ANDstat="i" AND
496161 gas_lev_gas localhost wpdb Query 142 executing SELECT timer FROM lev_adrotate_tracker WHERE ipaddress="2032880327700" AND stat="i" AND
496164 gas_lev_gas localhost wpdb Query 143 executing SELECT timer FROM lev_adrotate_tracker WHERE ipaddress="203288012500" AND stat="i" AND `

Any intel is much appreciated

Thank you,
Kostas

پایان/ مرجع وب و فناوری

مشاهده پاسخ های این مطلب
———————————————
این مطلب از سایت انجمن وردپرس گردآوری شده است و کلیه حقوق مطلق به انجمن وردپرس می باشد در صورت مغایرت و یا بروز مشکل اطلاع دهید تا حذف گردد

منبع: انجمن وردپرس

دکمه بازگشت به بالا