MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

-2
votes
0answers
16 views

Is there any future scope with DBA profile?

I have appointed as DBA. And I don't have any kind of experience. Right now I am fresher and I don't have any idea about How is DBA profile ? What should I do to become a good DBA ? Is there any ...
0
votes
1answer
19 views

Using GROUPing or ROLLUP rather than SUMing every column

I am currently looking for a way to achieve what this query is doing without using SUM for every column and, if possible, GROUPing or using ROLLUP or something similar. This query gives me a total ...
0
votes
0answers
16 views

which technology i shoul use 1. LinkedServer 2. SSIS?

Which technology should be use if i want to move my data from MSSQL server to MySQL server every time when data is entered to MSSQL row by row and getting feed back from MySQL server? Should it be ...
0
votes
0answers
17 views

Issues in enabling binary logging

I am using MySQL 5.5 RHEL 6 I have made these changes in my.cnf file. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent ...
0
votes
1answer
27 views

Find and Replace text in all table using mysql query

I have a database with name test having two tables sample1(name, quote) sample2(name, quote) I need a replace function or procedure that does the following Find columns with String data type ...
0
votes
2answers
15 views

Config file location in MySQL

I have MySQL 5.5 running in RHEL. I have checked for my.cnf file in my filesystem and its available in two destinations. One in the user's home directory and the other is in /data/etc_ORIG directory. ...
1
vote
1answer
16 views

A view to show worked time per task per user?

