Announcement

Announcement Module
Collapse
No announcement yet.

Com_admin_commands extremely high (90%) - what's going on?

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Com_admin_commands extremely high (90%) - what's going on?

    Total queries: 4,307,827
    Com_admin_commands: 3,754,356
    Com_insert: 37,790
    Com_select: 1,354,134
    Com_set_option: 172,319
    Com_update: 52,759
    Com_commit: 88,107

    (roughly ten hours uptime on this go, but I've had longer runs and these numbers tend to stay in proportion)

    This is a webserver, running django through apache+mod_python, on a reasonably but not that busy (10K visits/day) site.

    I've never seen Com_admin_commands so high, and I can't find any documentation that explains what it is, or why it's accounting for some 90% of my server's queries. The binlog seems to contain only the expect select/update/insert queries (many of which are less optimised than maybe they could be, but that's being worked on)

    I should point out I'm not the web developer, so I can't talk about individual queries. If I restart the database server there are thousands of 'admin commands' run within seconds of restart - even if traffic to the website is low.

    I have some experience of tuning MySQL (and I'm learning more by the hour!), and am in the process of making sure the various buffers and caches are set up to best effect, plus my web guy is optimising his queries - but I've never seen this before and it's really worrying me. 90% of all queries?!

    A complete SHOW VARIABLES, SHOW STATISTICS and my.cnf is attached. Server's a quad core opteron with 4GB of ram, 64-bit debian stable, mysql v5.0.32. All tables are MyISAM, other storage engines are disabled to keep memory footprint down.


    If anyone has any advice on what might be happening, I would really appreciate it. Thanks in advance.

  • #2
    This link has some information you might find useful as to exactly what query commands are included in this grouping. That should help you track down where in the code you have a problem.

    Hope this helps.
    -Doug

    Comment

    Working...
    X