Recent changes
35934 changed pages · Atom feed · Recent comments · Recently added · Recent ratings
Wednesday November 04 2026
- Database accounts and privileges (Updated, Markdown page)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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)
Markdown documentation (help center) · Database administration · Changed 01:08 pm
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…
