CODEWITHSUNDEEP
djangosqlalchemyzabbix
Fabio Ceconello
Fabio Ceconello

Reputation: 16039

How to make zabbix monitor django apps on an apache server

I have an apache server under Debian that runs several RESTful application written in Python with Django and Piston. These apps use SQLAlchemy to access data from a MySQL server. The server is monitored by Zabbix and I already have metrics for threads running, memory consumption, etc. But there are things that require a little more 'introspection', like the number of active database connections and other info about the connection pool (max and min connections, etc). I searched the web and SO and found nothing in this respect. I don't know much about SQLAlchemy (I'm just using it to make Django support connection pooling), does it have means of exposing the required information? If yes, probably what I want should be easy to implement, since there's a Python lib for Zabbix access. Any recommendations about the implementation?

Upvotes: 2

Views: 2164

Answers (1)

Joao Figueiredo
Joao Figueiredo

Reputation: 3188

Fabio,

I'm also using the Python API wrapper for deployment automation, but MySQLBix seems the most effortless way to offer you what you're looking for.

  • DBVersion (and relative validity of package)
  • Archive ( archive log production with relative trend)
  • EventWaits (monitor Files I/O,single block read, multiblock read, direct path read,SQLNet messages, Controlfile I/O,LogWrite)
  • HitRatio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
  • Logical I/O (monitor Logical I/O values of : Current Read, Consistent Read, Block Change)
  • PGA
  • SGA (in particolar: Fixed Buffer, Java Pool, Large Pool, Log Buffer,Shared Pool,Buffer Cache)
  • Physical I/O (Redo Writes,Datafiles Writes,Datafiles Read)
  • SharedPool (Pool Dictionary Cache, Pool Free Memory, Library Cache,Sql Area ,Misc.)
  • Pin Hit Ratio (monitor Hit Ratio on Trigger, Tables/Procedures, SQLArea,Body)
  • Session/Processes (monitor Sessions and processes)
  • Session (Active Session, Inactive Sessions, System Session)

Upvotes: 2

Related Questions