Website review petrunia.net
Sergei Petrunia’s blog – Obervations made while working on MariaDB's query optimizer
Generated on April 16 2026 17:19 PM
Old data? UPDATE !
The score is 50/100
SEO Content
Title
Sergei Petrunia’s blog – Obervations made while working on MariaDB's query optimizer
Length : 84
Ideally, your title should contain between 10 and 70 characters (spaces included). Use this free tool to calculate text length.
Description
Obervations made while working on MariaDB's query optimizer
Length : 59
Ideally, your meta description should contain between 70 and 160 characters (spaces included). Use this free tool to calculate text length.
Keywords
Very bad. We haven't found meta keywords on your page. Use this free online meta tags generator to create keywords.
Og Meta Properties
Good, your page take advantage of Og Properties.
| Property | Content |
|---|---|
| type | website |
| title | Sergei Petrunia's blog |
| description | Obervations made while working on MariaDB's query optimizer |
| url | https://petrunia.net/ |
| site_name | Sergei Petrunia's blog |
| image | https://s0.wp.com/i/blank.jpg?m=1383295312i |
| image:width | 200 |
| image:height | 200 |
| locale | en_US |
Headings
| H1 | H2 | H3 | H4 | H5 | H6 |
| 12 | 14 | 1 | 0 | 0 | 0 |
- [H1] Sergei Petrunia’s blog
- [H1] Using Linux perf: do we need to pass identifying info as arguments to important functions?
- [H1] Notable optimizer fixes released in February, 2024
- [H1] Optimizer-related fixes in current batch of stable releases
- [H1] Making “tbl.utf8mb3_key_column=utf8mb4_expr” sargable
- [H1] Combinatorial blowups can occur in Name Resolution, too.
- [H1] ANALYZE FORMAT=JSON now shows InnoDB buffer pool reads
- [H1] UCASE() is now sargable in MariaDB. LCASE() can’t be.
- [H1] Slides: MariaDB’s Join Optimizer: how it works and current fixes
- [H1] MariaDB 10.9: SHOW ANALYZE and EXPLAIN FOR CONNECTION
- [H1] Slides: improving selectivity estimates in MariaDB
- [H1] Posts navigation
- [H2] Obervations made while working on MariaDB's query optimizer
- [H2] MDEV-32958: Unusable key notes do not get reported for some operations
- [H2] MDEV-33118: Add optimizer_adjust_secondary_key_costs variable
- [H2] MDEV-32148: Inefficient WHERE timestamp_column = datetime_const_expr
- [H2] MDEV-29693: ANALYZE TABLE still flushes table definition cache when engine-independent statistics is used
- [H2] MDEV-31303: Key not used when IN clause has both signed and unsigned values
- [H2] MDEV-32113: utf8mb3_key_col=utf8mb4_value cannot be used for ref access
- [H2] MDEV-32351: Significant slowdown for query with many outer joins
- [H2] MDEV-32475: Skip sorting if we will read one row
- [H2] MDEV-32203: Raise notes when an index cannot be used on data type mismatch
- [H2] The issue
- [H2] Fixing it
- [H2]
- [H2]
- [H3]
Images
We found 3 images on this web page.
3 alt attributes are empty or missing. Add alternative text so that search engines can better understand the content of your images.
Text/HTML Ratio
Ratio : 15%
Good, this page's ratio of text to HTML code is higher than 15, but lower than 25 percent.
Flash
Perfect, no Flash content has been detected on this page.
Iframe
Too Bad, you have Iframes on the web pages, this mean that content in an Iframe cannot be indexed.
SEO Links
URL Rewrite
Good. Your links looks friendly!
Underscores in the URLs
We have detected underscores in your URLs. You should rather use hyphens to optimize your SEO.
In-page links
We found a total of 65 links including 1 link(s) to files
SEO Keywords
Keywords Cloud
from now analyze probe table mariadbd perf mariadb query optimizer
Keywords Consistency
| Keyword | Content | Title | Keywords | Description | Headings |
|---|---|---|---|---|---|
| perf | 15 |  |
|
|
 |
| mariadb | 14 | |
|
|
|
| query | 14 | |
|
|
|
| from | 14 | |
|
|
|
| table | 11 | |
|
|
|
Usability
Url
Domain : petrunia.net
Length : 12
Favicon
Great, your website has a favicon.
Printability
Great. We have found a Print-Friendly CSS.
Language
Good. Your declared language is en.
Dublin Core
This page does not take advantage of Dublin Core.
Document
Doctype
HTML 5
Encoding
Perfect. Your declared charset is UTF-8.
W3C Validity
Errors : 0
Warnings : 0
Email Privacy
Great no email address has been found in plain text!
Deprecated HTML
Great! We haven't found deprecated HTML tags in your HTML.
Speed Tips
|
Excellent, your website doesn't use nested tables. |
|
Too bad, your website is using inline styles. |
|
Too bad, your website has too many CSS files (more than 4). |
|
Too bad, your website has too many JS files (more than 6). |
|
Perfect, your website takes advantage of gzip. |
Mobile
Mobile Optimization
|
Apple Icon |
|
Meta Viewport Tag |
|
Flash content |
Optimization
XML Sitemap
Great, your website has an XML sitemap.
| https://petrunia.net/sitemap.xml |
| https://petrunia.net/news-sitemap.xml |
Robots.txt
https://petrunia.net/robots.txt
Great, your website has a robots.txt file.
Analytics
Missing
We didn't detect an analytics tool installed on this website.
Web analytics let you measure visitor activity on your website. You should have at least one analytics tool installed, but It can also be good to install a second in order to cross-check the data.
PageSpeed Insights
Device
Categories
Free SEO Testing Tool
Free SEO Testing Tool is a free SEO tool which provides you content analysis of the website.