.. You may want to use the usual include line. Uncomment and adjust the path. 
.. include:: ../Includes.txt


===================
EXT: TYPO3 profiler
===================

:Created:
      2010-02-18T17:33:18

:Changed by:
      Yohann CERDAN

:Changed:
      2011-03-12T17:54:29.870000000

:Classification:
      typo3profiler

:Description:
      The keywords help with categorizing and tagging of the manuals. You can combine two or more keywords and add additional keywords yourself. Please use at least one keyword from both lists. If your manual is NOT in english, see next tab "language" ---- forEditors (use this for editors / german "Redakteure") forAdmins (use this for Administrators) forDevelopers (use this for Developers) forBeginners (manuals covering TYPO3 basics) forIntermediates (manuals going into more depth) forAdvanced (covering the most advanced TYPO3 topics) see more: http://wiki.typo3.org/doc_template#tags ----

:Keywords:
      profiling, mysql, typoscript

:Author:
      CERDAN Yohann

:Email:
      cerdanyohann@yahoo,fr

:Info 4:


:Language:
      en


|img-1| |img-2| EXT: TYPO3 profiler - typo3profiler


.. _EXT-TYPO3-profiler:

EXT: TYPO3 profiler
===================

Extension Key: typo3profiler

Language: en

Keywords: profiling, mysql, typoscript

Copyright 2000-2011, CERDAN Yohann, <cerdanyohann@yahoo,fr>

This document is published under the Open Content License

available from http://www.opencontent.org/opl.shtml

The content of this document is related to TYPO3

\- a GNU/GPL CMS/Framework available from www.typo3.org

.. _Table-of-Contents:

Table of Contents
-----------------

`EXT: TYPO3 profiler 1 <#__RefHeading__286_1004808977>`_

**`Introduction 3 <#__RefHeading__288_1004808977>`_**

`What does it do? 3 <#__RefHeading__290_1004808977>`_

`Screenshots 4 <#__RefHeading__296_1004808977>`_

**`Users manual 7 <#__RefHeading__316_1004808977>`_**

**`Known problems 8 <#__RefHeading__318_1004808977>`_**

**`To-Do list 9 <#__RefHeading__320_1004808977>`_**


.. _Introduction:

Introduction
------------


.. _What-does-it-do:

What does it do?
^^^^^^^^^^^^^^^^

This module allows you to store slower queries and parsetimes of page
generation. Use it with no\_cache to have more accurate informations
about the page generation and to call all the queries. You don't need
to have an external program or a specific MySQL version.

With this module you can easily locate and optimize the longer process
on your website.

You can see the slowest queries with reference to the extension and
follow the page generation with a copy of the admin panel.

**Note :** thank to the extension “mysqlprofiler “ for the example of
the XCLASS on the T3\_DB that have inspired me :-)


.. _Screenshots:

Screenshots
^^^^^^^^^^^

The two modules :

|img-3|

The page generation (log 1 time for each page to avoid large log
table) :

|img-4|

|img-5|

The queries (default to 100 slowest) :

|img-6|


.. _Users-manual:

Users manual
------------

Install the “typo3profiler” extension and configure it int the
Extension manager section.

|img-7|

You can choose :

- to enable or not the profiling (it is not advised to let it enabled
  all the time)

- the type of queries to profile

- the tables to exclude when profiling (like the cache\_\*)

- How many slower queries you want to log on each page

- How many slower queries you want to log in the module

It is much interesting to use this extension in a no\_cache mode (to
call all the methods). For example, you can put your browser in
“pragma no cache” or put “config,no\_cache=1” in typoscript. It is not
an obligation but with the cache the USER extension are not called.


.. _Known-problems:

Known problems
--------------

None


.. _To-Do-list:

To-Do list
----------

If you have some ideas/improvements, contact me!

|img-2| 9


.. ######CUTTER_MARK_IMAGES######

.. |img-1| image:: img-1.png
.. :align: left

.. |img-2| image:: img-2.png
.. :border: 0
.. :height: 21
.. :hspace: 9
.. :id: Grafik2
.. :name: Grafik2
.. :width: 87

.. |img-3| image:: img-3.png
.. :align: left
.. :border: 0
.. :height: 78
.. :id: images1
.. :name: images1
.. :width: 187

.. |img-4| image:: img-4.png
.. :align: left
.. :border: 0
.. :height: 471
.. :id: images11
.. :name: images11
.. :width: 491

.. |img-5| image:: img-5.png
.. :align: left
.. :border: 0
.. :height: 553
.. :id: images14
.. :name: images14
.. :width: 537

.. |img-6| image:: img-6.png
.. :align: left
.. :border: 0
.. :height: 625
.. :id: images15
.. :name: images15
.. :width: 594

.. |img-7| image:: img-7.png
.. :align: left
.. :border: 0
.. :height: 335
.. :id: images2
.. :name: images2
.. :width: 524