Asterisk mySql statistics database

Can some one tell me wich is the necessary MySql Database to retreive statistical information from Asterisk?

I need info like SIP package delay, line/trunks up/down, codecs used in calls, Jitter values, etc.



Asterisk is a telephone system, it job is to route calls to their destination.

Its not a voip monitoring platform, also it does not put any statistics of any type natively to any mysql database. There are addons to put the cdr records to mysql and the queue statistics to mysql.

If you want to get the info you describe you will need to write a log parser and other scripts to get this info, But this will be at the expense of what asterisk is meant to be doing, IE routing the call.