InnoDB : MySQL's ACID-compliant Storage Engine
0
votes
0answers
3 views
MyISAM with Innodb in the same Wordpress database reduce performace?
My new Wordpress database all the Wordpress created tables use InnoDB engine and plugin created table use MyISAM. But older site database all the tables use MyISAM table engine.
If I use two ...
0
votes
0answers
20 views
row locking with innodb [duplicate]
What is the most efficient way to lock a specific row for within a mysql transaction.
I am currently using for update using select is there another method that im unaware of?
if not are mysql locks ...
1
vote
1answer
12 views
mysql multiple database prioritize innodb buffer pool size
With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?
0
votes
0answers
15 views
Temporary table created on disk, with 14mb of database
i have only one database (on one machine) with size 14 mb
for temporary table i have this configration
max_heap_table_size= 1000M
tmp_table_size= 1000M
sort_buffer_size=4M
join_buffer_size=4M
i ...
1
vote
1answer
38 views
row locking within ACID transaction innodb
I have a financial transaction that looks something like this (pseudo):
begin
select record for update
update record(same record as selected)
insert another record into another table
...
0
votes
2answers
29 views
MySQL High Availability for InnoDB
I am looking for MySQL High Availability with huge transactions. I prefer to go with InnoDB Engine.
I prefer to use MySQL Master - Slave Replication. However, this option provides us Manual fail over ...
0
votes
0answers
32 views
Recovering Database from server
my server has some issues and isn't able to start the mysql service. I still have access to the server via shell. So I can get all files I want to have.
So I found this guide ...
1
vote
1answer
38 views
MySQL, temporary on disk table on primary key retrieval?
MySQL 5.5.24, Windows 7 64-bit.
I've InnoDB table with primary key defined on three columns:
CREATE TABLE `common_descriptions` (
`object_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
...
1
vote
0answers
37 views
Does union all have an enforced ordering
I know that a union does a de-duplication so can jumble the results, but I can't find a definitive answer for union all
Example query
select id from
(
select id from table where id = 1
union all
...
0
votes
2answers
37 views
Abnormally high MySQL writes and larger than normal Binary Log files. How can I determine what caused this?
We have a MySQL master database which replicates to a MySQL slave. We were experiencing issues where MySQL was showing a high number of writes (but not an increased number of queries being ran) for a ...
1
vote
1answer
22 views
What is a storage need for MySQL index on Varchar(100) in InnoDB?
I have a InnoDB table, which has EMail column (VARCHAR(100)), now I will run script which will hash some of that email addresses. I am wondering, if there is a difference in data storage (for example ...
1
vote
1answer
52 views
InnoDB: very bad performance on INSERT/UPDATE
Lately I have really big problems with INSERTs and UPDATEs. On my website 80% of all queries are SELECTs but in query slow log there are only INSERTs and UPDATEs. My dedicated server has 32GB RAM, ...
0
votes
1answer
40 views
I have delete database from mysql but storage is not freed
I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage?
I have a mysql database that the total ...
4
votes
1answer
175 views
MySQL 5.1 to 5.6: massive performance hit
Okay, this is possibly three questions. I want to move my existing MySQL 5.1 database using MyISAM to 5.6 using InnoDB for what I think are a host of obvious -- and possibly even good -- reasons.
...
0
votes
1answer
34 views
Copying MySQL tables, InnoDB tables not recognized
I have to set up a database copy on my local computer.
The problem is that that I have given just the raw database table files (.frm, .ibd, .MYD, .MYI).
I created the database by creating a folder in ...
