Showing entries 8271 to 8280 of 44089
« 10 Newer Entries | 10 Older Entries »
Comment on Life at Pythian as a MySQL DBA by Natalia

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!

How to create custom facade in laravel 52

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

Check and Uncheck checkboxes using JQuery

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

We need your feedback: please participate in our open source database management survey

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:

Tags:

[Read more]
EXPLAIN FORMAT=JSON: buffer_result is not hidden!

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: …
[Read more]
Jörg Brühe: On Files, the Space They Need, and the Space They Take

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 …

[Read more]
February 23rd: how CloudStats.me moved from MySQL to clustered MariaDB for high availability

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 …

[Read more]
Videos of FOSDEM MySQL & Friends Devroom are available !

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 !

MySQL Performance: Scalability on OLTP_RW Benchmark with MySQL 5.7

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 / …

[Read more]
How to create custom helper in Laravel

I would like to explain how to create custom helper functions in your laravel project some functions and some repeating code so at that time you have to create some helper functions that can help to easy way and every time you not need to write more code and very flexible that way you can easily

Showing entries 8271 to 8280 of 44089
« 10 Newer Entries | 10 Older Entries »