Posts Categorized: Technical Blog
If you have ever had this message: Unable to locate an oracle.mk, proc.mk or other suitable *.mk file in your Oracle installation. (I looked in…) It can be a very frustrating one to track down. There is no 100% answer for this problem but there seems to be two main scenarios where I have encountered this and have come up with somewhat of a solution, here it is.
I cloned Oracle software before and it is a simple process: tar $ORACLE_HOME, copy the tar file to the new server, untar, run the cloning script which will register the new home with the inventory, and you are done! In theory, at least. Here is what actually happened:
Welcome to Log Buffer, the weekly roundup of database blogs. We’re back this week with a short Log Buffer #190. Only ten more issues, and we’ll be celebrating our 200th edition post.
Curtis Jewell followed up on an old post by Adam Kennedy and checked out if shuffling things around really improve compression. From the results, there seems to be very little blood to be squeezed out of that stone. jjore came up with a very clever hack to stop the debugger when a test fails. Not only it is extremely useful, but the hack itself provides a lot of insight and food for thought for anyone attracted to the dark arts of under-the-Perl-interpreter-hood meddling.
The MySQL track at Kaleidoscope in Washington, DC during June 28-July 1st is set! Here is the schedule, Lincoln VI is the MySQL track room. It’s not too late to register for Kaleidoscope – be sure to use the discount code MYSQL to save $300 off your registration (assuming you are not a member of ODTUG).
Good afternoon and welcome to issue 27. The number 27 according to numerology is “the symbol of the divine light” so I’ll try to do that ideal justice. We’re off to a good start, what with me actually getting this out on schedule and such, so let’s get to it while the day is still quiet.
Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #189 is generously published by Iggy Fernandez, editor of the quarterly journal of the Northern California Oracle User Group (NoCOUG).
I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.
A user group member mentioned PuTTY Connection Manager. It wraps around PuTTY and gets the existing saved connections, makes a nicely tabbed browsing window where you can open sessions by double-clicking the connections, which are now listed on the right-hand side.
This article will explain why changing the sort_buffer_size kills performance and stability, it will also talk more about understanding why, an integral part against the “Battle against any guess.” Baron’s recommendation to leave sort_buffer_size as the default is just as bad as all the advice given to change the sort_buffer_size, because all that advice (including Baron’s) does not explain the underlying causes.