View Single Post
  #1  
Old 02-10-2015, 11:30 PM
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Location: Hobart & Adelaide .au
Posts: 521
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default About Databases and other wondrous things (MariaDB)

For some time now MariaDB has been taking over from MySQL as the preferred open source database.

The reasons are well covered here: https://blog.openshift.com/why-maria...ew-with-monty/

WHM/cPanel have been their usual slow (cautious) approach have made MariaDB the future replacing MySQL.

We upgraded this morning. MariaDB is faster and has a smaller memory foot print.
Initially I'm seeing up to ~20% surprisingly faster database; but this won't make a huge difference to your site experience as the database component of any page hit is only 10-15%.
I.e. maybe 2% of the overall transaction.

Why upgrade?
  1. MariaDB is faster
  2. MariaDB has some better features in regards being resilient to crashes
  3. MariaDB has less bugs/issues than MySQL
  4. Very large sites (eg. Wikipedia) have changed to MariaDB
  5. MariaDB also has more than 10,000,000 users now (lots of people with experience and bugs reports etc.)
  6. It is now the default database on some major Linux distributions (again well supported)
  7. It is plug compatible with MySQL - it is easy for us to change
  8. MariaDB is the future and we are protected from the whims of Oracle who now control MySQL
  9. The MariaDB core team is ex MySQL because the did not like Oracle's approach
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01249 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete