DEPRECATION WARNING
This documentation is not using the current rendering mechanism and is probably outdated. The extension maintainer should switch to the new system. Details on how to use the rendering mechanism can be found here.
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 |
EXT: TYPO3 profiler - typo3profiler
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¶
`Introduction 3 <#__RefHeading__288_1004808977>`_
`Users manual 7 <#__RefHeading__316_1004808977>`_
`Known problems 8 <#__RefHeading__318_1004808977>`_
`To-Do list 9 <#__RefHeading__320_1004808977>`_
Introduction¶
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¶
The two modules :
The page generation (log 1 time for each page to avoid large log table) :
The queries (default to 100 slowest) :
Users manual¶
Install the “typo3profiler” extension and configure it int the Extension manager section.
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¶
None