[et_pb_section fb_built=”1″ specialty=”on” admin_label=”Section” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”0px||0px||false|false” locked=”off” global_colors_info=”{}”][et_pb_column type=”3_4″ specialty_columns=”3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_row_inner module_class=”top-row-res” _builder_version=”4.18.0″ _module_preset=”default” width=”100%” max_width=”100%” custom_padding=”23px||19px|||” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_blurb title=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoiY3VzdG9tX21ldGFfZXZlbnRfZGF0ZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIiwiZW5hYmxlX2h0bWwiOiJvZmYifX0=@” use_icon=”on” font_icon=”||fa||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Date” _builder_version=”4.18.0″ _dynamic_attributes=”title” _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” global_colors_info=”{}”][/et_pb_blurb][et_pb_blurb title=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoiY3VzdG9tX21ldGFfZXZlbnRfbG9jYXRpb24iLCJzZXR0aW5ncyI6eyJiZWZvcmUiOiIiLCJhZnRlciI6IiIsImVuYWJsZV9odG1sIjoib2ZmIn19@” use_icon=”on” font_icon=”||divi||400″ icon_color=”#00162b” icon_placement=”left” image_icon_width=”20px” content_max_width=”100%” admin_label=”Event Location” _builder_version=”4.18.0″ _dynamic_attributes=”title” _module_preset=”default” header_font=”||||||||” header_font_size=”14px” image_icon_custom_margin=”0px|0px|0px|0px|true|true” image_icon_custom_padding=”0px|0px|0px|0px|true|true” max_width=”100%” module_alignment=”left” global_colors_info=”{}”][/et_pb_blurb][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner _builder_version=”4.18.0″ _module_preset=”default” custom_padding=”0px||0px||false|false” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”3_4″ _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.19.4″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]

Dave Stokes, Percona’s Technical Evangelist, will present his talk MySQL Indexes and Histograms to Speed Up Your Queries on CakeFest 2022 on September 30th at 16:45 UTC.

Nobody complains when the database is fast. But when it slows down, you may try using an index. But then you add another and things are even slower than before. This session covers how MySQL uses the two most popular ways to increase query speed – indexes and histograms — so that you understand how they are really used, why the query optimizer does what it does, how to test your queries to see if your changes really improve things, and some other tricks. You will learn why histograms are not for data with high churn rates, why functional indexes can help with complex queries, and how to use multi-value indexes on JSON arrays. This session assumes that you have little or no experience with MySQL query tuning, indexes, or database administration. 

About the event. 

Cakefest is a virtual event dedicated to CakePHP. For the past 10 years, the framework has been a benchmark for PHP development, providing developers with a full MVC stack solution to build powerful applications which scale. This, coupled with the amazing community backing and thousands of plugins, makes CakePHP the number one choice for those who love code.

[/et_pb_text][et_pb_button button_url=”@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoiY3VzdG9tX21ldGFfZXZlbnRfbGluayIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiIiwiZW5hYmxlX2h0bWwiOiJvZmYifX0=@” url_new_window=”on” button_text=”Go to event link” admin_label=”Event Link” _builder_version=”4.18.0″ _dynamic_attributes=”button_url” _module_preset=”default” custom_button=”on” button_text_size=”14px” button_text_color=”#FFFFFF” button_bg_color=”#00162B” button_border_width=”0px” button_icon=”||fa||900″ button_icon_placement=”left” button_on_hover=”off” custom_padding=”5px|15px|5px|35px|false|false” global_colors_info=”{}”][/et_pb_button][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type=”1_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_post_title title=”off” meta=”off” admin_label=”Event Thumbnail” _builder_version=”4.18.0″ _module_preset=”default” global_colors_info=”{}”][/et_pb_post_title][/et_pb_column][/et_pb_section]