MySQL : Open-Source, Relational Database Management System
0
votes
1answer
7 views
Which privileges for MySQL extended status?
If I want to execute "SHOW STATUS" within MySQL or use "mysqladmin extended-status" on command line with a non-root user, which privileges would this user then need?
0
votes
0answers
11 views
Recommended hardware for dedicate sever using MySQL for POS (point of sale) [closed]
I'm having some doubts about this point in my project (it's social service).
The POS have developed on VB.NET using Visual Studio 2010.
The MAXIMUM number of POS that is thinking to attend this server ...
0
votes
1answer
17 views
Mysql suddenly stopped after is said to be crashed
We have a mysql instance running well and suddenly it stop. I have gone through the logs file but found no indication why it stopped? But there have some instance start and stop before this? Below is ...
0
votes
1answer
12 views
mysql error creating table
I was creating a DB with mySQL, and this error appeared:
Can't create table 'projectefinal.apuntats' (errno: 150)
I've got this:
CREATE DATABASE IF NOT EXISTS projectefinal
CREATE TABLE IF ...
1
vote
3answers
38 views
Correct way to perform an UPDATE on multiple tables?
This query is working, but I am only just beginning to understand relational tables. I have spent the last few yeas doing all of the processing with PHP after retrieving the data I needed (oftentimes ...
1
vote
1answer
23 views
MySQL: OPTIMIZE after TRUNCATE?
Using MySQL (either InnoDB or MyISAM tables--I have both), if I TRUNCATE a table and then LOAD DATA INFILE, should I issue an OPTIMIZE TABLE call after the LOAD? It's unclear to me if this is a ...
1
vote
1answer
17 views
extra steps after changing storage engine and adding index
Someone told me to look into his website for quick optimization; I'm a programmer and i don't have much experience optimizing databases.
I have a php/MySQL site uses the MyISAM storage engine. It ...
1
vote
2answers
30 views
Recursive query in mysql
I am using GetAncestry function found at this post, The problem is when I try to use it with select query Mysql hang, I am not sure why it is happens my Mysql version is "5.5.16" any help appriciable
...
0
votes
2answers
15 views
How does mysql transaction works?
I already know how to use transactions, what I want to know is how MySQL transaction handles data being processed...
For example, consider the following:
1. I have 2 databases (db1 and db2) ...
0
votes
1answer
21 views
ERROR 1034 (HY000) : Wrong aligned block, while importing in mysql
I got a SQLdump from my database and now I want to import it in to an other mysql server with same version(5.5.22-0ubuntu1) in ubuntu 12.04 .but at the middle of importing, it said:
ERROR 1034 ...
0
votes
1answer
23 views
How to fetch min value for different node ids in a same row?
Here is my First table structure:
table 1
id | nid
1 | 11
2 | 11
3 | 22
4 | 22
5 | 33
6 | 33
7 | 44
8 | 44
table 2
id | value
1 | 4000
2 | 3000
3 | 5000
4 | 4000
5 | 6000
6 ...
0
votes
1answer
22 views
create database table with a owner in my SQL
Can someone tell me what is the SQL command to create a table with specific owner?
1
vote
1answer
11 views
mysql column naming conventions for foreign keys
Lately I've been thinking about what's a better name for foreign keys, either user_id, or id_user style.
Personally I think id_user style is better for handling within database (db queries) where ...
2
votes
1answer
28 views
Show all results for past N “insert batches”
Every once in a while I have several users check in with some value:
+-------+-------------+------+---------------------+
| id | user | RT | time |
...
0
votes
1answer
41 views
MySQL my.cnf Optimization
We are an email marketing company and we recently switched our setup to MySQL. We need to configure MySQL (my.cnf) for extreme performance.
We have tried to configure my.cnf but heavy queries got ...
