Mysql provides a configuration file located in /etc/my.cnf. From here you can set all of the memory, table, and connection limits as well as a host of other options. Before we get started I suggest you get aquainted with the my.cnf file as well as the tuning parameters within it.
Making note of this for future reference.
A nice assortment of cheat sheets for web developers/designers, including CSS, PHP, MySQL, Ruby on Rails, and more! This is a nice list, includes things like mod rewrite, html code and more.
A fantastic quick reference sheet for when you are working with MySQL from the command line.
Not a huge list of commands, but enough to get me started breaking stuff.
A couple of interesting articles on News.com about Oracle today, here and here, the first, the have bought another software company that caters to big businesses.
Oracle has agreed to buy communications software maker HotSip, marking the database giant’s second acquisition in as many days.
The messaging technology from Stockholm, Sweden-based HotSip could potentially make it easier for Oracle business software customers to take advantage of telephone or computer instant-messaging features from within Oracle’s existing applications. Oracle announced the acquisition Wednesday.
In the past two years, Oracle has spent some $19 billion buying up rivals to grab a bigger share of the market for software aimed at big businesses that helps automate everything from human resources to accounting to inventory management.
The second, they offered to purchase MySQL, but were turned down by their CEO.
Oracle tried to acquire open-source database maker MySQL, an indication of the profound changes the software giant is willing to make as it adapts to the increasingly significant collaborative programming philosophy.
MySQL Chief Executive Marten Mickos confirmed the acquisition attempt in an interview at the Open Source Business Conference here but wouldn’t provide details such as when the approach was made or how much money Oracle offered.
He did, however, say why he turned down Oracle’s offer: the desire to keep his company’s independence. “We will be part of a larger company, but it will be called MySQL,” Mickos said.
Makes my hart feel good to see some of these “big shots” turned down, can you imagine if they sold to Oracle, soon everyone whould have to buy MySQL I’m sure.