MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
12 views

Recreate partition in mysql

I have a table having datetime column partitioned by RANGE (DAYOFYEAR(datetime_col)) By this I want to drop oldest of 4th week partition data and recreate immediately for next year similar week ...
0
votes
1answer
29 views

Dealing with Mysql Replication and Functions

In MySQL replication Master-Slave, is there anyway to deal with the functions: LOAD_FILE() UUID(), UUID_SHORT() USER() FOUND_ROWS() SYSDATE() GET_LOCK() IS_FREE_LOCK() IS_USED_LOCK() ...
0
votes
1answer
13 views

mysql “can't create test file” error on Centos

When starting mysql on Centos servers with a custom data directory you might get an error similar to the following: 2014-10-15 10:23:56 17081 [Warning] Can't create test file ...
0
votes
0answers
16 views

Data usage increase although remove data in table MySQL Cluster

I try to test my MySQL cluster system. I add data to a table and use command ndb_mgm all report memoryusage. The data usage in data node increases. When I remove all data in the table and use command ...
0
votes
0answers
10 views

Is online schema change possible with MySQL Cluster?

I believe that this is the first question on this community. I'm surveying MySQL Cluster for next project in my workplace. I read a lot official/unofficial pages on the web. But I'm not a native ...
0
votes
0answers
23 views

Mysql sum of column group by question

I have the results of a select that I am joining on that I need to get a slightly complex sum of a column from. I need the sum of result grouped on id PLUS the sum of result of any row where ...
0
votes
1answer
34 views

to pivot or not to pivot - schema design question [closed]

I am implementing something similar to this schema http://www.databaseanswers.org/data_models/event_reservations/index.htm It occurs to me that the pivot table for Customer_Bookings would just keep ...
1
vote
1answer
30 views

Help on MySQL joins

I'm building a system to monitor currency prices. Part of my database structure looks like this: My system is trying to pull the api ticker for each exchange with this query: SELECT distinct ...
1
vote
1answer
22 views

Is there any drawback of MIXED replication mode?

So, recent mysql server allows three types of replication mode: STATEMENT, ROW, MIXED. They all have pros/cons, and I pick the mode according to site characteristics. When I get a replication error I ...
0
votes
2answers
39 views

Merging tables, but ignoring duplicate columns

I have two tables I want to merge: city1(id, city, state, zip, lat, lon, county) city2(id, city, state) The tables contain overlapping city and state, but not primary keys. I can't figure out how ...
0
votes
1answer
23 views

combine results from two columns without union

I have a table with two columns : select his_name , her_name, other_name from foo I want to combine the result set into on row. I can do it with union select her_name as name from foo union all ...
1
vote
2answers
40 views

Using if statement outside of a stored procedure or function

I want to call a query to update a mysql table but my query contains an if statement set @id = 0; set @the_number = 0; set @the_message = 0; set @selected_message = 0; SELECT id, dest_msisdn, ...
-4
votes
1answer
42 views

How to design type table with indefinite multiple items?

I want to design an invoice system. In invoice table there should be an invoice_type, which comes from a table called invoice_type_table. I am confused with the structure of this invoice_type_table. ...
1
vote
1answer
51 views

Normalized Database Diagram

So I am working on my DB design skills, and have tried to create a normalized MySQL database. Here is the diagram: The reason I added the Address table is to break the address fields into separate ...
1
vote
0answers
35 views

triggers vs views [closed]

I have a mysql database with the following tables Penalties Scores player_instance When penalties is updated/deleted then it will update scores (via a trigger). Also when a player-instance row is ...
0
votes
1answer
31 views

Best datatype to store betting odds? [closed]

I have a lot of soccer betting odds (hundreds per match and thousands of matches), for example: <_10Bet_Home_Home>8.00</_10Bet_Home_Home> ...
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
18 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
51 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
31 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
37 views

How to implement Master Slave Replication using mysql [closed]

Before moving on with question i would like to first tell you about my web project deployment architecture. Basically this website show details and values of various device connected on remote pcs. ...
0
votes
0answers
27 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
17 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
79 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
46 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
24 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
114 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
35 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
45 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
40 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
26 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
17 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
33 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
23 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
42 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
33 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
31 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
37 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
25 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
27 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
17 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. ...