Tagged Questions
MySQL : Open-Source, Relational Database Management System
0
votes
1answer
11 views
INSERT take too much time
I have in my MySQL DB a few tables
Most of the time, I'm only doing INSERT in my db. I have up to 4 connections to the DB, each one inserting into a different table. There cannot be two connections ...
1
vote
1answer
19 views
Backup architecture for frequent backups of business critical DB
We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
0
votes
2answers
95 views
What is the performance difference between IN (42) and id = 42 in MySQL?
Are there any performance differences between
SELECT *
FROM table
WHERE id IN (42);
and
SELECT *
FROM table
WHERE id = 42;
?
The question is about just supplying a single value. The ...
0
votes
1answer
34 views
Ask about Inner Join & Union
i want to ask about my script this is doesn't work. i need to help !
SELECT A.*,B.mat_nama,C.mats_nama
FROM pengeluaran AS A
INNER JOIN(material AS B) ON(A.mat_id = B.mat_id)
INNER JOIN(mat_satuan ...
1
vote
1answer
28 views
Converting XML to SQL tables
I have a large XML file in the following format and I need to convert this file into a MySQL table. Please let me know how can I accomplish this?
~~~~~~~~~~
<host starttime="1392325468" ...
2
votes
1answer
25 views
Can I configure MySQL replication to break when I run a “drop database” or “drop table” command on the master?
Basically, what the title says. This would enhance the failover quality of our systems, becuase we have run into issues of people thinking that they were in a test environment running drop statements ...
0
votes
0answers
28 views
Should My App Use MySQL Or FTP? [on hold]
I have an application and website that communicate with a user file residing on an ftp server.
Processing proceeds as follows:
1) User signs up
2) Application creates a file with required data
3) ...
0
votes
1answer
34 views
How to structure a database to show data for each USA State and Canada Territory on a Per user basis?
I need to build a PHP/MySQL application. I am a bit confused on how to do the database for a project like I am about to explain though.
The end result will be a Map of the USA and Canada. Each ...
0
votes
1answer
14 views
Digital content eCommerce schema advice?
I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be ...
0
votes
0answers
22 views
SUM a new value to an existing valuea
I have a php script which processes a form with a single input.
I want the value I send through input to be added to an existing value in database (mysql).
For example in database I have value = 10
...
2
votes
1answer
34 views
Get results ordered by a specific column in a looping way
I have heavy difficulties in getting rows ordered in an special way. Two tables are part in this:
Table 1 - WORDS:
id | char | word | categoryid (<- id of a row in CATEGORY)
Table 2 - CATEGORY: ...
0
votes
0answers
9 views
How to automatically Reset Query Cache for improve table cache hit in MySQL?
I have a VPS running CentOS 6.4 and 2.5GB RAM, Intel(R) Xeon(R) CPU. Its MySQL version is Server version: 5.5.35-cell. I have two active wordpress sites and two inactive sites (inactive sites use for ...
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
11 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
MySQL: What points should we consider when create composite index
There are multiple views behind the logic of creating composite index in a table. Creating composite index is obvious when we have composite primary key.
Beside this, we create composite index on the ...
