Recent changes
Wednesday November 04 2026
-
Database FAQ Updated Markdown page
Short answers to the questions database administrators ask most about Exponential - which engine, is SQLite really enough, which privileges, where the password is, how to back up and upgrade, replicas, clustering, SQL…
-
Checklists for database administrators Updated Markdown page
Printable checklists for the database of an Exponential site - before an install, go-live, daily, weekly and monthly operations, before and after an upgrade, a restore, an engine move and a security review - each item…
-
A reading path for database administrators Updated Markdown page
The order in which a database administrator new to Exponential reads these pages - a first hour, a first day, then the pages for your engine and the pages for operations, upgrades and incidents - with the time each step…
-
Database error codes and messages Updated Markdown page
How Exponential reports database errors - the engine's own error number in errorNumber() and in eZDBException, the codes for a duplicate key and a missing table on each driver, the exception classes, standard versus…
-
Finding slow queries Updated Markdown page
The tools Exponential gives a database administrator to find slow and repeated SQL - SQLOutput and SlowQueriesOutput in the debug output, MySQL's EXPLAIN through QueryAnalysisOutput, DebugTransactions, the SQL profiler…
-
Glossary for database administrators Updated Markdown page
The Exponential terms a database administrator meets, explained in a sentence each with a link - from .dba, alias and cluster to siteaccess, update file, WAL and writer lock.
-
Housekeeping: cronjobs and queue tables Updated Markdown page
The cronjobs that keep an Exponential database tidy and its queues moving - the parts of settings/cronjob.ini and what each script does to the database, the scripts no shipped part runs (session_gc.php, trashpurge.php…
-
Microsoft SQL Server: status for DBAs Updated Markdown page
Where Microsoft SQL Server stands for Exponential 6.0.x - not supported, known to be possible with additional work - what exists that such work could build on (the driver interface, the .dba format, pluggable schema…
-
Setting up MongoDB Updated Markdown page
How to prepare MongoDB for an Exponential site - the requirements, a user created in the site's own database with readWrite and dbAdmin, why a user is required even without access control, the settings block, the…
-
Monitoring the database Updated Markdown page
What to monitor on the database of an Exponential site and where to read it - the Database card of Setup > System information, exp:system:info for scripts and alerts, the log files and the patterns that matter, the…
-
Moving a site to another engine Updated Markdown page
How to move an existing Exponential site from one database engine to another - planning the maintenance window, the .dba dump and insert between SQL engines, the ezoracle transfer commands into Oracle, the bin/mongodb…
-
MySQL and MariaDB: utf8mb4, the connection charset and InnoDB Updated Markdown page
The character set and storage engine details of Exponential on MySQL and MariaDB - why the database should be utf8mb4 while the connection uses utf8 (utf8mb3), what the charset warning means and how to see it…
-
Setting up MySQL and MariaDB Updated Markdown page
How to prepare MySQL or MariaDB for an Exponential site - a utf8mb4 database, an account with per-database privileges only, the settings block with host, port or socket, the console install, and what differs between…
-
MySQL and MariaDB read replicas Updated Markdown page
How Exponential sends read queries to MySQL or MariaDB replicas with UseSlaveServer and the SlaveServer and SlaverServer keys, how a replica is chosen, what replication lag means for editors and visitors, and what the…
-
Oracle: persistent connections, DRCP and tuning Updated Markdown page
The connection and performance settings of the ezoracle extension - persistent connections, Database Resident Connection Pooling, keep-alive for long-running workers, failover over several listeners, retries and call…
-
Oracle maintenance commands and cronjobs Updated Markdown page
The maintenance tools the ezoracle extension gives an Oracle DBA - the ext:ezoracle console commands (health, gather-stats, recompile, purge-recyclebin, sequence-sync, schema-diff, indexes, report, datapump…
-
Setting up Oracle with ezoracle Updated Markdown page
How to prepare Oracle Database for an Exponential site with the ezoracle extension - requirements (19c or later, AL32UTF8, oci8 and an Oracle client), the grants printed by ora-grant.php, the connect string forms, the…
-
Performance and scaling Updated Markdown page
How the load of an Exponential site reaches its database and how to scale it - the cache layers that keep most requests away, what still reaches the database, persistent connections and Velocity's persistent workers…
-
PHP extensions per engine Updated Markdown page
Which PHP extension each database needs (sqlite3, pgsql, mongodb with its Composer library, mysqli, oci8), where it comes from on the common Linux families, how the setup wizard checks it, and how to confirm that the…
-
Reviewing extension SQL for every engine Updated Markdown page
A database administrator's checklist for reviewing the SQL of an Exponential extension before it goes onto a site that does not run MySQL - backticks, table aliases, driver helpers, MySQL session statements, empty…