NETTUTS (Free subscription) | 15 hours ago
Database operations often tend to be the main bottleneck for most web applications today. It’s not only the DBA’s (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers. 1. Optimize Your Queries...
Top Questions - Stack Overflow (Free subscription) | 16 hours ago
like: create table test( score integer unsigned between 1 and 100 ... ); Is it possible to do this in MySQL?
WebResourcesDepot (Free subscription) | yesterday
Sequel Pro is a free MySQL management tool for Mac OS X. It offers full table management (including indexes), supports MySQL views, imports/exports from SQL/CSV files & compatible with MySQL 3/4/5 databases. The application supports SSH tunnel connections besides standard local & remote connections for reaching databases behind firewalls. It can connect to multiple databases at the same [...]...
marxy's musing on technology (Free subscription) | yesterday
I'm in Brisbane to attend the Open Source Developers conference being held at the Bardon Conference Centre. While some of the equipment is a little dated.. the wifi service is OK and at a fair price ($35 for three days).We got in the night before things start and have met a few fellow attendees just hanging around the lobby. Gary kindly gave us a lift in to the Brisbane PHP/MySQL group meeting
Jobs in USA | Jobs in Bangalore, Canada, UK,... (Free subscription) | 11/24/2009
MySQL Database Administrator - 3 to 6 month contract to £350 per day MySQL Database Administrator - 3 to 6 month contract To develop and document the database implementation strategy for the next-generation product set. To define the database implementation strategy for the product set, running on a MySQL database, with particular emphasis on performance, scalability, reliability, security, clust...
The VAR Guy (Free subscription) | 11/23/2009
Roughly a year ago, MySQL stood near the top of The VAR Guy's Open Source 50 -- which tracks the world's most promising open source partner programs. Fast forward to the present and MySQL's ownership remains in doubt. The reason: The European Union continues to scrutinize Oracle's planned takeover of Sun and MySQL. For MySQL channel partners what does the future hold?
Linux Magazine: Top Stories (Free subscription) | 11/23/2009
Upgrading MySQL can be a bit of a leap of faith. You hope for everything to go well but really don't want to rely on mere hope to ensure that you don't find yourself with a nasty surprise late one night.
Database Journal (Free subscription) | 11/23/2009
During the past few weeks, we've been getting better acquainted with XML support in MySQL. This article finishes the series by talking about how to manipulate XML data using the XPath, which is a language for navigating and querying XML documents.
Top Questions - Stack Overflow (Free subscription) | 11/23/2009
SELECT ( SELECT SUM(IF(status = 'Active', 1, 0)) AS `univ_active`, SUM(IF(status = 'Inactive', 1, 0)) AS 'univ_inactive', Count(*) FROM online_university ) AS tot_university, ( SELECT SUM(IF(status = 'Active', 1,0)) AS `user_active`, SUM(IF(status = 'Inactive', 1,0)) AS 'user_inactive' Count(*) FROM online_register_user) AS tot_users Result must be univ_active=4 univ_inactive=2 tot_university=6 user_active=10...
MySQL Performance Blog (Free subscription) | 11/22/2009
MySQL Performance Blog (and percona.com too) were down today because the switch in our rack died completely. It took a while to fix it using secondary switch we had. Provider was not willing to do it as remote hands so I had to drive to the data center to fix it. We got [...]
DIYMacServer (Free subscription) | 11/20/2009
MySQL released new versions of the 5.1.x and 5.0.x community versions of their database server. There is a security issue releated to them so if you are affected I would advise you to upgrade. I’ve upgraded all my servers without any issue following the normal upgrade path as documented. Read more about the specifics for each [...]
LWN.net (Free subscription) | 11/20/2009
MySQL Community Server 5.0.88 has been released. This release includes a security fix along with other bug fixes. " Security Fix: MySQL clients linked against OpenSSL did not check server certificates presented by a server linked against yaSSL. "
Cnet (Free subscription) | 11/20/2009
Microsoft is now offering support for MySQL, which should give pause to every open-source company that expects to make money through support subscriptions.
Open Source (Free subscription) | 11/20/2009
Mueller said the delay in Oracle's response means a decision on the merger won't come from the European Commission until January 27.
MySQL Performance Blog (Free subscription) | 11/20/2009
There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state. When you see bug happening [...]
The 3 latest articles published by users on MySQL :
advikasingh | 11/19/2009
To start MySQLD server, all you need to do is to type “C:\mysql\bin\mysqld” on the MS-DOS window. However, the above command fails to start MySQLD server in case the database is corrupt or damaged. Stopping MySQLD server from mounting results into an error message that does not allow you to access the records stored in database components. In such circumstances, a convenient way to access your data...
advikasingh | 11/19/2009
Most frequent MySQL database users must have encountered database corruption error messages while attempting to access the records. While many of the error message are primarily a result of human errors, few might can also occur due to internal system malfunction, power outage and virus attacks. A major hazard that you might encounter after your MySQL database corruption is database unmountability...
prmac | 04/27/2009
PremiumSoft today released a major update to its Navicat administration tool for Oracle and PostgreSQL, and a minor update to its Navicat for MySQL. This major release includes some new features such as exporting from MySQL to Excel file, supporting of ODBC Import, Code Completion in all SQL Editor, Enhanced support of PostgreSQL version 7.3 to 8.3. Navicats major features include Data Import/ Export,...
Videos