48 reputation
7
bio website
location
age
visits member for 2 years, 4 months
seen May 20 '13 at 11:29

I am working as a MySQL DBA since two years.
Have started Oracle administration recently.


Sep
24
awarded  Autobiographer
Aug
7
awarded  Popular Question
May
29
awarded  Popular Question
May
20
answered Reloading MySQL my.cnf changes
May
20
answered Mysql crashing due to InnoDB not able to allocate memory
Nov
27
revised Configured MySQL for SSL , but SSL is still DISABLED..!
edited title
Nov
23
revised Configured MySQL for SSL , but SSL is still DISABLED..!
edited title
Nov
23
revised Configured MySQL for SSL , but SSL is still DISABLED..!
deleted 1 characters in body
Nov
23
comment Configured MySQL for SSL , but SSL is still DISABLED..!
@johannes same ssl not in use.. One more thing I am not able to connect with password.. without password it is atleast connecting but ssl is still not in use.
Nov
23
awarded  Commentator
Nov
23
comment Configured MySQL for SSL , but SSL is still DISABLED..!
@gertvdijk There was no entry of "unable to read private key" or like error message.
Nov
23
comment Configured MySQL for SSL , but SSL is still DISABLED..!
@val0x00ff yes MySQL supports ssl if have_ssl value is disabled.
Nov
23
comment Configured MySQL for SSL , but SSL is still DISABLED..!
@gertvdijk I have used openssl-1.0.1c. I am checking logs for the mentioned error.
Nov
23
asked Configured MySQL for SSL , but SSL is still DISABLED..!
Nov
23
awarded  Scholar
Nov
23
accepted MySQL on Linux out of memory
Jun
28
comment MySQL on Linux out of memory
@ Lucas I tried executing the mysqltuner.pl script but didnt get any output. It would be nice if you could give a link or share a document on how to use it..
Jun
28
revised MySQL on Linux out of memory
deleted 1352 characters in body
Jun
28
comment MySQL on Linux out of memory
@ Lucas Thanks for the suggestions. Actually the problem was with the Application, where the connections was not releasing memory even after the connection was closed. The application is liferay and as I mentioned earlier we set two parameters in that : testOnBorrow=''true' and validationQuery="SELECT". Now the server is stable. Still I would keep your points in mind.. :)
Jun
21
comment MySQL on Linux out of memory
@John I am not saying that MySQL is the cause.My concern is the site goes down when whole RAM is consumed.We are using Liferay and last night we set two parameters in that : testOnBorrow=''true' and validationQuery="SELECT". I guess it's for connection pooling. Today @ one point of time the RAM jumped from 24GB to 64GB in just 10mins. And for a change the swapped memory was used(20GB). and after 10mins the RAM and Swap memory decreased to 4GB and 500MB resp. And the site didnt go down. But the memory is increasing gradually again. Is it a thing to worry????