Aurora RDS: AWS Released encryption for Aurora Instances. Encryption is not available as of now. Amazon RDS Encryption Links Encrypting Amazon RDS Resources You can encrypt your Amazon RDS instances and snapshots at rest by enabling the encryption option for…
Month: August 2015
Random Errors
Putty Fatal Error: Network Error: Software caused connection to abort. PuTTY Fatal Error
|
1 2 3 4 5 |
I worked with CentOS servers from Windows PCs, and I had the same problem with PuTTY. A session didn't last more than 1-5 minutes. I tried to play with PuTTY settings (keepalives, etc.) but it didn't help at all. Finally I have found the solution for my case. I've recorded TCP dumps both on the client and the server. I've discovered that during 25-30 seconds before disconnecting there are several retransmissions of TCP segments in the client's dump (both from the client's and from the server's side) and finally PuTTY sends RST and close the session with that error. In the server's dump I didn't see any segments from the client in this period, even RST. It means that time to time no TCP segments from the client are delivered to the server and this period is about 30-60 seconds. I've recorded the case several times and always there were retransmissions and final RST from PuTTY. Probably somewhere on the route packets were dropped by network equipments. To make a workaround I've increased the maximal number of data retransmissions from the default value 5 up to 16. It could prevent PuTTY from disconnection too fast. The variable is 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\TcpMaxDataRetransmissions'. I've added this variable manually, it wasn't initially defined in the registy of my Windows. It did help! Now I see that PuTTY hangs from time to time, but it always comes back . |
MySQL Ramp Up
MYSQL: Add Column to Existing Table and Make it Auto Increment and Add Primary Key Constraint Link : Alter Table and Add Column
|
1 2 |
ALTER TABLE StudentPortalData ADD StudentPortalDataID INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (StudentPortalDataID); |
Query Plan and Query Profile for Executed Queries
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
USE SampleDatabase; SELECT @@profiling; SET profiling = 1; EXPLAIN SELECT * FROM SampleTable where DATE_OF_BIRTH='04131998' and CODE ='CODE'; SELECT * FROM SampleTable where DATE_OF_BIRTH='04131998' and CODE ='CODE'; SHOW PROFILES ; SHOW PROFILE FOR QUERY 15; |
TimeOut Error from MySQL WorkBench: Error Code:…
(No Ratings Yet)
Loading...
Top