MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
10 views

Online database for test [on hold]

I want to start working with 0XDBE. so I'm asking if there is an on line database(Mysql, Oracle, DB2...) with schema and tables to test the software with? thanks.
1
vote
0answers
13 views

MySQL Filesort/Order By Slow

I've been struggling with a query for the past few weeks and it now just appears as gobbly-gook to me when I try to optimize. The query runs - at about 2.3 seconds, but I know there has to be a more ...
1
vote
2answers
13 views

sql join with laravel query builder

I have a transactions table with the following field: Transactions ID | amount | branch_id | supplier_id 1 | 1,200 | 2 | 1 Subsidiary ID | Name | Type 1 | supplier1 | 0 2 | ...
1
vote
0answers
13 views

MariaDB 10 InnoDB Partition with Data Directory

mysql --version mysql Ver 15.1 Distrib 10.0.20-MariaDB, for Linux (x86_64) using readline 5.1 I have a MariaDB 10 installed, though I tried with the 5.5 release in the CentOS repos. I'm ...
2
votes
2answers
51 views

Are junction tables a good practice?

Say I have a large table that holds the user's info and another table that holds several locations. Then I use another table that holds the user_id and the location_id. In order to retrieve the data ...
1
vote
0answers
16 views

Optimization of stored procedure MySQL [on hold]

I have a stored Procedure comparing two tables. This uses Cursor comparison logic , Source and the target cursors are used to compare two tables and find out the differences in tuples . This ...
2
votes
1answer
33 views

Fulltext search using multiple indexes

I have a table with several columns, say a, b, c, d that should be searchable. The problem arises when I need to search a, b, c separately from d (and vise-versa). AFAIK, there's no way to achieve ...
0
votes
0answers
15 views

Complicated MySQL table reorder

