help with storing a large binary number as bigint
Hey all, This should be a relatively simple question but after looking through the manual for a while I didn't see how to do it. I am working in php and need to store a large binary number in the database. When I try and convert it to a int in php its too big so it converts it to a float and I loose all all precision witch makes it worthless to me. Is there a way to let mysql do the conversion since the number I am working with is 48bits and bigint can store 63bits??? I would need to be able to insert and select it as a binary string? Thanks for any help. Byron Albert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ram disk and solid state disks for data acceleration
Hey all, Any one with any experience with using solid state disks and or ram disks to store mysql data/tmp directoies/logs? How much performance gain do you think I would see? We have a very high write/read database using myisam tables. We are unable to migrate to other table types because of compatibility issues. The entire data base is currently about 6gb we expect it to grow to 16gb. Our application is very time sensitive. We are running on DL585's with 2-2.2ghz x86-64 cpu's and 10gb ram. Any help to keep our performance up would be appreciated. Thanks Byron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]