Tagged Questions
MySQL : Open-Source, Relational Database Management System
0
votes
0answers
3 views
Select changes in table by date
I have following table schema
name type
id int
key string
count int
date date
url_id id
with example data
id key count date url_id
1 system 100 ...
0
votes
0answers
2 views
Any way to force “garbage collection” in TokuDB?
Playing around with TokuDB I'm finding even after "optimize table" for things such as changing row compression or other DDLs it takes a non deterministic amount of time for freed space to be reflected ...
0
votes
1answer
16 views
Can't create table, but table doesn't exist
I'm using these steps to create a table my_user, that already existed but somehow vanished from my database my_db:
mysql> USE my_db;
mysql> DROP TABLE my_user;
mysql> ERROR 1051 (42S02): ...
0
votes
1answer
4 views
Sync MySQL 4.0 table to MySQL 5.6 server every few minutes
I am tasked with getting a copy of a table on a MySQL 4.0 server synced to a completely different database on a MySQL 5.6 server every few minutes for the purposes of having that table available ...
0
votes
0answers
2 views
Is there any relation between BSON storage for mongoDB and MySQL storage?
I am working on an application where I need to make analysis that what will be the storage size of BSON structure if same data is stored which is stored in MySQL. Basically I am comparing MongoDB and ...
0
votes
0answers
16 views
Two MySQL requests at the same time - Performance issue
I have a MySQL server with many innodb tables. I have a background script that does A LOT a delete/insert with one request : it deletes many millions of rows from table 2, then insert many millions of ...
0
votes
1answer
11 views
Insert pictures
I need to create dictionary with pictures.
I created database of words in mysql
I tried to collect pictures of each word.
How can insert pictures into tables?
0
votes
0answers
16 views
Installing database
I have created database in my system using mysql.I tried to use in one of my friend's system.How can install the database in other system?
0
votes
2answers
19 views
SELECT query with referenced subqueries
How does one reference the currently-grouped by field in a subquery?
Consider a table with the following data:
Client Status Size
1 A 500
1 B 1500
2 ...
0
votes
0answers
7 views
eCommerce product table design - MySQL
I am designing database for an web application, I have designed the product and specification details database as follows,
create table pr_size
(
size_id int not null auto_increment,
...
0
votes
0answers
5 views
Mysql / ASP.net Timeout IO error
I have the following MySQL Query that when executed in my aspx page, yields a connection timeout error - the connection timeout is 15 which is the problem but I can not change it - have tried changing ...
1
vote
1answer
16 views
Options to include with mysqldump when taking backup of hybrid databases
I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM.
Now I've ...
0
votes
1answer
19 views
How can i Backup --all-databases without mysql database ?
i want to backup all database on mysql server without mysql. How can i do it ?.
Thanks.
0
votes
1answer
10 views
Will my query pick up where it stopped due to connection timeout?
I am doing a rather large query that hits MySQL connection timeout. I know how to change the timeout parameter, but I'm also query from a laptop that can't be left running for long.
The database ...
0
votes
1answer
14 views
Remove all duplicate data in mysql
I want remove all duplicate data from my table. anyone help me.
my table :
biblio
one
one
two
three
three
four
five
i want to get result like this
biblio
two
four
five
0
votes
0answers
10 views
mysql restoration suddenly became slow
Recently I reinstalled couple of servers from Ubuntu to RHEL. I was having problems in restoring the mysql database from the dump file. I modified the below parameters in the /etc/my.cnf file.
...
0
votes
0answers
10 views
MySQL remote connection: Public vs. private IP address
I just went through the obligatory pain of getting MySQL to accept a remote login. Yes, I had to create a user of the form ''@'%', and I did so. Yes, I had to GRANT ALL ON . to my new '@%' user and ...
0
votes
0answers
9 views
Create multiple columns after summing a single column
I have a single MySQL table, which includes company names and orders covering a 10 year time span. I want to create a query which summarizes the totals by company and creates a column with the totals ...
0
votes
0answers
6 views
MySQL One - to -Many Select Statement in Single Column
I'd like to output this tabular structure from a Select Statement, if possible:
TaskID TaskTitle Users
1 Trash John, Barry
2 Dishes Spencer
3 Dusting ...
0
votes
1answer
40 views
Duplicate Relationships in Rails/MySQL Healthcare Application
Overview of the Application
I am building a Ruby on Rails application to organize medications, using MySQL. The goal of this application is to provide dosage specific treatment recommendations, and ...
0
votes
1answer
39 views
How to transfer 70GB MySQL with no downtime?
I have a large amount (4000) of individual databases, 90% of which are small. They all include about 20 tables each, and in total, they use about 75GB of space. All tables are MyISAM.
I want to ...
0
votes
0answers
9 views
Redesign tables, multiple foreign key and related table to same table
Hello I have this database:
Table Teams is used in each one table.
Match table contains teamA and teamB and round contains team that win the SET and team that start the set.
But I dont know how I ...
1
vote
0answers
14 views
Optimization Tips For MYSQL Tuner/Primer
So I have a site that has a crap ton of traffic. I see a decent amount of latency when the site has over 1,000 active visitors on it. I have new relic installed and it seems Im only using 10% of the ...
0
votes
1answer
9 views
Get devices with not driver assigned
I have this related tables:
And I need to get those devices with no driver assigned, in other words the device returned on this query shouldn't be on driver_has_device table since it'll not have ...
0
votes
0answers
32 views
Database/Storage engine suggestion for a project involving heavy inserts?
I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
0
votes
0answers
10 views
how to change purchase order from pending status to recieved status in erp
i have a database for erp which is for electronic goods.
i have to make purchase order from pending status to received status after user receives it.
i have to reflect the change in database. should ...
0
votes
0answers
9 views
How to get Table relationship Diagram in MySql? [on hold]
In My Sql I have database TestDb.It Contain ten Table know i want to Ten table Relationship Diagram i am using SQLyog 7.01
1
vote
1answer
25 views
“Limit 1000,25” vs “limit 25 Offset 1000”
Recently I've found out that MySQL has a offset feature. I've been trying to find documentation about the results of offset, or the difference in between offset and the limit variant, but I can't seem ...
0
votes
0answers
8 views
0
votes
0answers
7 views
MySQL Chain Replication without log-slave-updates
I have three server's say
A -> B-> C
B as both Master and Slave.I have enabled log-slave-updates in B server so that replication is possible on C. So what if happens when log-slave-updates is not ...
0
votes
1answer
15 views
serial numbers for products
Let's say I'm selling 3 products. I have a products table with id and name (so that table would have 3 entries). I want each product to have a serial number, each independent from one another, but I ...
0
votes
1answer
9 views
about email trigger in mysql server
I am trying to send email using mysql server when all my test scripts execute.I just need to send my test results in table format in email using mysql server.Could anyone help me out?
I just find ...
0
votes
1answer
34 views
Does having a big table that I do not query cause the whole DB to be slower?
I have a log table that I use for logging files sent to clients.
I'm not querying that table, just use it for logging (INSERT) and when I need to check when something was sent to clients, usually once ...
-1
votes
0answers
18 views
C++ MySQL_Connect issue [on hold]
Below is some code I wrote for a function that is supposed to always be running on its own thread checking a database for new information and appending the new information to global vectors. The issue ...
0
votes
1answer
11 views
Mysql error : Slave SQL Could not execute …on table
Im running a percona cluster of 3 nodes.
Yesterday I needed to throw some more memory in them, so I had to power down all nodes
Now I booted up and then my 3rd Node, Gave me this error :
140701 ...
1
vote
0answers
13 views
Architecture for a MySQL MDBS
My coworker and I are tasked with redesigning our current Access databases in a MySQL environment. Between the two of us, this wont be a problem but we need to connect to other external databases that ...
1
vote
1answer
12 views
Combining Tables in MySQL
I have two tables, which are very similar, in MySQL. I want to combine them into a single table with new column names. Some of the column names in Table1 or Table2 may not be used in the new ...
0
votes
1answer
30 views
Thousands of rows in table [on hold]
I have a project that requires data to be sent to a mySQL database every 5 seconds or so. Each write/row will be about 1kb and I calculated this to be about 140000kb/rows per month per user. Data is ...
0
votes
0answers
11 views
output from mysqltuner.pl (from mariadb.service)
While running mysqltuner.pl script, I'm getting following message:
[OK] Currently running supported MySQL version 5.5.35-MariaDB-log
[OK] Operating on 64-bit architecture
-------- Storage Engine ...
1
vote
1answer
15 views
How to create trigger with NOT FOR REPLICATION
I tried adding "NOT FOR REPLICATION " in many parts in the below code but ended up in the below code. I searched a lot for an example where I can see how its done with a trigger.
Can any one show me ...
1
vote
1answer
21 views
MySQL Cursor Batching Process
I have a cursor in MySQL and what I want to do is rather than having an enormous cursor loop that can be up to 4000+ users in size, do it smaller batches so that the MySQL engine doesn't suffer. I ...
0
votes
0answers
4 views
mysql service failed to start when datadir changein ubuntu
I have dual Operating system on PC, windows 8 and ubuntu 14.0, and I am mostely using ubuntu because my MySql database is hosted on ubuntu. Recently when I am trying to restore my database, which is ...
0
votes
0answers
12 views
How do I stop views (large data sets) from freezing my database
I am working with tables that contain upwards of 200,000 rows. My boss wants to use views that refer to other views in order to have things be more automated. The problem is that the MySQL server ...
0
votes
1answer
27 views
MySQL replication error 1594
Is there a way to restart replication without going over MySQL :: MySQL 5.1 Reference Manual :: 16 Replication.
I'm NOT seeing ANY errors on master and I'm not entirely sure why slave is ...
0
votes
0answers
8 views
Percona cluster + Wordpress blogs, low performance
We currently run ~ 900 WordPress blogs on several machines so was decided to move to load balanced environment with clustered db.
I followed instructions from ...
0
votes
0answers
15 views
Innodb Deadlock During Insert
What could be the reason behind 2 inserts causing a deadlock? Here is what I get from log file:
*** (1) TRANSACTION:
TRANSACTION 6CA06B9, ACTIVE 6 sec inserting
mysql tables in use 1, locked 1
LOCK ...
0
votes
1answer
15 views
MySQL server parameters default empty string to null
How can I set MySQL server parameters to default empty strings to null on insert?
is this possible?
0
votes
1answer
25 views
getting “table is full” error even if the table size is much smaller than tablespace
Currently I am using MySQL NDBCluster 7.3.5.
I have created one UNDOFILE hhme.dat with INITIAL_SIZE=200m.
Also one tablespace hhmefep_tbs with DATAFILE hhmefep_tbs.dat having INITIAL_SIZE=500M ...
0
votes
0answers
11 views
Excesive use of RAM on MysqlServer
The RAM of a server where I have installed mysql is always 100% and looking at the processes that are running, MySQL is the most consumer on CPU and memory and I can see the cause of great use RAM.
...
2
votes
1answer
24 views
MySQL InnoDB transactions with lot of delete instructions
We have a process that runs frequently and does the following steps on a mysql database of type innodb.
SET autocommit = 0;
DELETE FROM table WHERE category='something';
-- every 300 rows or whatever ...
