Questions tagged as 'innodb'

Tagged questions
1
answer

Pass tables from MyISAM to InnoDB in MySQL

I have a database that stores content from several years ago in various tables. All the tables are currently in MyISAM and I want to pass them all to InnoDB . How could I do it without risk of data loss? I do not put what I...
asked by 17.01.2018 / 19:01
1
answer

INNER JOIN between InnoDB and MyISAM tables

I am developing a database, therefore some tables will have MyISAM Storage Engine and other InnoDB. My question is this: are there problems when performing INNER JOIN with tables that handle different Storage Engine?     
asked by 10.12.2017 / 03:14
3
answers

MySQL storage engine (MyISAM to INNODB)

I have a hosting on GoDaddy, I was testing, perform some tests with (begin, rollback, commit) transactions, which had no effect. I was investigating and I realized that "MyISAM" does not allow transactions, so I assumed that the storage e...
asked by 09.06.2018 / 06:14
1
answer

Problem when saving row in DataSet using ADO.net

I bring you another little problem that came up during my project (which is almost finished already). What this code is supposed to do is create a new "Artist" row, add it to the dataset (in its datatable) and update the database. Well, it's cle...
asked by 16.11.2018 / 17:53
1
answer

Optimize Mysql InnoDB tables

I have a MySQL database of almost 15 GB with many tables, some of them gigantic. I wanted to do the optimization task but being INNODB is not possible. From what I have been told this database has been running since 2000 and has nev...
asked by 12.04.2018 / 08:21
1
answer

Syntax error when trying to insert data into MYSQL with php

When trying to insert the parameters of "User" and "Password" extracted from an HTML form, I miss an error of mySQL Syntax. This is my code when inserting my code require_once ('Conecction.php'); try { // Iniciar la conexión a la base...
asked by 19.03.2018 / 20:32
0
answers

MySQL Group Replication: Error with MySQL Router

I have a problem trying to instantiate the Mysql Router . When executing this command mysqlrouter --bootstrap [email protected]:3306 --directory /opt/myrouter -- user=mysqlrouter --force This error appears:    error: no result returned f...
asked by 19.07.2018 / 23:32
0
answers

Problem with MariaDB database, InnoDB tables, queries are blocked

Since a few weeks ago I am having problems with one of my databases, all the queries made are blocked and they take a long time to execute, regardless of which table they are made in (Even queries like SHOW PROCESSLIST are slow) This a...
asked by 12.05.2018 / 21:09