Minimized, Cleaned, Formatted (spaces/no tabs) and removed schema name from all database object names in each of the 27 development scripts. MySQL/MariaDB specific code and version improvements. Processing is twice as fast in MariaDB on both Ubuntu and Windows. MySQL screams on MacOS with Apple silicon ARM64 processors. Did not install MariaDB on MacOS.
- [3.3.1] stripped schema name from all qualified database object names in
apache_logs_schema.sql
to minimize code and make transition to different schema name if required easier. - [3.3.1] MariaDB and MySQL version-specific code implementation using - /M!100500 and /!50700 for index creation and adding system variables MySQL @@server_uuid and MariaDB @@server_uid.
- [3.3.1] increased column widths for LOAD TABLES -
first_line_request
,req_uri
,req_query
and decreaseduseragent
to handle LimitRequestLine 8190 - https://httpd.apache.org/docs/2.2/mod/core.html#limitrequestline' - [3.3.1] increased column width from 2000 to 5000 for TABLE
access_log_reqquery
and modified FUNCTIONaccess_reqQueryID
increased in_ReqQuery VARCHAR(2000) to VARCHAR(5000)