Tagged Questions

MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
1answer
18 views

How to combine duplicate parent rows in a relational MySQL table

I have my DB structured like this with people.person_id as the foreign key for each row in people_meta. people table ╔═════╦════════╦═══════╗ ║ id ║ fname ║ lname ║ ╠═════╬════════╬═══════╣ ║ ...
0
votes
1answer
29 views

how to give GLOBAL PRIVILEGES in MySQL?

I need limited Global permission like Select Execute and grant privileges to one user. how can i give, can any one help me.
0
votes
0answers
24 views

SQLDependency equivalent for MySQL [migrated]

I want to implement a real time update on my ASP.net project, so i tried to implement the long poling mechanism and Comet. var isPolling = 0; function longPolling() { isPolling++; $.ajax({ ...
0
votes
2answers
22 views

Should I delete the mysql database user id created for my site by the developer? [closed]

I am a newbie when it comes to anything related to databases. I cut ties with my developer who had set up my site and was hosting it too about six months ago. I moved my site to a new host thinking ...
0
votes
0answers
19 views

MySQL Fabric Error- No module named mysql.fabric.services

I have installed MySQL fabric, but I am getting this error $mysqlfabric Traceback (most recent call last): File "/usr/bin/mysqlfabric", line 27, in <module> from mysql.fabric.services ...
1
vote
0answers
53 views

MySQL keeps inserting new rows automatically [closed]

I have no clue of what is going on. My script goes this way: $i = 0; $c = $somecount; while($i < $c){ $en = comment_version($comments, $i, 'en'); $ru = comment_version($comments, $i, 'ru'); ...
0
votes
1answer
33 views

MySql MBRCONTAINS not accurate

I have a table that has 3 column. city_id, city_name and city_geo. city_geo type is geometry. and i have a another table that has a vehiclelog. I want to query if the latitude and longitude from ...
0
votes
1answer
33 views

Query output conditional upon values in dataset

If the number column contains values 5 AND 6, AND the value X exists in the chr column, I would like to exclude rows with 10 in the test column. But, if the number column contains values 4 AND 5, AND ...
1
vote
0answers
20 views

Skipping stopwords (and indexing small words) for one fulltext index only, in MySQL

I have a rather odd situation where it might be preferable to not use stopwords and to have a value of ft_min_word_len equal to 1. The index in question would be dealing with only a few words per row ...
0
votes
0answers
13 views

Computer crash causes MySQL to leaves behind an .err file that stops mysql from booting on reboot

When my mac crashes it leaves behind an error file that I have to manually delete or MySQL won't start again. (fx1)kit:fx1 kitsunde$ ls -l /usr/local/mysql/data/kit.err -rw-rw---- 1 _mysql wheel ...
2
votes
2answers
84 views

What's the difference between MySQL Fabric and MySQL Cluster

I'm new to the MySQL world and was confused by the two. Don't they both provide high availability and sharding? Also, how does WebScaleSQL compare?
2
votes
2answers
48 views

Best practice design when expecting large data in a table

I have come across a way that kind of works for me, and was just wondering if it would have any side effects, or, if I'm just thinking about this the wrong way. I first had this idea when I was ...
-1
votes
0answers
21 views

MySQL 5.1 on Windows server - Increasing value in open_files_limit does not apply

I have increased the value of open_files_limit from 2048 to 4096 in my.ini file. But, this change has not been reflected. Below is my dedicated DB server configuration: OS: Windos 2008 R2 standard - ...
1
vote
1answer
26 views

Saas MySQL Multiple Databases or One Database [closed]

I am using MYSQL so Database is the Schema, sorry if not using right terminology. I currently have a Saas product which has multiple databases one for each client with a main databases which we ...
0
votes
3answers
144 views

How could I connect to MySQL database running on WAMP server from other computers in same LAN?

I'm new in web development. I'm requesting help from all of you. My problem is: I installed WAMP server in my desktop computer. My desktop computer has a static LAN IP (192.168.0.101). I'm able to ...
0
votes
2answers
39 views

How to create identity field in MySQL without using auto_increment column?

I am trying to create a dynamic system when a user can create different objects and relate them to another objects. I need is to be able to generate an identity column similar to auto_increment but ...
0
votes
0answers
14 views

Can't execute a MySQL stored procedure from Java [duplicate]

I am using MySQL. I gave below permission to Java to execute stored procedures: CREATE USER rateervice@'%' IDENTIFIED BY 'rate$123'; GRANT EXECUTE ON Ratetest.* TO 'rateervice'@'%'; But here Java ...
0
votes
1answer
34 views

Complex query on big table

I have a big user table (3M), of structure: age (int) country (FK) city (text) gender (text) active (bool) My objective is to run a search finding 15 users of given age area, gender, city and ...
0
votes
2answers
28 views

How to remove multiple records from one table based on the non-existence of a record in another table?

I have two tables, 'Products' and 'Details'. -------------------------- Products [ID, Name] -------------------------- 1, Link's Simple Syrup 2, Team Shirt 3, Animal DVD ...
0
votes
1answer
46 views

pt-table-checksum - Verify MySQL replication integrity

export/import: $ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql Enter password: $ echo $? 0 $ mysql clee2 < 6dhdbm01-clee2.users.sql $ echo $? 0 $ pt-table-checksum: $ ...
1
vote
1answer
41 views

MySQL service stops after trying to grant privileges to a user

I am using MySQL 5.6, I was trying to create a super user for specific database but I got ERROR 1396 (HY000): Operation CREATE USER failed for 'superuser'@'%' Then I thought maybe there is already ...
0
votes
1answer
29 views

Upgrading from MySQL 5.1.37 to MySQL 5.1.73

We have a fairly advanced website that runs on a cloud system. We have one master DB server and 2 Slave DBs that read from the Master. We're currently using 5.1.37 (I know...its old and from 2009), ...
0
votes
2answers
18 views

Trigger not working after upgrade to 5.6

I've upgraded to 5.6 and my triggers are no longer working. I loaded a working trigger example from SE to test them, and they do work which means that there is something wrong with my code. When I ...
0
votes
2answers
34 views

Sync 8 tables of differents databases on same server

I will use eight wordpress websites and i need to sync ther wp-user tables so each single user can connect through all websites. All of these will be on the same server, using the same MySQL user, but ...
0
votes
1answer
24 views

Join Operation using index defined?

I need to optimize some queries with several joins. I plan to create some indexes for these queries. I am currently using MariaDB with TokuDB storage engine. Should I expect the indexes for the join ...
0
votes
1answer
43 views

Calculating difference between consecutive timestamps. Error when i reach the hour mark

I am using MySQL I have a table that contains among other things an id a time in the format date:time (YYYYhhmmss) and a readingvalue. The difference between each reading value is 300 seconds but ...
0
votes
0answers
30 views

MYSQL : Copying to TMP table nightmare

I'm having a (AFAIK) random issue. My server is MySQL and I have a query that is sometimes 10000 times slower as you can see on this screensot : http://snag.gy/vJJ39.jpg The long time occurs during 2 ...
0
votes
0answers
36 views

MySQL Binlog Dump process stops after net_write_timeout

We have 2 MySQL 5.6.19-1 servers with master-master replication that were working fine (DB01 and DB02). One of them was rebooted unexpectedly (DB01) and seemed to be working fine, but we saw that the ...
0
votes
1answer
34 views

MySQL 5.6 replication causes 'waiting for table lock'

All of the sudden queries on slave server stopped with status "Waiting for table level lock" I restart mysql service and stop replications and locking does not show up anymore. Once I turn ...
1
vote
0answers
40 views

Summing a column based on uniqueness of another column without using temporary table

I have a table like this: CREATE TABLE `files` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `hash` char(40) DEFAULT NULL, `size` bigint(20) unsigned DEFAULT '0', ...
1
vote
4answers
26 views

How to alter/migrate the schema of a table with tons of records

I have a table which has about 1 million records, and recently i'm going to ship a new feature which requires 2 new fields. But I found it takes about minutes to get it finish, and during the ...
0
votes
1answer
30 views

How to configure my.cnf in 5.6.17?

On production server(linux machine mysql 5.6.17), I tried to find my.cnf to change the system variables, but my.cnf was not in /etc/my.cnf location. It was in usr/ directory. Also that file contains ...
0
votes
0answers
19 views

Table user, role, and function MYSQL database design

Hi im a new in designing database. At first I have made a relationship of tables users, roles, and functions these was my database design: NOTE: the users that im pointing out is the adminUsers. ...
0
votes
0answers
14 views

mysql replication error 1236 need to restart replication process

I'm using mysql replication and the slave/master crashed in the process and then I got: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in ...
0
votes
0answers
15 views

How to Merge 2 or more row in one query [duplicate]

I have table like this RID | Data 111 | banana 111 | mango 112 | cabbage 112 | carrot 113 | etc I want to select by RID Group like this RID | Data 111 | banana mango 112 ...
0
votes
0answers
16 views

Best Query/Method to Import A Database Via Workbench and Push Edits Back Out to Prod

I have a local instance of Workbench. It connects to a local dev database, and also a remote prod database via SSH. I want to be able to work on my dev database and push the changes out to the prod ...
0
votes
0answers
11 views

Conditionally updating the columns PHP/MySQL [migrated]

I have embedded the MySQL statements in PHP code. Following is my code: $sql1="UPDATE labdata1 SET Date='$d1' WHERE SL=1"; I want to set the column "Date" to null after 48 hours. What I tried is ...
0
votes
2answers
71 views

Very high load avg for MySQL database [closed]

I have a backend server which response to my clients app, it has more than 20k~25k hit per second and this make my server load average very high, I believe that my MySQL config is not appropriate. In ...
1
vote
0answers
32 views

ORA-00937 when calculating a sub-value in an aggregate select statement

The problem described below applies to Oracle 11g databases. I also tested the statements on MySQL and PostgreSQL with no problems of the kind mentioned in this question. I want to use an ...
1
vote
1answer
22 views

SQL : get rows from two tables relatively

I've two tables named categories and products. Simple structure is given below. categories cat_id cat_name 1 c1 2 c2 3 c3 products prod_id ...
0
votes
1answer
32 views

Amazon RDS freezes on mysqldump

My questions is quite similar to Mysqldump from the Amazon RDS. I have the same behavior. Everytime when I do a backup using mysqldump my entire RDS freezes and hence my application is not responding. ...
1
vote
2answers
19 views

Suggestion for Tooth Chart Data Structure

Hello I'm not sure if this is an OK question here but here goes, I'm quite confused on how am I going to make the data structure of my tooth chart database. I had first this thought of making a data ...
1
vote
1answer
52 views

First date in a week, not exceed from the month, start from specific day

I want to get first date of week from date, but not exceed from first date of month. This is the query i've tried : SET @date:='2014-10-03'; SELECT IF(DATE_ADD(@date, INTERVAL(1-DAYOFWEEK(@date)) ...
0
votes
1answer
24 views

How to use mysql live update on a mysql table between localhost and remote server?

I have mysql table created/modifying in localhost, and I need to update those in my remote database. I have gone through lot of post regarding this scenario and I found out that I need to use mysql ...
0
votes
1answer
31 views

Select Information from All Tables [closed]

EER Diagram Question List the customer number, customer name (first and last), order number, order date, employee number, employee name (first and last), product number, product name, and order ...
0
votes
2answers
44 views

Determine last time a mysql table was accessed (i.e. SELECT'ed)

In my mysql DB schema there are old tables that are no longer used. I want to come up with a systematic way to show my developer a list of tables and last time they were read (SELECT'ed, not ...
1
vote
1answer
45 views

How can I determine the average number of transactions per second in MySQL?

I'd like to see how many transactions per second an instance of MySQL server is processing, on average (per hour and per day). Is there some query to determine this? I've looked through ...
0
votes
0answers
56 views

Connection to Amazon RDS MySQL instance fails with `init_connect command failed`

I'm attempting to open a connection from my Amazon RDS instance to my local dev machine. I added my IP to the security policy in Amazon's panel (read: whitelisted myself in the firewall) and added my ...
0
votes
1answer
26 views

What is the meaning of “available RAM” for calculating MySQL max_connections

The question was asked previously, "how do I calculate MySQL max_connections" and this was the answer: max_connections = (Available RAM - Global Buffers) / Thread Buffers Since I don't have ...
0
votes
0answers
18 views

is there any limit of MySQL status variable value?

As we know MySQL status variable is a counter variable since the service start. MySQL service in my DB server restart every week (on sunday). Below is my observation since last few week: Suddenly ...