I have written this fiddle CREATE TABLE task (`taskid` int, `description` varchar(255), PRIMARY KEY (`taskid`)) ; INSERT INTO task (`taskid`, `description`) VALUES (1, 'Platform for ...
1
vote
0answers
13 views

Single Redshift table vs several mysql/ pgsql (on RDS) tables for small (200 tables * 20 columns * 1 million) monthly aggregation data

We're providing SaaS Data Analytics Dashboard for around 200 clients. We're using Amazon Redshift for storing data in in around 5 tables. We're getting around 30 million hits per day. Currently our ...
0
votes
0answers
8 views

Java error: The url cannot be null ( netbeans and wampserver) [migrated]

I'm creating a java application (stock management) with Netbeans and Wampserver, I create the stock_db_connection class and the Login class, and I want to test if it's work or not, when I click run ...
0
votes
2answers
25 views

Multiple types of parts with multiple types of information (unspecified amount) [duplicate]

I'm having trouble designing a database for a project I was working on recently. It's to do with a garage management system. So I've realised I need to store multiple types of parts (Tyres, engines, ...
0
votes
0answers
27 views

Correction of a complex query [on hold]

I don't know if this question is appropriate on this forum. I have a huge query : SELECT threshold.id, brand.id, COUNT(brand.id), threshold FROM current_stock, article, product, brand, delivery, ...
0
votes
1answer
26 views

Lock wait timeout exceeded; try restarting transaction in NDB

I encountered an error while using an opensource product with a mysql cluster. The error stacktrace is shown below. Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting ...
0
votes
1answer
25 views

Use of log_bin_trust_function_creators in MySQL

What is the use of log_bin_trust_function_creators? Also, Is the value of the parameter dynamic? Will it change if I restart my MySQL service?
0
votes
1answer
14 views

Replicate update statement as Insert in Mysql 5.6

I want to replicate all update statement from Master as a Insert at slave end. 1. Is it possible like in SQL Server ? 2 If so , how ? I want to do it because , if any record on master is ...
0
votes
0answers
24 views

Tuning MySQL with InnoDB engine for my application

I've read through a lot of answers, and I realize this is mostly application specific, so I wanted to give some background as to what I'm doing with the database and hopefully get some tips on tuning ...
0
votes
2answers
57 views

How to improve perfomance or Query Execution Time in MySQL?

This is my query: SELECT a.z_companyid_pk "z_companyid_pk" , a.company_name "Client" , a.display_name "Display_Name" , ...
0
votes
1answer
28 views

Mysql backup bug

I'm trying to run a SQL file created by mysqldump and suprisingly I get a SQL syntax error while running the backup file on the DB. How can it be possible considering that the file was created with ...
1
vote
0answers
14 views

Moved a MySQL Database to another server, but socket keeps pointing to localhost

I know I shouldn't bother with this, maybe I should disable the old mysql, but this is a Magento virtual appliance from Bitnami thats work as a whole (application and database on the same server). I ...
4
votes
1answer
37 views

Fast alternative for “NOT IN”

I have a table A that got a field called id that is the primary key of this table. I also have a table called B which also have a field called id as primary key. Now I want to get all rows from ...
1
vote
0answers
32 views

I need to find the “rank” in a sub-set of entries

I am currently working on some sort of a highscore list. But values displayed are individual for each user, ie. limited by constraints. One constraint that I am currently working on is "being part of ...
-1
votes
0answers
24 views

Can MySQL Enterprise Edition be used for free with no time restriction? [on hold]

My question is about product licensing by Oracle, specifically about MySQL Enterprise Edition licensing. I am not any DBA Master, I'm just a developer in search for answers from the real experts. ...
0
votes
2answers
29 views

Finding two users with same pair group

I have the following table which details actions of users and the action's parameters: action_id(auto-increment) | user_id | action_name | action_attr1 I want to find which users performed the same ...
1
vote
1answer
31 views

What is the correct implementation of handling concurrent SQL inserts while ensuring a non-primary key column (i.e. wid) unique and auto-incremental?

What is the correct implementation of handling concurrent SQL inserts while ensuring a non-primary key column (i.e. wid) unique and auto-incremental? Note: There was a design constraint that led this ...
1
vote
0answers
52 views

How to pass the value of PK to FK

Ok, so here it goes. I have a table called employee. then I have another table called languages. I need to copy the value of PK of employee table to foreign key in Languages table, rather than ...
-2
votes
0answers
23 views

MySQL Workbench cloud alternatives [on hold]

I have some analyst who runs some particular queries which are provided by me. Now when a new analyst joins our team I have to install MySQL Workbench on their laptop to set up the connection. I went ...
1
vote
1answer
34 views

Is it necessary to create foreign key in this query? [on hold]

I have the table called investors having as primary key the column id. I have the tables Users, Login_Logs and Accounts. All of these tables contains the foreign key investor_id. Between investor and ...
0
votes
0answers
25 views

optimizing a wild card search query in mysql

I want to have a search option in my game portal site. (right now i'm using google's in site search) I want a user to search to enter a search term and need my query to search the search term in the ...
1
vote
0answers
28 views

Master/Slave and Master/Master replication - MySQL

What is the difference between having a master-slave replication and having a master-master( where in the second master acting as hot-standby - active-passive) replication? Also, what are the issues ...
3
votes
1answer
33 views

MySQL query WHERE IN + ORDER BY, which EXPLAIN is better and how to avoid filesort?

This is my table definition, without any special index for now: CREATE TABLE `filter` ( `field_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `category_id` varchar(32) COLLATE ...
1
vote
1answer
21 views

Data and index file compatibility between patch/revision releases of MySQL

Let's say a server is on MySQL 5.6.1234 (yes I know that number's made up) and gets updated to 5.6.1235 (so an increment in revision / patch number). How safe would it be roll back MySQL to 5.6.1234 ...
0
votes
1answer
15 views

Is my import still committing?

I'm importing around 9 million rows into my MySQL DB using the following command: SET autocommit=0; SOURCE my_import.sql; COMMIT; The command line is no longer outputting lines of Query OK, X rows ...
0
votes
1answer
24 views

How to do an efficient case insensitive search

As an example, take a city table with 2 columns city_ref (bigint) city_name (varchar) with indexes on both. I want to do a case independent search by city_name. I know I can use like but ...
-1
votes
1answer
24 views

what is problem with time field in mysql during insert or update time? [on hold]

I have created a time field in MySQL. During INSERT or on UPDATE, if I don't select the time then the time field gets a default value of 12AM. However, I want to set this time field to NULL by ...
0
votes
0answers
21 views

Operation failed with exitcode 1 - while importing from a dump folder

I'm new to dbs and I'm trying to learn how a certain db works. They gave me a dump folder to play with it but, after setting up a connection (works), while trying to import, I get this annoying ...
0
votes
1answer
19 views

MySQL ERROR 2013 Lost connection

I am running a real old version of mysql(3.23.56). Everything is good, expect when I want to delete all entries of a table. I have checked query, like drop, select,update, their behaviours are ...
1
vote
0answers
22 views

Migrating tables from SQL Server to MySQL

I am using MySQL Migration Wizard to copy some tables from SQL server to MySQL local instance. When I define the source and target connection and test them I get a Connection Successful message and ...
0
votes
0answers
7 views

Would a nosql db handle sorting by latitude and longitude queries as well as a mysql db?

I have a table with a couple hundred advertisers including the latitude and longitude of the centroid of their zip code. I will also know the centroid of the zip code of website visitors. What I want ...
0
votes
1answer
28 views

Is it possible to convert mssql to mysql?

I've mssql.sql file I need to convert to mysql schema. Any ideas how? I'm on mac, I guess my choice is very limited. Tried workbench but it asks me for a live server connection to mssql which I don't ...
0
votes
0answers
7 views

MySQL Cluster and Async replication

My requirement is to have percona cluster for high availability and have the MySQL's classical aysnc replication for disaster recovery purpose. Is this is feasible? What are the possible issues that I ...
1
vote
1answer
26 views

Foreign key default value

I have a master table and another table with foreign key. I can easily add data to master table. But whenever I want to add data to the connected table, I get a message saying Foreign key doesn't have ...
1
vote
0answers
21 views

MySQL/Eloquent belongsToMany relation - two tables same pivot table allowed? [migrated]

Is it allowed to have two tables, each with a belongsToMany() relation to each other, using the same pivot table? Here is my User table: And here is my Org table: And here is the pivot table: ...
0
votes
0answers
25 views

Mysql permissions help [on hold]

I need a simple Sql statement that will grant all of the privileges and basicly, establishing a connection to any computer that tries to connect to my remote mysql server with the root account. For ...
0
votes
0answers
34 views

MariaDB error on alter table - table removed - constraint name is blocked

Today, we experienced a strange behavior in 5.5.41-MariaDB (InnoDB): An ALTER TABLE (add constraint) statement failed with error (mysql server has gone away after that). Then the database table ...
1
vote
2answers
20 views

Delete trigger mysql on another table

I am new on mysql and I am try to create a before delete trigger on mysql. I have a table call "persons" and I need delete a record on another table called "ldap_entries" the table "persons" have a ...
0
votes
1answer
64 views

how to minimize the data scanned on my database using index?

Is there anyone how to minimize the data scanned on my database?? please show me.. using index? query SELECT IF (e.channel LIKE 'IAX2%', e.calldate, IF(d.channel LIKE ...
1
vote
1answer
37 views

Sudden MySQL freeze, with spike in dirty pages, but without obvious write queries

I'm systematically (1/2 times per day) experiencing a freeze in the DB server. Suddenly, all the COMMITs get stuck in 'init' state; they pile up (up to 20/30), an almost no other queries are executed ...
1
vote
4answers
88 views

Mysql - Select next x records even if reaching rowset end

I have a table with an ID field, unique, autoincremental. I need to, given certain ID, retrieve next 3 records even when given ID is the last one. Table: ID 1 2 3 ...
0
votes
1answer
18 views

How to use explode mysql function in where condition with cakephp

I am using cakephp 2.6. I have payment_method fields in mysql table which store the values like 54,52,59,57 . Now my question is that how can i check if new posted payment method id is available in ...
0
votes
1answer
33 views

Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause

I have a MySQL database and users access it through an old legacy software (OLS) the company bought years ago. OLS connects to MySQL through MySQL ODBC driver. There is no way to change OLS in recent ...
1
vote
0answers
23 views

How to find where an unauthenticated user connects from

We are seeing some "unauthenticated users" when I run the command show full processlist in mysql (v5.6). | Id | User | Host | db | Command | Time ...