Recent changes
Wednesday November 04 2026
-
Database accounts and privileges Updated Markdown page
The database account an Exponential site needs on each engine and the least privileges that work - MySQL and MariaDB grants, PostgreSQL ownership, MongoDB roles in the site's database, Oracle grants from ora-grant.php…
-
Database administrators: start here Updated Markdown page
Where database administrators start with Exponential. The six supported engines in one paragraph, a first fifteen minutes, the rules every DBA keeps, and a map of every page for database administrators, from engine…
-
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…