Where do Wikis using MediaWiki Software Store Their Articles?

Question

Where and how do wikis that use the MediaWiki software store their articles?

Answer 1

In a MySQL database, typically.

Nowadays MediaWiki also supports other databases, such as PostgreSQL. For details, read the "Database server" section here.

Edit: as to how MediaWiki stores the articles, see Manual:Database layout for much details, such as a diagram of the database schema and the SQL for creating the tables.

Answer 2

In a MySQL database. I've tried using PostgreSQL but encountered a Mediawiki bug in searching text.

Answer 3

select * from page 
left join revision on page_id=rev_page
left join text on rev_text_id =old_id 
limit 100;

This sql-query shows which table and how MediaWiki software store their articles.