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
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
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
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:
Hi,
I've recently upgraded from 4.0.8a
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:
**
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
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
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 behalf of Eric B.
Sent: Sun 2/29
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
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 preload your MYI index file into the key
cache
using LOAD
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 '',
`recordid` varchar(20) NOT NULL default '',
`transid
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 MySQL
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
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
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
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
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
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 / writethrough mechanism for ram disks? Are you not
risking major data loss if ever you have a power failure
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 been posed in the past, but I haven't been able
to
find
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
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,
Chris
Eric B. wrote:
Help!
Okay - so I've been working
`,`is
deleted`,`indexvalue`),
KEY `formid_idxfield_idxvalue` (`formid`,`indexfield`,`indexvalue`)
) TYPE=MyISAM
Thanks,
Eric
Chris Nolan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Can you send us the CREATE TABLE statement for this troublesome table?
Regards,
Chris
Eric B. wrote
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,
23 matches
Mail list logo