MySQL : Open-Source, Relational Database Management System
0
votes
2answers
17 views
What is the size of currently-existing tmp tables in innodb?
This is yet another "how to add a column to a gigantic table" question. The table on disk takes 2.5GB, and I have around 10GB of ram I can use. I have a feeling I can crank up the tmptablesize option ...
0
votes
0answers
21 views
Performance difference between MySQL and PostgreSQL for the same schema/queries
I'm a newbie DBA, and I have experience in Microsoft SQL Server but I want to jump to FLOSS.
I'm starting a company, and we develop an app (PHP) with a Postgres backend, and we did some tests ...
-1
votes
0answers
17 views
information_schema.table_constraints doesn't exist error in MySQL
I'm new to this and Googling didn't help me with this one. I'm trying to check whether a foreign key constraint already exists like this:
$sql = 'SELECT `constraint_name`, `table_name` FROM ...
0
votes
0answers
13 views
MySQL not using resources?
Hi I have a decent setup: 16Gb RAM and a 4 cored CPU. I'm on a 64-bit Windows OS with MySQL Ver 14.14 Distrib 5.5.24 Win64 (x86). I am also using InnoDB.
The query I am using to test the setup is a ...
1
vote
1answer
25 views
Issues converting MyISAM table to InnoDB (auto column issue)
I'm having issues trying to convert a table from MyISAM to InnoDB in MySQL 5.6.
The following is the table dump:
--
-- Table structure for table `companies`
--
DROP TABLE IF EXISTS `companies`;
...
0
votes
0answers
17 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
0
votes
0answers
27 views
InnoDB tuning with 1G of ram limit
I am trying to calculate variable moving averages crossover with variable dates.
That is: I want to prompt the user for 3 values and 1 option. The input is through a web front end so I can build/edit ...
0
votes
0answers
14 views
MySQL Read Speed and Partitioning on Separate Drives
Introduction
Simple project but for an heavy read load(90% reads) over table(~20Milion Rows ever growing) (where I have to boost performance and ensure response low time for read queries)
that was ...
0
votes
0answers
33 views
Mysql float(13,3) not taking 10 digits [duplicate]
I have a total amount field of type float(13,3). When I tried to insert 123456789 to that field, the data changed to 123456792.000. I am not getting any truncate error. But data is changing while ...
0
votes
0answers
21 views
Defacto way of fixing constraint issues without downtime?
I come across two constraint issues all the time (UNIQUE, and referential integrity constraints) within InnoDB. My question is when these issues arise reproducibly what is typically the solution? I'm ...
0
votes
0answers
8 views
Mysql query browser can't connect, Toad, Perl, workbench and command line can?
Mysql query browser used to work fine then suddenly stopped working:
cannot connect to database server. Your connection attempt failed for user 'brianp' from your host to server at viper:3306: Could ...
3
votes
2answers
37 views
Why would I use the MySQL “system” command?
What can I do with the MySQL client's system command? Why does it exist?
The most productive use I've seen is to look around the file system (e.g., to remember the file name you want to SOURCE or ...
0
votes
1answer
16 views
I can't install db-mysql in node.js
When I execute this command: npm install db-mysql, I get the following result. What's the solution to this problem?
C:\Users\Mouad>npm install db-mysql
npm http GET https: ...
1
vote
1answer
47 views
Get data from two tables with recursive relationships
I have a MySQL 5.1 DB, being used behind a PHP application to track permissions and other items that need to be issued to staff that hold various positions within an org. To track what privileges a ...
1
vote
1answer
14 views
xtrabackup backup grants?
I'm using MySQL 5.5 + Opensuse 12.3 .
After face an issue with mysqldump (appear be a bug with OpenSuse Mysql distribution) I have looking for others backup solution.
I found the xtrabackup from ...
