0

Hey everyone,

As many of you know, we've been having serious database issues here on DaniWeb lately, causing the site to go down just about every single day for a few minutes. We finally got the situation resolved thanks to our database sysadmins over at Percona.

While James and Cameron manage all of our servers on a day-to-day basis, we sometimes have to reach out to the folks over at Percona (www.mysqlperformanceblog.com) for extra MySQL assistance.

We've been working with Percona for many, many years already, and some of the guys over there who we work with will be coming to our hometown, NYC, to host a MySQL conference later this month.

Due to our relationship with them, we were able to get a hold of a couple of free tickets to the event (normally $249), and we're giving the tickets away for free to community members who respond to this thread with any really interesting fact, tidbit, or useful piece of information about MySQL.

Here's a link to the event details: http://www.percona.com/live/nyc-2011/

I'll be there myself, so I hope to see some of you guys there as well!

10
Contributors
14
Replies
16
Views
6 Years
Discussion Span
Last Post by Ramin2000
Featured Replies
0

never changes the max log file size on innodb without first getting rid of the existing log files :|

learned that the hard way in the middle of a work day today

1

I would love free tickets, only problem is I am buried under a pile of work. But I will be sure to pass the message on see if anyone else is interested in going to a mysql conference.

0

Please set aside 1 free ticket for me. Thank you so much

Do you have an interesting fact to share about MySQL?

0

I have used MySQL for a couple of projects. It feels lighter than SQL Server but still delivers the same power...that includes scaling.

0

Not sure if this qualify's for a MYSQL fact but...

Sphinx which is a very common full text search engine many Mysql database administrator use is NOT MySQL specific. It can work with just about any RDBMS such as PostgreSQL, MS SQL and Oracle Servers. It can also read XML woot woot lol

0

Ok in case the above does not count or in case the more I post the better my chances of scoring a ticket to the MySQL conf lol

For those that use the function "Replace into" function in mysql instead of using an insert their is a draw back you should be aware of
For those that don't know what the Replace Into function in sql is here is what it does..

REPLACE works exactly like INSERT, except that if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted before the new row is inserted

take note on the part that says
if an old row in the table has the same value as a new row for a PRIMARY KEY or a UNIQUE index, the old row is deleted

If you're planning on using REPLACE in one of your own programs, ensure that you've retrieved all columns from that table first.

0

I want one pretty please!!

Do you have something interesting to say about MySQL?

-1

Two more guys in the office want free tickets to the MySQL conference! What do they have to do?

0

Not sure how useful this is, but I have a client who actually uses Corel Paradox in place of MySQL for reasons too long to explain here, however about a year or so ago I took the initiative to modernize the code to make things simpler for my client, however despite weeks of going through my predecessors code and limited documentation, every attempt to recreate the Paradox functionality with MySQL ended in horrible failure.

After hours and hours of effort, I kept following the workflow, however for some reason my queries were dropping values randomly, so to this day the code I wrote is collecting dust somewhere on the workstation.

1

Just moved to mysql and it saved me from so many problems which I used to have…
Very excited about the event.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.