breakpo

Someone using Tencent servers have been attacking my websites, mostly from China, Singapore, Vietnam, but also the US and Brazil. I usually have around 1K people surfing my website at any given time. Occasionally my website https://www.gematrix.org is getting published in a blog about Gematria and numeric values and I get higher traffic organically.  This attack was happening on multiple websites I own, not just this one, but the attack was made more brutally on Gematrix and at this website I investigated it. Lately, my website started crushing down. Did not worked properly. Responses were very slow.  Looking a bit more deeply into it, I could see I have around 12K visitors at the same second in my website which caused the delay. Like thousands of thousands requests per seconds. I did two things: 1. One of them is what I call "scale better": I have improved the way I handle requests, improved the caching and improved the database querying, schema and access.  Thanks god I...

I am using mysql for quite some time now. I have noticed that looking at client connections using mysql workbench so an interesting column called "Program". I can see that the program column indicate "MySQL Workbench":  This column can be very useful and help to filter different mysql database connections. It took me a while to understand how to set up this column data. So first thing I needed to do is understand where is this column name is actually coming from. I inspected the "SHOW FULL PROCESSLIST" command by mysql - but I did not get any answer there. I then looked at the query the mysql workbench itself running to get this data "Program" column: Using the "show details" button in the "client connections" view, show me this: Copying the query, it looks like that: SELECT t.PROCESSLIST_ID,IF (NAME = 'thread/sql/event_scheduler','event_scheduler',t.PROCESSLIST_USER) PROCESSLIST_USER, t.PROCESSLIST_HOST, ...