Firebird Tour 2017: Performance seminars
Firebird Project,
IBSurgeon,
and
IBPhoenix are happy to announce Firebird Tour 2017: a series of seminars around the globe, devoted to the performance optimization of Firebird databases. The speakers will be Vlad Khorsun and Dmitry Yemanov (Firebird Project), Dmitry Kuzmenko (IBSurgeon), Alexey Kovyazin (IBSurgeon) and Pavel Cizar (IBPhoenix).
Here is the detailed program for Prague and Bad Sassendorf (please note that it can slightly change during next 2 weeks):
- Performance improvements in Firebird 3 and 4 – Vlad Khorsun, Firebird core developer
- CPU usage in Firebird (Details of scaling in 3.0, DSQL cache of prepared statements, Pool of external connections)
- On Disk Structure changes for performance (Primary/secondary data pages. Flag swept, SCN for nbackup)
- SQL improvements
- How to use Firebird 3.0 statistics and advanced plans to optimize SQL queries – Vlad Khorsun, Firebird core team and Dmitry Kuzmenko, IBSurgeon
- Understanding new table and index statistics elements (Tables - formats, fragments, packing, pages, blobs, blob levels, Indices - Node, key and prefix length, compression ratio, clustering factor, and how and when all of these affects performance)
- Gstat detailed statistics output and its interpretation
- Plan elements, in brief
- natural, index search, index order, sorting, joins, etc
- Old and new plan output
- Cost estimation
- Explained plan examples
- SQL optimizer improvements and their impact on performance
- Tuning Linux, Windows and Firebird for heavy workload: practical examples based on ERP with 1000+ daily users and 460Gb database – Alexey Kovyazin, IBSurgeon
- How to monitor the actual load and what it means in terms of Firebird
- CPU tuning
- Optimal memory settings
- Network tuning
- Disk performance settings
- Tips for selecting hardware
- Advanced Trace API - Vlad Khorsun, Firebird core developer
- Trace API internal implementation details
- Configuration on heavy loaded systems to avoid performance suppression
- Getting useful information from big trace logs: top slow queries, top frequent queries and more
- Automatic performance monitoring with HQBird, Alexey Kovyazin, IBSurgeon
- Complex approach MON$ + TraceAPI
- Identifying problematic transactions and related applications
- Identifying and catching problematic queries
- Temp files: sorting and other
- Database internal storage structure optimization – Pavel Cizar, Firebird QA, IBPhoenix (this session will be only in Prague)
- Firebird performance is affected by many factors. One of them is how data and indices are physically stored and distributed in the database. Right now Firebird database administrators can't significantly influence physical storage and distribution of data, so it would better match the data usage profile. This session will present one from possible ways how to fix that.
Seminars will take place:
1) in Hotel Extoll Inn, Prague (Czech Republic) at October 3, from 9-30 to 17-00
2) in Haus Düsse (Bad Sassendorf) (Germany) at October 5 - see all details here,
3) in Moscow (Russia) at November 3, Technopark "Slava" - see all details here.
Seats are limited! Book here:
- Seminar at Prague (Czech Republic), October 3, 2017 - registration completed.
- Seminar in Bad Sassendorf (Germany), October 5, 2017 - registration completed.
- Seminar in Moscow - register here.
The conference package includes attendance at the conference, materials (downloads), and appropriate meals during the seminar.
Please note that hotel accommodation is not included!
Please feel free to contact us: [email protected]