innodb Questions
7
5
in phpMyAdmin I can see all databases and tables. But when clicking on any table I get the error
Error #1932 - Table 'mytablename' doesn't exist in engine
I tried a lot of solution advises found on...
1
I've noticed that I can't create two different foreign key constraints that have the same name, regardless of the set of tables in the schema that they're affecting.
Which I can cope with that, I ...
9
Solved
We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the InnoDB tables are corrupted, with timestamp out of order errors in the transaction log, and...
2
I'm adding a "search by email" functionality on my contacts database table (MySQL, InnoDB engine) for our CRM system. I added the FULLTEXT index and partial searches like this
WHERE MATCH(cc.email...
3
Solved
I have read several times that after you delete a row in an InnoDB table in MySQL, its space is not reused, so if you make a lot of INSERTs into a table and then periodically DELETE some rows the t...
24
Solved
I'm trying to add a row to an InnoDB table with a simply query:
INSERT INTO zip_codes (zip_code, city) VALUES ('90210', 'Beverly Hills');
But when I attempt this query, I get the following:
E...
15
I have an issue with MySQL. When I'm trying to start it, that gives me an error message, which is
2015-12-10 10:52:31 13f4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. Thi...
5
I have an mySQL update query that will sometimes update all the fields and sometimes it will update all the fields except one.
It is failing on about 10% of the calls.
My table is:
CREATE TABLE...
4
Solved
Consider that there is a bunch of tables which link to "countries" or "currencies" tables.
For making data easier to read I'd like make CHAR field with country code (eg US, GB, AU) and currency co...
Miletus asked 14/9, 2009 at 0:26
9
Solved
I have a caching problem when I use sqlalchemy.
I use sqlalchemy to insert data into a MySQL database. Then, I have another application process this data, and update it directly.
But sqlalchemy...
Traver asked 18/4, 2012 at 13:10
14
I found many similar question on Stackoverflow but didn't get the exact error solution.
My issue is when starting MySQL service on one of the Dedicated Centos 6.5 machine, I am getting error :
141...
Palter asked 18/10, 2014 at 12:29
3
Solved
Can somebody explain how mysqldump --single-transaction actually works for transactional tables, like InnoDB? I've read the official documentation but still have no clue. Does it perform per table ...
Lippe asked 16/1, 2017 at 18:49
6
Solved
I have a database with the following stats
Tables Data Index Total
11 579,6 MB 0,9 GB 1,5 GB
So as you can see the Index is close to 2x bigger. And there is one table with ~7 million rows that t...
Zyrian asked 19/4, 2011 at 8:2
2
Solved
I'm using official MariadDB 10.7 docker image, Windows 10. Had this error started today that kept repeating, tried everything:
- mysqlcheck -Ar
- delete docker image with all the data
- chkdsk -F
-...
Hube asked 20/1, 2022 at 10:19
3
Solved
I have the need to get last id (primary key) of a table (InnoDB), and to do so I perform the following query:
SELECT (SELECT `AUTO_INCREMENT` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA...
Collection asked 19/12, 2018 at 16:17
32
Solved
I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB.
I am wondering if there is a way to quickly change all of them to InnoDB?
10
Solved
I am using MySQL in localhost as a "query tool" for performing statistics in R, that is, everytime I run a R script, I create a new database (A), create a new table (B), import the data into B, sub...
12
Solved
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`purchase_date` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAUL...
3
I'm using Laravel 5.1.
The queues are used for data fetching/syncing between several systems.
I use the database driver, 3 "artisan queue:work --daemon" processes are running all the time.
The j...
11
I've created a table in MySQL:
CREATE TABLE actions ( A_id int NOT NULL AUTO_INCREMENT,
type ENUM('rate','report','submit','edit','delete') NOT NULL,
Q_id int NOT NULL,
U_id int NOT NULL,
date DAT...
Verniavernice asked 19/12, 2008 at 3:51
4
Solved
2016-03-14 02:30:29 58150 [ERROR] InnoDB: Unable to lock ./ibdata1,
error: 35 2016-03-14 02:30:29 58150 [Note] InnoDB: Check that you do
not already have another mysqld process using the same I...
Wig asked 14/3, 2016 at 1:41
27
Solved
Is there a nice easy way to drop all tables from a MySQL database, ignoring any foreign key constraints that may be in there?
Adjunct asked 13/8, 2010 at 12:28
3
Solved
Whenever i fire this query from one of the mysql client (emma):
CREATE TABLE `tbl_mappings` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`private_id` int(11) unsigned NOT NULL,
`name` tinyt...
2
Solved
Here is my table :
In my table
Clustering_key (Primary key and auto incremental)
ID (Index Column)
Data (Text datatype column)
Position(Index column) maintain the order of Data
My table hav...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.