• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Lag Attack in LINUX. (mysql)

D

denoxin

New Member
Joined
Jun 4, 2011
Messages
9
Reaction score
0
Hello, my server lags and kicks are suffering due to a binder of some enemies.

I use "proc mysqladmin-u root" command
To see what mysql is suing, and the result is below.
This lag is caused because mysql gets to use 700% of cpu.

Can someone help me?


-------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------------+-------+---------+------+-------+---------
| 374723 | root | localhost:44510 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374724 | root | localhost:44512 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374725 | root | localhost:44514 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374726 | root | localhost:44516 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374727 | root | localhost:44518 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374728 | root | localhost:44520 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374729 | root | localhost:44522 | ideal | Query | 0 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`nam |
| 374730 | root | localhost:44524 | ideal | Query | 14 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374731 | root | localhost:44526 | ideal | Query | 13 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374732 | root | localhost:44528 | ideal | Query | 13 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374733 | root | localhost:44530 | ideal | Query | 12 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374734 | root | localhost:44531 | ideal | Query | 12 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374735 | root | localhost:44534 | ideal | Query | 12 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374737 | root | localhost:44537 | ideal | Query | 11 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
`g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`na |
| 374736 | root | localhost:44536 | ideal | Query | 11 | Copying to tmp table | SELECT `g`.`id` AS `id`, `g`.`name` AS `name`,
 
Last edited:
Back
Top