Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables.

you can set multiple database connections in same laravel application Laravel provide configration file for setup multiple database connections you can see configdatabasephp file and see mysql multiple database connections you can add setting another mysql database detail like this waystrong

In this post i want to share you how to solve tokenmismatchexception error on ajax request time in laravel application When i was working on my ecommerce website in laravel 5 I was found like bellow errorpreNetworkError 500 Internal Server Error httplearnl52hdgetProductTokenMismatc

Sometimes you may need to remove packages from your laravel application I mean if you installed package but you dont need now and that useless in your project you want to remove that useless package from your project that you remove using laravel composer command In this posts i am going to g

you can set multiple database connections in same laravel application Laravel provide configration file for setup multiple database connections you can see configdatabasephp file and see mysql multiple database connections you can add setting another mysql database detail like this waystrong

This example is make using jqueryuijs library We may always need to jquery dialog box in our project because modal is very interesting and specially for GUI Always we like to use modal for creating data or editing data and also for conformation So if you think how to set modal in my project the

In this blog, we’ll examine how CPU governor performance affects MySQL.

It’s been a while since we looked into CPU governors and with the new Intel CPUs and new Linux distros, I wanted to check how CPU governors affect MySQL performance.

Before jumping to results, let’s review what drivers manage CPU frequency. Traditionally, the default driver was “acpi-cpufreq”, but for the recent Intel CPUs and new Linux kernel it was changed to “intel_pstate”.

To check what driver is being used, run the command

cpupower frequency-info

 .

cpupower frequency-info
analyzing CPU 0:
driver: acpi-cpufreq
CPUs which run at the same hardware frequency: 0
CPUs which need to have their frequency coordinated by software: 0
maximum transition latency: 10.0 us.
hardware limits: 1.20 GHz - 2.00 GHz
available frequency steps: 2.00 GHz, 2.00 GHz, 1.90 GHz, 1.80 GHz, 1.70 GHz, 1.60 GHz, 1.50 GHz, 1.40 GHz, …

Since we announced our support for Amazon Web Service's Aurora last year, we've had great experiences working with customers who use Aurora as their database system of choice. And not only is Amazon's RDS excellent, so is their team and support.

Recently, we encountered a MySQL bug that was, in turn, having effects on Amazon’s RDS. The MySQL issue involved a problematic query that caused Aurora instances to crash under load; upon discovering this issue, we had the opportunity to work with AWS to identify the error in MySQL and fix it, so that it would avoid an impact on AWS’s systems. It turned out that the query itself posed a potential problem for all monitoring services -- not just VividCortex; fortunately, however, once AWS addresses the bug, the problem will be fixed for all monitoring products that might come across it, …

Sometimes we use get html view layout from ajax request At that you have to first render view file and then you need to store view in varibale and then we can return that varibale In bellow example i render view with pass data you can see how i didstrongExamplestrongpre classprettypri

This tutorial will show you how to monitor an Ubuntu 16.04 server with Munin and Monit. Munin produces nice graphs about nearly every aspect of your server, whereas Monit checks the availability of services like Apache, MySQL, Postfix and takes the appropriate action such as a restart if it finds a service is not behaving as expected. The combination of the two gives you full monitoring: graphics that let you recognize current or upcoming problems, and a watchdog that ensures the availability of the monitored services.