Choosing a column for primary key

I'd like to know about any potential issues of choosing a char(32) as the column type of a primary key instead of BIGINT or some other numeric type. A little background. I would like to generate a unique identifier to use as a primary key for our application instead of using an AUTOINCREMENT colu

Re: Performance problems

At 3:54 PM + 11/14/01, M. A. Alves wrote: >On Wed, 14 Nov 2001, Aaron Williams wrote: >> . . . >> I am not expert on innodb, or mysql either. I started playing with >> those values after reading the performance guide on Innodb.com. > >What is this site (Innodb.c

Re: Performance problems

on records should be able to push quite a lot more than will be usually required of it for a 30,000 user base. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Bl

Re: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size?

strange reason) wants a copy of my script, just email me off-list. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ---

Re: Large MySQL setup

esults it yields by just modify it alone. I appreciate the help, it looks like I will just need to start experimenting with individual values and see what gives me the best results. Thanks again -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Wil

Re: Solaris 8 Mysql-3.23.44

ot have been in your PATH, thus MySQL had no idea where it was. Just an idea. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTE

Re: Large MySQL setup

h, according to the docs, should be faster. Just thought it interesting. You find such stuff when squeezing very last ounce of performance from your software, or at least trying to. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams

Large MySQL setup

, with the following configuration options: ./configure --without-innodb --without-bench --without-debug Anything with that configuration that would be limiting me to just one CPU? Any and all advice is welcomed and appreciated. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Willi

Re: Large table crash recovery

Greetings list, I have a semi large table (~10gig) that when I run a select query from the table it gives me an errno 145. So I run myisamchk on the table, as it is a myisam table. However, my problem is, when I run myisamchk it tells me that the table has about 20 million data records, th

Re: turn $2000.00 into $1600.00 in 14 days

ust clicking a button. I work for an ISP, and SpamCop is quite effective. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale Dial-Upwww

Re: duplicating rows

ied over into the deleted_users table. Since each entry in the active_user will be auto_incremented, all of the rows in the deleted_users will have a unique identifer as well. At any rate, I guess two steps are better than three. Thanks for the help. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

duplicating rows

way. Any ideas or links to archives or documentation is appreciated. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering StarNet Incorporated WholeSale D