This Log Buffer Edition rounds up Oracle, SQL Server, and MySQL blog posts of the week.

Oracle:

When using strings such as “FREQ=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=9,10? within the scheduler, sometimes its not readily apparent how this will translate to actual dates and times of the day that the scheduled activity will run. To help you understand, a nice little utility is to use EVALUATE_CALENDAR_STRING”.

Most developers have struggled with wires in SOA composites. You may find yourself in a situation where a wire has been deleted. Some missing wires are restored by JDeveloper. Other missing wires have to be added manually, by simply re-connecting the involved adapters and components. …

Hi,

We’ve been trying to download latest version of MariaDB ODBC driver for windows but we couldn’t connect to the site for some reason. Can someone please help? Is MariaDB Connector 3.0 the latest version? Where we can download it? We tried all links provided on the web and failed every attempt.

Thanks.

This blog post will discuss what is necessary of the Percona Live  Advanced Percona XtraDB Cluster tutorial.

Percona Live 2016 is happening in April! If you are attending, and you are registered to the Percona XtraDB Cluster (Galera) tutorial presented by Kenny and myself, please make sure that you:

• Bring your laptop, this is a hands-on tutorial
• Have Virtual Box 5 …

In this post i want to githubve example of generate dynamic sitemap using roumensitemap package sitemap is very usefull for SEO you can submit your sitemap on google webmaster bing webmaster etc that way you can increase website rank and web traffic So if you are working on Laravel framework

Starting with MySQL 5.7, performance_schema has been enhanced to instrument metadata locks, and can be turned on by adding the following line to your my.cnf file:

performance-schema-instrument='wait/lock/metadata/sql/%=ON'

(At runtime, it can also be enabled by modifying the setup_instruments table in performance_schema.)

From here, you can now query performance_schema.metadata_locks to reveal all currently open metadata locks on your server:

mysqlselect * from performance_schema.metadata_locks\G
*************************** 1.

…

This blog is an EXPLAIN FORMAT=JSON wrap-up for the series of posts I’ve done in the last few months.

In this series, we’ve discussed everything unique to

EXPLAIN FORMAT=JSON

. I intentionally skipped a description of members such as

table_name

,

access_type

  or

select_id

, which are not unique.

In this series, I only mentioned in passing members that replace information from the

Extra

 column in the regular

EXPLAIN

 output, such as

using_join_buffer

 ,

partitions

,

using_temporary_table

  or simply

After publishing Part 2 of a series on JSON data in MySQL last week, a few folks reached out to me with some great feedback. Not only that, but they shared some resources I thought would be beneficial to pass on.

Morgan Tocker, the Product Manager that works on JSON support in MySQL pointed me toward the MySQL Server Team’s blog, which is more approachable than the docs for topical matters and directed discussion. Specifically he highlighted the JSON category, which has several great posts on everything from using path expressions to ‘upgrading’ json data previously stored in TEXT data columns to JSON data columns. Definitely worth perusing.

…

Join us for our latest webinar on Thursday, April 7, at 10 am PDT (UTC-7) on Introduction to Troubleshooting Performance: What Affects Query Execution?

MySQL installations experience a multitude of issues: server hangs, wrong data stored in the database, slow running queries, stopped replications, poor user connections and many others. It’s often difficult not only to troubleshoot these issues, but to even know which tools to use.

Slow running queries, threads stacking for ages during peak times, application performance suddenly lagging: these are some of the things on a long list of possible database performance issues. How can you figure out why your MySQL installation isn’t …

Your Database, Any Cloud - NinesControl (beta)

As you may have seen, we recently announced NinesControl, a developer friendly service to deploy and manage MySQL and MongoDB clusters using your preferred Cloud Provider.

There is still time for you to join and get an early look at NinesControl - just provide us with your email address, and we will be in touch to give you early access to the service.

NinesControl users will be able to benefit from the following key features:

• Provision a database on any cloud
• Real-time unified monitoring
• Automated database management and availability

Sign up up to stay informed and apply for early access

And see further details on NinesControl below in this blog.

What is NinesControl?

…

Whenever you require to create all array value in lowercase then you can create that without using loop you have to just use arraymap arraymap function take two argument one for php function strtolower and second one for array May be we need to do this when we are working on big projects an