Mmm, Pi-hole

I have a love-hate relationship with ad blockers. On the one hand, I despise the obnoxious ads that are forced down our throats at what seems like every turn. On the other hand, I appreciate the need for publishers to earn a living so that I can consume their hard-earned work for free. Somewhere in the middle is a responsible approach, for example the sponsorship banner you see at the top of this blog. Companies I choose to partner with get to appear there and they get themselves 140 characters and a link. That is all. No images. No video. No script. No HTML tags. No tracking. Sponsors are happy as they get exposure, visitors are happy because there’s none of the aforementioned crap and I’m happy because it pays a lot better than ads ever did anyway. It almost seems like everyone is happy. Almost…
As I wrote about a


Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/GpOz08haMck/

Original article

Archive MySQL Data in Chunks Using Stored Procedure

In a DBA’s day to day activities, we are doing Archive operation on our transnational database servers to improve your queries and control the Disk space. The archive is a most expensive operation since its involved a huge number of and Write will be performed. So its mandatory to run the archive queries in chunks. The archive is depended on business use. Many of us need a copy of the data on an archive database to refer later. To perform the archive we can just simply run the delete query with the limit. But we need to run the query again and again until the matched rows count is 0. We can create a procedure to do this in a while loop. I have created one such procedure to archive many tables. 

Why Archive is an expensive operation? 

Generally how we are arching the data is from table_name where column_name 0
do
SET


Original URL: http://feedproxy.google.com/~r/feedsapi/BwPx/~3/HbXCrRBVSgo/

Original article

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑

%d bloggers like this: