gan tulungin dunk, hosting sy suspend web krna load aktifitas dari database presta

[AudioJakarta]

gan tulungin dunk, web ane disuspend krna load aktifitas dari database presta tinggi

Dengan hormat,

Kami dapati adanya load aktifitas dari database Anda yang tinggi sehingga menyebabkan service MySQL di server down. Berikut kutipan hasil pemeriksaan kami:

...
| 6927458 | h17368_shop1 | localhost | h17368_prestashop | Query | 58 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927462 | h17368_shop1 | localhost | h17368_prestashop | Query | 59 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927463 | h17368_shop1 | localhost | h17368_prestashop | Query | 57 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927466 | h17368_shop1 | localhost | h17368_prestashop | Query | 55 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927469 | h17368_shop1 | localhost | h17368_prestashop | Query | 49 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927470 | h17368_shop1 | localhost | h17368_prestashop | Query | 54 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927471 | h17368_shop1 | localhost | h17368_prestashop | Query | 53 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927474 | h17368_shop1 | localhost | h17368_prestashop | Query | 47 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927481 | h17368_shop1 | localhost | h17368_prestashop | Sleep | 1 | cleaning up | |
| 6927491 | h17368_shop1 | localhost | h17368_prestashop | Query | 40 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927496 | h17368_shop1 | localhost | h17368_prestashop | Query | 35 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927497 | h17368_shop1 | localhost | h17368_prestashop | Query | 27 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927501 | h17368_shop1 | localhost | h17368_prestashop | Query | 34 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927502 | h17368_shop1 | localhost | h17368_prestashop | Query | 29 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927506 | h17368_shop1 | localhost | h17368_prestashop | Query | 29 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927508 | h17368_shop1 | localhost | h17368_prestashop | Query | 27 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927511 | h17368_shop1 | localhost | h17368_prestashop | Query | 22 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927514 | h17368_shop1 | localhost | h17368_prestashop | Query | 24 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927515 | h17368_shop1 | localhost | h17368_prestashop | Query | 25 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927516 | h17368_shop1 | localhost | h17368_prestashop | Query | 19 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927520 | h17368_shop1 | localhost | h17368_prestashop | Query | 21 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
| 6927522 | h17368_shop1 | localhost | h17368_prestashop | Query | 15 | Copying to tmp table | SELECT cp.`id_connections`
FROM `ps_connections_page` cp
WHERE cp.`time_end` IS NULL
AND TIME_ |
...

Oleh karena itu, kami terpaksa menonaktifkan sementara akun Anda sampai dengan kondisi server kembali normal. Untuk selanjutnya, bila Anda ingin memeriksa aplikasi Anda, silahkan reply tiket ini agar kami bisa enable kembali.

Atas perhatian dan kerjasamanya kami ucapkan terimakaish.

ini masalahnya dimana ya gan, apa ada yang pernah mengalami, sy pake versi terdahulu, awal awal gan, blm sempet upgrade sih, thanks

[array064]

gan tulungin dunk, web ane disuspend krna load aktifitas dari database presta tinggi

Module apa saja yang digunakan?

Saran sementara: segera upgrade ke prestashop terbaru.

[AudioJakarta]

gan tulungin dunk, web ane disuspend krna load aktifitas dari database presta tinggi

Module apa saja yang digunakan?

Saran sementara: segera upgrade ke prestashop terbaru.

module standar gan, banyakan modul buatan sendiri
iya mo upgrade dulu ke yang baru aja

[array064]

module standar gan, banyakan modul buatan sendiri
iya mo upgrade dulu ke yang baru aja

Kalau dah diupgrade, kasih tahu hasilnya gan. Tetap disuspend atau dah oke.

[prestanesia]

kalo liat dari dump diatas itu dari modul statistic, FYI, kalo ga dipake mending diuninstall aja modul statistiknya - trus pake google analytic misalnya. kyknya bakal bantu save db space ma proses deh.

[array064]

Iya, kayaknya modul statistic deh. Karena table yang jadi masalah adalah table "ps_connections_page".

[catur priyo]

segera antisipasi nich.. thx gan usul nya :coolhmm:

[mitraiaku]

berarti bukan masalah suspend hosting nya ya...
tapi karena masalah di modulnya...

okeh2.. nambah ilmu baru gan..