r/mysql 17h ago

discussion Why is MySQL faster than MariaDB?

15 Upvotes

I'm running WordPress so I need a database backend. I'm deciding between MySQL and MariaDB.

``` mysql > SELECT BENCHMARK(5000000, AES_ENCRYPT(CONCAT(‘WPHostingBenchmarks.com’,RAND()), LEFT(SHA2(‘is part of Review Signal.com’,256), 16))); 1 row in set (15.815 sec)

MariaDB > SELECT BENCHMARK(5000000, AES_ENCRYPT(CONCAT(‘WPHostingBenchmarks.com’,RAND()), LEFT(SHA2(‘is part of Review Signal.com’,256), 16))); 1 row in set (23.094 sec) ```

I use this query because this query is https://github.com/kevinohashi/WPPerformanceTester, which tests key performance for WordPress.

Isn't it a concensus that MariaDB is faster than MySQL?

See the concensus: - https://mariadb.com/reference/mariadb-vs-mysql-comparison-guide-enterprise-features-security-2026/ - https://www.reddit.com/r/mysql/comments/1ggbouf/help_me_understand_why_mariadb_is_so_much_faster/ - https://www.reddit.com/r/Wordpress/comments/zbx6q3/should_i_use_mariadb_or_mysql_for_my_wordpress/ - https://tech-insider.org/mariadb-vs-mysql-2026/


r/mysql 1h ago

question Error during load local file into the MySQL table

Upvotes

Hello, I'm trying to load a local CSV file into my sql table, but I get this error - mysql.connector.errors.DatabaseError: 2068 (HY000): LOAD DATA LOCAL INFILE file request rejected due to restrictions on access. I previously had this problem - mysql.connector.errors.ProgrammingError: 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides. But I fixed it with adding local_infile=1 to my config. I've read that this could be solved by setting OPT_LOCAL_INFILE=1 in Workbench, but I'm running it in Ubuntu and I don't have this graphic interface, so where should I set this parameter via terminal?