MariaDB 10.1 uses XtraDB as default engine, But I am still getting innoDB tables in information_schema . Why am I getting innoDB tables in information_schema?
Why am I getting innoDB tables in information_schema in mariaDB 10.1?
69 Views Asked by user2151502 At
1
There are 1 best solutions below
Related Questions in MARIADB
- `ColumnNotFound("id")` when inserting with SQLx
- What's supposed to be the problem in this query?
- Can't Fix Mariadb & Mysql ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2) On MacOs
- my spring boot app shuts down as soon as i open it
- EntityFrameworkCore.DbUpdateException: Unable to delete row, SQL Syntax error
- MariaDB incorrect dates
- 'pip install mariadb' states that it cannot find include file 'mysql.h' on my Windows 10 dekstop
- optimizing my.cnf for specific use case with MariaDB
- MariaDB service crashes since updating to Laravel 11 oom-kill possible memory leak in Laravel 11?
- mysql with odbc to ms access - runtime error 3146 (odbc call failed)
- Can I extend a shared docker-compose service twice (multiple times)?
- Appropriate way to convert unsanitized varchar from Base64 to Hex within MariaDB / MySQL
- Upgrading MariaDB 10.11 to 11.3
- Add dynamic categories to pie chart in Apache Superset?
- How do I start mariadb without the option --skip-grant-tables?
Related Questions in INFORMATION-SCHEMA
- How to find if a specific column is used across views in BigQuery (when the columns are not explicitly written in the view DDL)?
- Add new column into nested BigQuery STRUCT (for new `bi_engine_reasons` column in the `query_info` STRUCT from the new INFORMATION_SCHEMA.JOBS schema)
- Mysql: Determine size of user-created temp table
- Query table selected with another query in Snowflake
- postgresql information_schema exceeds 8 characters
- Snowflake // How to count records for each view in given schema for DEV and PROD database
- Querying all tables and their column names in ordinal position
- How to update type of all columns with the same name in all tables in one query in Postgres?
- Place SQLAlchemy results in Pandas dataframe for the information_schema?
- How do I select from the tables listed in INFORMATION_SCHEMA.TABLES in Snowflake?
- Need to find all views in a database which reference a certain table, cannot get this to work
- MySQL Information Schema is different from DESC Result
- Get table_schema, Table_name and total number of columns from information_schema in mysql
- Where to find user-defined types in table catalogue views
- MariaDB functions cannot correctly retrieve data from INFORMATION_SCHEMA.COLUMNS
Related Questions in STORAGE-ENGINES
- How to speed up altering storage engine and DB export/import in MySQL
- Why doesn't MySQL InnoDB redo log block writing need double write?
- When and How InnoDB access its metadata or index?
- What is the default storage engine used in phpmyadmin and is my DB or tables affected if I change the default storage engine?
- How do I fix Multer-Gridfs-Storage error "Error creating storage engine. At least one of url or db option must be provided"?
- Fix for Mongo RetryableWrites through deployment update rather than explicitly passed option?
- Trying to permanently change my "default storage engine" in MySQL
- How to change Mongodb`s default storage engine(wiredtiger) to my revised wiredtiger(git source build)?
- Why MyISAM is default MYSQL engine?
- How to get the storage space of a table in the MariaDB MyRocks storage engine
- consequences of changing mysql storage engine while application is running in production
- What are the current differences between MyISAM and InnoDB storage engines specifically in MySQL 5.7?
- Insert data with timestamps from the past to time series DB
- Storage Engine:Memory For Cart Management in eCommerce Site
- Change mysql default engine to innoDB on hostgator?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Since XtraDB is a "drop-in replacement" for InnoDB, probably they say "innodb" in order to avoid confusion for scripts, code, etc that uses them.
(Caveat: I can't say the above as a "fact", I have watched the evolution of XtraDB and MariaDB over the years, and feel that it is a safe guess.)
Some history...
Several years ago, Percona modified InnoDB (then 'owned' by Mysql AB or Sun, I forget the exact timing) to create XtraDB. XtraDB had some desperately needed fixes for performance. Since then, Oracle acquired MySQL (including InnoDB) and made numerous changes to it, especially in 5.6 and 5.7. Some of those changes were to incorporate (or replicate) the improvements that made XtraDB so good. Meanwhile, Percona continued development of XtraDB. Today, good code is generated by either, and sometimes incorporated into the other.
Meanwhile, MariaDB was branching off, and making other improvements in MySQL overall. At some point (10.x?), they chose to use Percona's XtraDB instead of Oracle's InnoDB.
To the casual observer, InnoDB and XtraDB feel, act, and smell the same. But if you dig hard enough, you can produce a test case that works better in one than in the other. Apples versus Oranges.
Bottom line: Not a problem.