This is a repost of Otto Kekäläinen's blog of the MariaDB foundations work in 2015.

The mariadb.org website had over one million page views in 2015, a growth of about 9% since 2014. Good growth has been visible all over the MariaDB ecosystem and we can conclude that 2015 was a successful year for MariaDB.
Increased adoptionMariaDB was included for the first time in an official Debian release (version 8.0 "Jessie") and there has been strong adoption of MariaDB 10.0 in Linux distributions that already shipped 5.5. MariaDB is now available from all major Linux distributions including SUSE, RedHat, Debian and Ubuntu. Adoption of MariaDB in other platforms also increased, and MariaDB is now available as a database …

Hi Derek, thanks for sharing with us this post, from my perspective it was really helpful.

I have worked as a Windows admin for several projects but the roles were very specific and sometimes you did not have the chance to do new things.
At the moment I work freelance but I am very interested in a job position for Pythian.

Do you know if there´s any job position for Windows Admin?

Thanks!

Sometimes we are use repeat code and repeatedly use function at that time we can create custom facade for our project that way you can create functions and use itSo How to generate custom facade I give you the few step to create custom facadestrongStep 1Create class file appItSolutionDem

Sometimes we need to Select and Deselect all checkboxes like you see on gmail if you check top checkbox then automatically select other allSo we can do using jquery and its method propIn Following example you can see how is that and use this example simplystrongExamplestrongpre class

As members of the wider open source database users community, we’d like you to participate in our open source database deployment and management survey.

Your input will help us make our resources and tools for deploying, monitoring, managing and scaling databases of even more use to the community. It will give us valuable insight into the challenges you face when operating databases.

Please take the survey today by providing your input below; this will take approx. 5 minutes of your time.

We’ll share the results of the survey once we have compiled your responses.

Thank you!

Blog category:

• Company News

Tags:

• Database
• …

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can view the buffer result using JSON (instead of the regular

EXPLAIN

 command.

Regular

EXPLAIN

 does not identify if

SQL_BUFFER_RESULT

 was used at all. To demonstrate, let’s run this query:

mysql> explain select * from salariesG
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: salaries
   partitions: NULL
         type: ALL
possible_keys: NULL
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 2557022
     filtered: 100.00
        Extra: …

or

xfs Users, Take Care!

Recently, we had a customer ask: Why do many files holding my data take up vastly more space than their size is? That question may sound weird to you, but it is for real, and the customer's observation was correct. For a start, let's make sure we are using the same terms.

• The size of a file is the number of bytes it will deliver if it is read sequentially from start to end.
• The space it takes up is the sum of all disk pages which are used to hold the file's data, or to locate those data pages ("indirect" blocks in Unix/Linux terminology).

Every Unix/Linux admin knows (or at least should know) that a file may take up less disk space than its size is. This happens when not all bytes of the file were really written, but the write pointer was advanced via "seek()", leaving a gap. Disk pages which are completely contained in such a gap will not be written, and …

On Tuesday, February 23, please join us and the WooServers team for a webinar on the scalable, open source database infrastructure behind CloudStats.me.

CloudStats.me is a fast growing cloud-based server and website monitoring service. The rapid growth of the CloudStats user base and the number of services being monitored created a significant load on its MySQL infrastructure. The system ingests large amounts of incoming metrics/event data collected by thousands of agents. The backend systems also perform analytics on large portions of that data, and alerts are triggered as soon as certain conditions are met.

Andrey Vasilyev, CTO of Aqua Networks Limited - a London-based company which owns brands, such as WooServers.com, CloudStats.me and …

After the pictures (see the galleries on top ^), the videos of the MySQL & Friends Devroom are available !

You can find them on http://video.fosdem.org/2016/h1308/

Enjoy them !

Next article from the MySQL 5.7 Performance stories, now about OLTP_RW scalability (if you missed any previous ones, see 1.6M SQL Query/sec (QPS) with MySQL 5.7, 1M SQL Query/sec on mixed OLTP_RO / true Point-Selects performance / over 100K Connect/sec Rate / …