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

Re: Performance problems

will be usually required of it for a 30,000 user base. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com

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.com)? It seems to show some kind

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

that the speed -differences- in the types usually remain constant, while the actual speed itself can be changed with tweaking various other parts of the setup. If anyone (for some strange reason) wants a copy of my script, just email me off-list. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron

Re: Large MySQL setup

experimenting with individual values and see what gives me the best results. Thanks again -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com

Large MySQL setup

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 Williams[EMAIL PROTECTED] Black

Re: Large MySQL setup

when squeezing very last ounce of performance from your software, or at least trying to. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com

Re: Solaris 8 Mysql-3.23.44

it was. Just an idea. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams[EMAIL PROTECTED] Black Raven.com http://www.backraven.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before

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,

duplicating rows

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

Re: duplicating rows

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. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Aaron Williams [EMAIL PROTECTED] Dev. Engineering