How to parition a table with a VARCHAR Primary Key?

Hi, I'm struggling with getting my tables partitioned. All the tables I want to partition have a single primary key id which is a varchar. They also have a created datetime field to let me know when each record was added to the db. Ex: CREATE TABLE `document` ( `document_id` varchar(50) NOT NUL

Re: Key Buffer Size

Hi Terence, key_buffer_size is the amount of memory that is used to cache your index tables. If you are using 100% of it most of the time, you may benefit from an increase in it if you can afford to. You can also look at show status and look at key_reads and key_writes to give you an idea of how

JVM unable to access MySQL intermittently?

Hi, I'm running into a strange problem with my JVM and MySQL. I'm using Macromedia JRun 4 as my JVM and everytime I restart the Jrun service, my application runs smoothly. However, after an indeterminate amount of time (seemingly random - sometimes a couple of hours, sometimes 12-15 hours), my s

Re: JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

Indeed, I am running the server in Windows. I'll take a look at Troubleshooting 4.4 in depth. Thanks, Eric "Mark Matthews" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > -BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Eric B. wrote: > &g

JDBC timeout after 4.0.8 -> 4.0.18 upgrade?

Hi, I've recently upgraded from 4.0.8a to 4.0.18, and am running into a strange error in the JDBC connector. If the DB connection is unused for a period of time (don't konw the minimum amount of time, but 8-12 hours defintiely triggers the problem), I get the following error msg in my stack: **

What causes a crashed table?

Hi, I ran into a slight problem this morning where MySQL suddenly wouldn't recognize a table anymore. After doing a myisamchk on it, it listed the table as having crashed. myisamchk -r on the table fixed the problem, but I am concerned that this error happened in the first place. I've tried to

Re: Replication / Synchronizing DB across different machines

is that getting the slave to syncronize back to the master is not a nightmare, because both can be masters and slaves to each other and then this will all be handled automatically as soon as the servers are able to reconnect to each other. John From: news on beh

Replication / Synchronizing DB across different machines

Hi, I'm at the stage where I need to create redundancy in my network / DB server. Am currently using MySQL 4.0.x, and have been trying to figure out how I can safely replicate/synchronize between different machines. I know there is a way to do a Master / Slave replication, but I'm looking more f

Re: WHERE clauses across rows...

Not sure how you determine what the order of your rows are, but assuming you have a column called rownumber, or soemthing to that extent, which is a sequential numbering of the rows in your table, you can probably do it with a join on itself. You might have to play with the join syntax a little (i

Re: Pre-loading index file

Thanks Victoria! I must have missed that option. Exactly what I was looking for! Eric "Victoria Reznichenko" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Eric B." <[EMAIL PROTECTED]> wrote: > > I know that in 4.11+ you can prelo

Re: MERGE table across InnoDB tables?

According to the docs http://www.mysql.com/doc/en/MERGE.html: A MERGE table (also known as a MRG_MyISAM table) is a collection of identical MyISAM tables that can be used as one. The disadvantages with MERGE tables are: You can only use identical MyISAM tables for a MERGE table. I have neve

Pre-loading index file

I know that in 4.11+ you can preload your MYI index file into the key cache using LOAD INDEX (http://www.mysql.com/doc/en/Index_preloading.html), but is there a way to configure MySQL to do this whenever the MySQL service starts? I'm willing to write .sql batch statements, but is there someway to c

Re: INSERT returning ID

I'm not 100% sure, but this type of programming would seem to be opening the doors for bugs down the road that get difficult to trace and to track. If you are using a multi-threaded app, then you have to make sure that you prevent any mods to the DB after your insert and before your select. If yo

Re: Create database error

Might sound like a silly question, but have you checked the write permissions to the data dir? Am not sure if it is the mysql daemon that needs write access or if it is the user logged on "Colin O'Connor" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I'm bundling My

Re: Help! How to handle Massive index file???

Thanks Sasha. It helped trim down my table a bit Eric "Sasha Pachev" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Eric B. wrote: > > Sure! Here it is: > > > > CREATE TABLE `index2` ( > > `id` varchar(50) NOT NULL default 

Re: Any way to pre-load an Index file into the key cache?

blocks for the non-leaf nodes? Is there anything that will help me determine these values? Thanks! Eric "Paul DuBois" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At 13:35 -0500 2/23/04, Eric B. wrote: > >Hi, > > > >I know this question has

Re: HEAP tables vs MYISAM on ramdisk

re only available in MySQL 4.11 unfortunately, so perhaps > my ramdisk idea is a workaround for index caching until 411 is stable? > > On Mon, 2004-02-23 at 15:34, Eric B. wrote: > > How are you ensuring syncronization between the ram disk and the HD? Is > > there a writeback /

Any way to pre-load an Index file into the key cache?

Hi, I know this question has been posed in the past, but I haven't been able to find an answer for it yet. Is there any way in MySQL to pre-load a table's index file into the key cache at startup? I know the key cache will build itself while exectuing queries, but this will obviously slow down t

Re: HEAP tables vs MYISAM on ramdisk

How are you ensuring syncronization between the ram disk and the HD? Is there a writeback / writethrough mechanism for ram disks? Are you not risking major data loss if ever you have a power failure or PC failure? Thanks for the info! Eric "Mark Maunder" <[EMAIL PROTECTED]> wrote in message ne

Re: Help! How to handle Massive index file???

lots of thrashing, it might be to do with > >>fragmentation. Have you tried running OPTIMIZE TABLE on the table in > >>question? > >> > >>Does anyone on the list have anything to say about putting the MYD and > >>MYI files on seperate disks or using RAID My

Re: Help! How to handle Massive index file???

s lots of thrashing, it might be to do with > fragmentation. Have you tried running OPTIMIZE TABLE on the table in > question? > > Does anyone on the list have anything to say about putting the MYD and > MYI files on seperate disks or using RAID MyISAM tables?? > > Regards, &

Help! How to handle Massive index file???

Help! Okay - so I've been working around on my indexing of a table. My table is currently over 5M rows (close to 500Mb) and growing at a quick rate. In order to handle different types of queries, I am forced to create multiple indexes for the table. But by doing so, I end up with an MYI index

Help with indexing

Hi, I'm trying to implement the proper indexing for my DB, and am having some challenges. I was hoping someone could lend me a hand. If I have 5 fields in the DB that I am indexing (field1, field2, field3, field4, and field5), I know I can create an index: Key Index1( field1, field2, field3, fie