anothermysqldba.blogspot.com
Another MySQL DBA: October 2014
http://anothermysqldba.blogspot.com/2014_10_01_archive.html
Saturday, October 11, 2014. Rotating MySQL Slow Logs. While working with different clients I happen to run across very large slow log files from time to time. While several opinions on how they should be rotated exist. Many of these opinions use log rotate and the flush logs command, I prefer not to flush my binary logs though. This is why I agree with Ronald Bradford's blog post. From years ago on how to do this. The script will do the following:. Gather current log file name. So does it all work? Rw-rw...
anothermysqldba.blogspot.com
Another MySQL DBA: MySQL Optimization Tip - thread_cache_size
http://anothermysqldba.blogspot.com/2013/09/mysql-optimization-tip-threadcachesize.html
Monday, September 2, 2013. MySQL Optimization Tip - thread cache size. Recently I encountered a MySQL database that easily was running with 300 to 600 rows in the processlist. The Max connections was set easily more than twice this amount as well. This was a set up that I just do not agree with. I was called in because it also proved itself not to be working out very well. So here are a few of my thoughts on the process I uncovered. Show status like 'Threads created';. Show status like 'Connections';.
anothermysqldba.blogspot.com
Another MySQL DBA: Find/parse a string from within a string
http://anothermysqldba.blogspot.com/2014/12/findparse-string-from-within-string.html
Friday, December 26, 2014. Find/parse a string from within a string. So I noticed a few different questions and posts about parsing a string out of another string recently. While some solutions included creating new functions and etc it can also be done within a single query in some cases. For example, let us say that we are looking to pull out the domain from a URL. I will try to go into detail as to why and how this works. We have the following table. CREATE TABLE `parse example` (. 19 23 / http:/ www&...
anothermysqldba.blogspot.com
Another MySQL DBA: Setup MySQL Proxy
http://anothermysqldba.blogspot.com/2013/05/setup-mysql-proxy.html
Thursday, May 9, 2013. So this is just a very simple example of using MySQL Proxy . The MySQL Proxy has been in the Alpha stages for what feels like years on end. MySQL Proxy Documentation :. The MySQL Reference manual. Http:/ fmpwizard.blogspot.com/search/label/mysqlproxy. Http:/ datacharmer.blogspot.com/search/label/mysql-proxy. Http:/ www.chriscalender.com/? Whatever is left from the MySQL forge site for MySQL Proxy WIKI can be found here: https:/ wikis.oracle.com/display/mysql/MySQL Proxy. Bin/mysql-...
anothermysqldba.blogspot.com
Another MySQL DBA: The server quit without updating PID file: DO NOT MOVE THE my.cnf file
http://anothermysqldba.blogspot.com/2013/05/the-server-quit-without-updating-pid.html
Friday, May 10, 2013. The server quit without updating PID file: DO NOT MOVE THE my.cnf file. I just ran across a blog post that said when you get the error " The server quit without updating PID file. You should move the my.cnf file out of the way and restart MySQL. That is just NOT. The correct step to solving a problem. What about all the settings that you have in the MySQL file? If you are running a MySQL server correctly, then you will have very important variables set in that my.cnf file. Is equiva...
anothermysqldba.blogspot.com
Another MySQL DBA: July 2015
http://anothermysqldba.blogspot.com/2015_07_01_archive.html
Saturday, July 25, 2015. Quick Password generation with MySQL. Here is a quick and simple way to generate a password your application using MySQL. This query will create a upper and lower case randomly generated password in length and values. SELECT CONCAT(UCASE(SUBSTRING( SUBSTRING(MD5(RAND() , FLOOR( 1 (RAND() * 5) , FLOOR( 8 (RAND() * 15 ) ) , FLOOR( 1 (RAND() * 4 ) , FLOOR( 4 (RAND() * 12 ) ) ,. FLOOR( 1 (RAND() * 4) , FLOOR( 1 (RAND() * 8) ),. CREATE TABLE `generated` (. Links to this post. एक और My...
anothermysqldba.blogspot.com
Another MySQL DBA: August 2014
http://anothermysqldba.blogspot.com/2014_08_01_archive.html
Thursday, August 14, 2014. MySQL Foreign Keys Example and ERROR 1452. So I ran across a situation today dealing with having to update a field but the user was unable to do so because of the related foreign key constraints. This blog post with be a simple example showing a foreign key and how to update them if you have to do so. First let us create a simple table and populate it with random data. CREATE TABLE `table w code` (. SOMECode` varchar(50) COLLATE utf8 unicode ci NOT NULL,. Anothermysqldba] INSER...
anothermysqldba.blogspot.com
Another MySQL DBA: Fibonacci Sequence Procedure
http://anothermysqldba.blogspot.com/2015/06/fibonacci-sequence-procedure.html
Sunday, June 28, 2015. Well it has been awhile since I posted, sorry about that. Today I was watching reruns of the TV show Fringe and when Walter referenced the Fibonacci Sequence I got side tracked with MySQL options for this. Now this post already existed:. Http:/ slava-technical.blogspot.com/2010/10/fibonacci-numbers-built-with-sql.html. So I took that post and expanded on it a little, the result is a procedure that you can call and return the range within the Fibonacci Sequence that you are after.
anothermysqldba.blogspot.com
Another MySQL DBA: December 2014
http://anothermysqldba.blogspot.com/2014_12_01_archive.html
Friday, December 26, 2014. Find/parse a string from within a string. So I noticed a few different questions and posts about parsing a string out of another string recently. While some solutions included creating new functions and etc it can also be done within a single query in some cases. For example, let us say that we are looking to pull out the domain from a URL. I will try to go into detail as to why and how this works. We have the following table. CREATE TABLE `parse example` (. 19 23 / http:/ www&...
anothermysqldba.blogspot.com
Another MySQL DBA: July 2014
http://anothermysqldba.blogspot.com/2014_07_01_archive.html
Friday, July 18, 2014. MySQL secure auth error. I addressed the secure auth errors before when it blocks replication in this blog post. However, I figured I would make this blog post a more general fix when connecting via MySQL clients. This is for servers before MySQL 5.6. So if you get a secure auth error when connection to MySQL the following steps should clear this error. SELECT @ session.old passwords, @ global.old passwords; - - - - - - - - - - - - - - - - - - - - - - - - -. Links to this post.
SOCIAL ENGAGEMENT