I should do really complicated tables reorder. ****The main table looks like:**** id - some data 1 - ... 2 - ... 3 - ... 6 - ... 9 - ... 12 - ... As you can see, there are "empty" IDs (no 4, 5 ...
1
vote
2answers
28 views

How to use a MySQL error handler in a stored procedure with prepare/execute

I have a procedure defined like this: drop procedure if exists drop_tables_like; delimiter $$ create procedure drop_tables_like(myint int, pattern varchar(255), db varchar(255) ) begin DECLARE ...
3
votes
0answers
29 views

Missing DB entries

I have run into a problematic situation. I oversee the administration of 5 php web pages on one server, each having their own database. All pages work like interactive forms drawing and storing data ...
-3
votes
0answers
7 views

a phpMyAdmon database question [on hold]

I have two tables in database of phpMyadmin. One table is symptoms table, and 2nd is diseases table. The symptoms table has two columns: smpid and symptom The diseases table have three columns: ...
2
votes
1answer
23 views

I created a DB schema for a project relating to collecting comments for web pages, is relational the way to go and how are my relationships?

I'm curious if relational DB is the way to go, if the current relationships in the diagram make sense, and whether it will bode well for coding.
0
votes
0answers
20 views

MySQL: Using DATE_SUB to subtract business days instead of all calendar days

I am looking for a robust solution to subtract the number of business days from a date. I am using DATE_SUB however it subtracts all calendar days. For example, if today is Monday and I subtract 2 ...
1
vote
0answers
26 views

Help with PHP code, SELECT from database [migrated]

<?php session_start(); include ('connection.php');?> <?php $username='pablorex192'; $consulta=mysql_query("SELECT question FROM users WHERE user = $username") or die ('This is the error: ...
2
votes
2answers
42 views

Modeling invoices and orders

I have a problem in modeling a database that contains orders and invoices. Actually it's more of a problem from a business point of view, but it's related to modeling the database nonetheless. Model ...
3
votes
1answer
32 views

Modeling discounts - Product specific and Customer specific discounts

I have a reasonably simple database but have the following problem: I'm modeling a store + a lot of non-relevant stuff database. I have the following problem. I want to allow for specific products to ...
3
votes
1answer
18 views

automatically change value on the table mysql

i have table invoice in my database that contain atributes 'due date', 'date' and 'status'. What i want is data on 'status' change automatically. Example, status (unpaid change to expired) when date ...
2
votes
2answers
16 views

Any ideas on how to parallelize mysql_upgrade?

I am migrating from 5.5 to 5.6 and would like to speed up the mysql_upgrade process. I have thousands of databases per machine and 200 tables (innodb) per db. Any suggestion how to speed up the ...
2
votes
0answers
16 views

Mysql high cpu usage - cpanel

After an update from whm, I see a high CPU usage from MySQL (5.6). my.cfg: [mysqld] slow_query_log=1 slow_query_log_file="/var/lib/mysql/slow-query.log" long_query_time=1 skip_name_resolve ...
1
vote
2answers
14 views

Mysql user accesable with out password from the host machine but not from the remote machine

I have setup mysql and created a user 'test' and have given a password for it. Strange thing I observed is, for test user I am able to access with out password from the machine I have installed mysql ...
2
votes
1answer
25 views

Is there any difference between 'LIMIT 0, 1' and 'LIMIT 1'?

I recently stumbled upon example codes, which differed by these notations. SELECT * FROM table LIMIT 0, 1 SELECT * FROM table LIMIT 1 The first argument should be considered as the offset if I'm ...
0
votes
0answers
13 views

nbsp character might not be passing as nbsp to the MySQL backend

I am following a tutorial where a web application written in PHP, blacklists spaces from the input(The 'id' parameter). The task is to add other characters, which essentially bypasses this blacklist, ...
1
vote
1answer
86 views

Does PostgreSQL support online schema modification (DDL)?

Recent versions of MySQL (using InnoDB) support many alter table queries without exclusive locking the table. Does PostgreSQL support this to any level? That is, can I add/drop columns from a table ...
-2
votes
0answers
16 views

performance of dml statements in mysql [on hold]

how can we increase the performance of insert and update statements in mysql procedure. and also if a procedure has only updates statements Blockquote ...
2
votes
1answer
17 views

Database design, many rows or many columns?

I am aware that this has been discussed before, but I've read conflicting information about this particular topic, so I'm hoping for a bit more decisive opinions from you. I have multiple tables, ...
1
vote
1answer
35 views

Update records from one table to another in different databases where condition is accomplish

I have two tables stored in two differents DBs and I need to perform some sync between both tables based on lastmodifieddate and lastSyncAt. Let's call them as db1 and db2. This is the DDL schema for ...
2
votes
1answer
32 views

Migrating Oracle 9i database to MySql database on a different Windows Server

I need to migrate my Oracle 9i database with all its tables from windows server 2003 to MySql on another Windows Server 2012. The oracle database is connected to Visual Studio web project. I have ...
1
vote
2answers
34 views

Need simple MySQL query for below description

I have a table with [1...n] columns. I want to retrieve first 3 column names of that table not the records. Should be something like this: Select column_name(3) from table_name="sample";
2
votes
1answer
67 views

Configuration required for a big mysql database around 20GB

I need to host a single machine database (constraints), wherein the database size is roughly 20gb. Most of the tables are in MyISAM. Any way I can actually run it with decent speed ? Alternatives I ...
0
votes
1answer
26 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
1
vote
1answer
69 views

two similar queries with different results (one very slow)

Two almost identical queries, but one is extremely slow. All tables are innodb. Explain statements attached, but I don't know how to resolve it. userHits (table structure) -id - int - primary ...
1
vote
1answer
30 views

MySQL: OPTIMIZE TABLE vs. myisamchk

I have a very large table (~50GB) and periodically rows are purged from it and I want to run OPTIMIZE TABLE to recover the space. But I do not have enough space to run it. If I do run it the server ...
1
vote
1answer
28 views

How to write marker messages into the MySQL general_log?

I'm build a performance testing harness for our distributed web app. I'm using JMeter to drive it by simulating poorly performing parts of the app from the web side. I've set up MySQL to log to the ...
1
vote
1answer
39 views

mysql replication and innodb_file_per_table

Is it possible for the master (5.1) to have innodb_file_per_table = 0 and for the slave (5.1 or 5.5) to have innodb_file_per_table = 1 ?
1
vote
0answers
39 views

Can I create a trigger in mysql and update the same to oracle database? [on hold]

I am trying to replicate data from mysql to oracle db. Is that possible by creating triggers in mysql?
4
votes
4answers
661 views

SQL query to find player with maximum runs

I have the following tables with me : Table 1 Title : Runs +------------+---------+ | P_ID | Runs | +------------+---------+ ...
3
votes
1answer
51 views

How can I get the last inserted id from an specific table from a given stored procedure?

I know about the existence of LAST_INSERT_ID() function... Though I am not quite sure about its behaviour... Does it take the last inserted id from the current user into account? Or uses all the ...
1
vote
3answers
75 views

Multi-table optimal database design

I'm a bit new to the database design. Thus this question to people who may have more experience. I need to design a database that needs to store statistical data for many systems. The data is ...
1
vote
2answers
24 views

Select data where column value exists in seperate rows for same reference id

This is on a MySQL database. Locations have services. What I want is to get all results where service_id is 2 AND 3, not OR so using IN is out I believe. Database ---------------------------- | ...
0
votes
1answer
29 views

How to test mysql for changes

I'm OCD person, I think I accidentally dropped something in my mysql. Problem is I've around 50 databases, and I cannot manually check everything :( Is there a way to check for these kind of ...
1
vote
2answers
27 views

Error: This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table

I'm trying to run this query in mysql Ver 15.1 Distrib 5.5.44-MariaDB, for Linux (x86_64) using readline 5.1 but got this error all the time: CREATE TRIGGER trig_companies_table_insert BEFORE INSERT ...
0
votes
0answers
21 views

vtiger: can't login with newly created user [closed]

When I create a new user in the 'Manage users' users section, and after trying to login with his details I get the following in log: Tue Jun 30 16:05:04 2015,666 [8555] INFO VT - PearDatabase ...
1
vote
1answer
39 views

Why does MySQLTuner only see 4Gb of RAM?

I ran MySQLTuner to verify the configuration of a MySQL database, and it reported this problem: [!!] Maximum possible memory usage: 40.9G (1022% of installed RAM) These figures come from computing ...
0
votes
1answer
29 views

What are the dangers of not gracefully shutting down mysql server

What are the dangers of not shutting down a windows MySql server gracefully (i.e. hitting the reset switch on the server as apposed to shutting the OS down) ?
0
votes
1answer
20 views

How to Upgrade Master Slave MySQL on AWS RDS?

I already have Master Slave configuration on AWS RDS. We want to upgrade 5.5 to 5.6.23. ..What should be correct sequence to Upgrade ? 1. Upgrade Master ( Using Modify Instance ) --> Upgrade Slave 2. ...
0
votes
1answer
17 views

Preserving create_time when loading a mysqldump file [duplicate]

I want to make a copy of a MySQL database but preserve the information_schema.create_time for each of the tables. I haven't been able to find an option to do that with mysqldump.
1
vote
2answers
38 views

Disable Primary Key on MyISAM Table

I wanted to speed up a large insert bulk by disabling keys. So I ran the following command on a MyISAM table: alter table my_table disable keys; When I execute show index from answer_2011, I see a ...
3
votes
2answers
153 views

INSERT data on MySQL to specific position based on its value (similar to ORDER BY)

I have a MySQL table with 3 columns for simplicity sake: Datename |Date |Name -------------+--------+----- 30/06/15test |30/06/15|test 30/06/15other|30/06/15|other Note: Column Datename is ...
0
votes
1answer
16 views

Old Data on SFTP [closed]

There are several old files on an sftp of mine that date back to two years ago. These files are ingested into a MySQL database. I am wondering what to do with the old raw files. The reason I am asking ...
-2
votes
1answer
28 views

How to become MySQL trainer? [closed]

I'm a certified MySQL developer and I have over a decade of SQL experience, most of it MySQL. What are the steps to take to became a MySQL trainer? Edited to add: Sample questions that made me ...