Re: Switching legacy tables from 4.0 to 4.1 -AND- from default to UTF-8 .... ADVICE ANYONE?

2005-07-15 Thread Miles Keaton
On 7/15/05, Bruce Dembecki <[EMAIL PROTECTED]> wrote: > This process has worked for us taking our latin1 4.0 databases and > turning them into utf8 4.1 databases. UTF8 data we had already put in > our 4.0 database despite it's latin1 encoding was correctly exported > out of 4.0 and correctly conver

Switching legacy tables from 4.0 to 4.1 -AND- from default to UTF-8 .... ADVICE ANYONE?

2005-07-14 Thread Miles Keaton
I've got some years-old MySQL databases mostly in 4.0, but one server running 3.23 that are all using the default encoding. I want to update all their data to 4.1 with UTF-8 encoding. Anyone done this kind of dump-and-update?Any advice to share or good URLs you've seen with others' advice abo

Re: What's Faster? MySQL Queries or PHP Loops?

2004-09-08 Thread Miles Keaton
You're talking about a difference of milliseconds, tops. Use whatever solution gives you the cleaner, easiest-to-maintain code. Don't worry about a couple milliseconds. http://c2.com/cgi/wiki?PrematureOptimization -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

best-performing CPU + platform for MySQL now? Opteron? OpenBSD? SuSE?

2004-09-06 Thread Miles Keaton
If my company wants to get the best-performing fastest platform for a MySQL server, what would it be these days? Opteron? Dual? Quad? And on a related note... If a 64-bit CPU, then I'm assuming it would need an operating system designed for that 64-bit CPU, to get best performance, right? I k

Re: OT Gmail

2004-08-29 Thread Miles Keaton
I have 7 invitations to give away. Feel free to ask, but include a sentence about why you want it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

anyone heard an ETA for MySQL 4.1? is it steady?

2004-08-19 Thread Miles Keaton
Programming a new site that will be launched in a month. We'd like to use MySQL 4.1 but aren't sure how "production-ready" it is. Anyone heard how the development is coming along, or when it will be officially released? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-07-31 Thread Miles Keaton
> I have several MySQL and FreeBSD installs across a few different sites, and > I consistently have problems with mysqld. It will begin to eat up all of the > CPU and eventually become unresponsive (or the machine will just burn). I > can't seem to manually reproduce this, but given enough time a F

tests comparing AMD64 to Xeon MySQL performance?

2004-07-27 Thread Miles Keaton
We've got a really high-load MySQL server and are planning to get a new server. Has anyone seen tests comparing performance of MySQL on AMD64 versus Xeon CPUs? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED