myisam Questions
5
Solved
Below query I'm executing in Ubuntu 12, MySQL 5.1 version and receiving error as mentioned:
CREATE TABLE mantis_config_table (
config_id VARCHAR(64) NOT NULL,
project_id INTEGER NOT NULL DEFAULT...
Breazeale asked 13/7, 2012 at 13:2
10
Solved
In some cases, running an UPDATE statement in production can save the day. However a borked update can be worse than the initial problem.
Short of using a test database, what are options to tell w...
2
Solved
I fairly new to MySQL database. I am repeatedly seeing an error from MySQL saying the table is marked as crashed and should be repaired. However I am able to repair the crashed table by using the c...
2
Solved
I've seen many threads about this error, but the solutions I've found don't seem to be applicable in my case.
I've received a rather large (~150Go) dump file from an Oracle database.
I converted it...
14
Solved
My MySQL database contains several tables using different storage engines
(specifically myisam and innodb). How can I find out which tables are
using which engine?
8
Solved
What is InnoDB and MyISAM in MySQL ?
5
Solved
I've heard that MyISAM tables can become corrupt, what sort of actions are most likely to corrupt them and how can you safely fix said corruptions.
6
Solved
We have a Laravel application (version 5.4.18) which is connected to MySQL (5.6.38) database (300k rows totally), MyISAM type.
And we have api-response like Model::with('anothermodel')->paginate...
Scrumptious asked 6/6, 2018 at 18:45
14
Solved
Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I'd like to use VARCHAR as the primary key for reference lists (think US States, Country Codes)...
Resolution asked 1/12, 2008 at 21:26
2
Solved
I am writing a web-app for my studies which includes fulltext search and foreign keys.
I have read somewhere, MyISAM engine is suitable for fulltext searching, and InnoDB for foreign keys.
In thi...
8
Solved
Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as the ID. info is a table that contains information ab...
Faience asked 29/4, 2011 at 18:38
4
Solved
I have the following two tables in my database (the indexing is not complete as it will be based on which engine I use):
Table 1:
CREATE TABLE `primary_images` (
`imgId` smallint(6) unsigned NOT...
Reportage asked 20/9, 2011 at 22:55
25
I'm working on a projects which involves a lot of database writes, I'd say (70% inserts and 30% reads). This ratio would also include updates which I consider to be one read and one write. Th...
Bimetallism asked 21/8, 2008 at 14:50
2
Solved
I have a log table that is currently 10GB. It has a lot of data for the past 2 years, and I really feel at this point I don't need so much in there. Am I wrong to assume it is not good to have year...
2
Solved
OS=centos 6.7 [Dedicated server]
memory=15G
cpu=Intel(R) Xeon(R) CPU E5-2403
mysql= V 5.1.73
Here is a MyISAM table and contains about 5 million rows of data. In every 5-6 minutes data for about...
Rotatory asked 4/5, 2016 at 8:56
3
Solved
I have 2 tables: comments and comments_likes.
comments
id
message
likes
triggers:
AFTER DELETE
DELETE FROM comments_likes WHERE comment_id = OLD.id;
comments_likes
id
comment_id
t...
2
Solved
I am new to MySQL and I know very little about it.
The problem I am facing is as mentioned below:
Previously I had data which had MyISAM as its MySQL engine and it used to take around 15 minutes...
3
Solved
Is there an easy way to turn a mysql table into a redis equivalent?
I have a myisam table in MySQL that is basically used as a key-value store that I want to "move" to Redis so it will be super fa...
2
Solved
I have a project to maintain, The persistance layer of this project uses JPA and Hibernate and it is running on a MySQL server, the database is not relational and the engine is MyISAM on all tables...
Cleveland asked 6/8, 2015 at 15:39
3
I have a set of tests in my Django application that used to pass, but at some point of the software evolution I started to get this kind of message when I run the tests:
Error: Database test_totom...
5
Solved
I have a user table with field lastusedecnumber.
I need to access and increment lastusedecnumber.
During that accessing time I need to lock that particular user row (not the entire table).
How d...
4
Solved
Is there a way that I can get the time of a MySQL query (specifically with PHP)? The actual time it took to complete the query, that is.
Something such as: Results 1 - 10 for brown. (0.11 seconds)...
2
I have a Mysql master-slave(s) replication with MyISAM tables. All updates are done on the master and selects are done on either the master or slaves.
It appears that we might need to manually loc...
Frustule asked 1/6, 2012 at 23:12
4
Solved
I've read various threads about which is better between InnoDB and MyISAM. It seems that the debates are to use or the other. Is it not possible to use both, depending on the table?
What would be ...
Harald asked 2/1, 2011 at 4:1
3
Solved
I'm completely lost as to how or why this error is displaying when I go to browse the table data.
The one thing I did notice was that the Storage Engine has been switched to MyISAM with InnoDB sa...
Ranchod asked 18/3, 2012 at 18:44
1 Next >
© 2022 - 2024 — McMap. All rights reserved.