DB Resource Usage

Byalexrusin December 19, 2018

You can use the following query to see who is using your database resources

SELECT max(user) as user, count(*) as connections_count, db from information_schema.processlist GROUP BY db order by connections_count desc;

Share this article

Laravel | PHP MySQL Development

Adding Email Headers in Laravel Application
Byalexrusin October 2, 2020September 17, 2023

Adding email headers in Laravel application is quite simple. SwiftMessage can be customized using withSwiftMessage method of Mailable base class: https://laravel.com/docs/8.x/mail#customizing-the-swiftmailer-message However you have to remember to do it every time you create a new “mailable” class. Some mail APIs require you to put a special header each time you send an email. In this…

Share this article

Read More Adding Email Headers in Laravel Application
Laravel | PHP MySQL Development

Debugging Webhooks
Byalexrusin August 26, 2018September 22, 2018

A webhook is an HTTP callback, that occurs when something happens (a resource changes its state). Webhooks provide a way to build event-driven apps, because you can be notified about changes. Since webhooks require a publicly accessible URL to function they can be hard to test from your local machine. There are three main problems…

Share this article

Read More Debugging Webhooks
Laravel | PHP MySQL Development

Stream Files From S3
Byalexrusin September 20, 2019September 20, 2019

When using S3 as our external storage, sometimes we have to let users download files from S3. If file is too large, it may not fit in the memory. The solution is to stream file into user’s browser straight from S3. Let’s take a look how to do it with Laravel’s Filesystem. There are 2…

Share this article

Read More Stream Files From S3
PHP MySQL Development

Setting up a PHP Application
Byalexrusin May 6, 2019May 6, 2019

When setting up a new PHP application one should consider how to manage certain housekeeping tasks such as exception handling, logging, and mail notifications.

Share this article

Read More Setting up a PHP Application
PHP MySQL Development

Exporting/Importing MySQL database from/to Remote Server
Byalexrusin June 20, 2017June 21, 2017

Export database mysqldump -u dbuser -p databasename -h rds.amazonaws.com > backup.sql Import database mysql -u username -p -h rds.amazon.com databasename < backup.sql mysql –host=rds.amazonaws.com –user=dbuser –password=password databasename < backup.sql Share this article

Share this article

Read More Exporting/Importing MySQL database from/to Remote Server
Laravel | PHP MySQL Development

Custom Mail Driver for Laravel
Byalexrusin November 10, 2018November 12, 2018

Out of the box Laravel supports many mail drivers, such as smtp, sendmail, mailgun, log, array, etc. But what if you wold like to use a mail service that Laravel does not have a driver for, such as Mailjet? You can create a custom driver for that service. This article will describe how to create…

Share this article

Read More Custom Mail Driver for Laravel

Similar Posts