Questions tagged [myisam]
69 questions
0
votes
2 answers
MySQL: view read/write proportion, per specific table
I'm optimizing the configuration of a MySQL server, running only Bromine.
This is non specific to application, and was just noted for completeness.
I am trying to determine if switching from MyISAM to InnoDB is a better option, on few write dominant…
J. M. Becker
- 2,471
- 1
- 17
- 21
0
votes
1 answer
Can I Record Limit on MyISAM Table?
I have a big data in myisam so a table's disk space is got full
so Can I Record Limit on MyISAM Table?
freddiefujiwra
- 1,667
- 5
- 25
- 34
0
votes
1 answer
MyISAM Partition empty table load problem
> Create Table: CREATE TABLE `trb3` (
`id` int(11) default NULL,
`name` varchar(50) default NULL,
`purchased` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
PARTITION BY RANGE (YEAR(purchased)) (
PARTITION p0 VALUES LESS THAN…
freddiefujiwra
- 1,667
- 5
- 25
- 34
0
votes
2 answers
changing lastactivity mysql table from myisam to memory a good idea?
I am trying to reduce the writes to disk and in my social site I have a lastactivity table which is updated with the time() a user last used the site. It is currently MyIsam:
id int(7) PRI auto_increment
lastactivity int(10)…
bearhunt
- 3
- 1
0
votes
2 answers
MySQL - Innodb, search
I recently switched from myisam to innodb in one of my mysql tables. Before i was using MATCH(). Since innodb doesn't support match() i decided to use LIKE.
Now I have a problem. My table is 190,6 MiB big and have 234,083 rows. When I use LIKE my…
Erik
- 125
- 1
- 3
0
votes
1 answer
Rebuilding a MySQL database from 160 retreived files with no name
I had a server crash and it
took with it the hard drive. I put the hard drive in a USB enclosure,
but the main partition would not mount because the partition was
corrupted. I was able to see the USB hard drive, just not mount it.
Using the "dd"…
Daniel
- 31
- 3
0
votes
1 answer
MySQL retireive rows in sorted order on a very large table
I have a MyISAM table T with the following schema:
f1 (integer unsigned not null) f2 (integer unsigned not null)
This table has an index on f2 and it currently contains 320 million rows, and is expected to grow at the rate of about 200,000 rows once…
TMM
0
votes
1 answer
Make a snapshot of a live mySQL database with myISAM & innoDB tables without locking
We have a live database in production where we are running out of space on the server. So I would like to transfer to a new server without any downtime (or as little downtime as possible). In general, I would also like to have a hot failover copy of…
Artem
- 183
- 1
- 1
- 6
0
votes
1 answer
row numbers for innodb tables
After converted a table from MyISAM to InnoDB, "show table status" command returns different row numbers to correct figure showed by "count(*)" command. That's probably due to compact row format used in InnoDB tables.
I wonder if there is a way to…
jack
- 1,725
- 5
- 21
- 25