MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
37 views

ClearDB Granting Created User Access

I added the ClearDB addon to Heroku, but upon using the created username to create a new database, the error appeared: Executing: CREATE SCHEMA `androidchatterdatabase` DEFAULT CHARACTER SET utf8 ; ...
0
votes
1answer
40 views

Can't see temp table from subquery

I have a query that selects data from tables and one temp table. This works fine, but there is a GROUP BY/ORDER BY combination that doesn't work well for me. Indeed, I need to order the results and ...
0
votes
0answers
15 views

Do we always need to create a new connection in order to make a select query in mysql?

Do we require to have a new connection before select always?
0
votes
0answers
28 views

How to group two query that have already been grouped

I am creating a chat system and i have two queries: The first query selects the Max(id) meaning the last message that has been received or sent by the member that is connected and that has not yet ...
0
votes
1answer
12 views

How to use mysqltuner from remote host

We do not have access to our servers with operating system console. Our production environment is Ubuntu 12. Is it possible to use mysqltuner from remote host? If yes, please provide guidelines. We ...
2
votes
1answer
40 views

Find string of decimal digits in Pi

I am trying to find the first occurrence of "12345" in the decimal expansion of $\pi$ by using MySQL. Possibly by using the Instr function? But I am stuck because it only displays the first 7 ...
0
votes
0answers
12 views

parent / child aggregate column

To start with, here is my fiddle. I have a parent / child relationship setup, I have them ordered by who they belong to, and I want to have a column called lastUpdated in which the parent has the ...
0
votes
1answer
47 views

Why does InnoDB allow a 772 byte unique constraint?

I've defined a unique constraint for two columns: A bigint and a VARCHAR(256) COLLATE utf8mb4_unicode_ci Then this error occured (which I'm already familiar with): Specified key was too long; max ...
0
votes
0answers
7 views

Should I use mysql transaction in SaaS application

Can any one elaborate whether we should use transaction for SaaS based application having simple modules like note taking and task for a team? Also if I make a Quickbook like SaaS app then do I have ...
0
votes
1answer
26 views

Pick up the name of the column by two diff column in single table

Thank you guys in advance! i am desperately need to display my data in this way, My database structure is, Column idcat, parent_id and child_id is sharing single column name, catname. I tried ...
0
votes
1answer
12 views

access denied when mysql to localhost using public ip

I would like to use the command below to connect to my Mac's local database (xx.xxx.xxx.xxx is the Mac's ip address) mysql -u cgao -h xx.xxx.xxx.xxx -p and I got the error message: ERROR 1045 ...
0
votes
1answer
24 views

Automatically purging binary logs

I'm currently trying to create an scheduled event on MySQL to purge binary logs every week. The create event statement is as follows: CREATE EVENT purgebinlogs ON SCHEDULE EVERY 1 WEEK STARTS ...
0
votes
1answer
13 views

I am trying to figure out how to get the proper results from a MySQL database [closed]

I am trying to figure out how to get the proper results from a MySQL database. Table Structure: items PN1 PN2 ------------ ------------ 702866-001 702866-001 738975-001 ...
1
vote
1answer
24 views

“Unknown table engine 'innodb'” error after changing my.cnf

I am getting "Unknown table engine 'innodb'" for some query after changing my my.cnf. I have reverted the old my.cnf and restarted mysql and now I can see innodb. Could you please help me figure out ...
0
votes
0answers
28 views

Multiple values as single array in Query

Query: SELECT a.*, b.a_val as definition_value, c.a_id as definition_name FROM products a INNER JOIN attr_vals b ON a.sku = b.sku INNER JOIN attr_defs c ON b.a_id = c.a_id ...
1
vote
1answer
62 views

Select with limit, get total count, optimize query [closed]

The site mimics the "likes" tooltip from Facebook, the only difference is that you can like or dislike the content. The tooltip shows the first 12 users that rated the content and displays the number ...
0
votes
1answer
12 views

Get list of excluded databases from command line by asking user

Based on this I'm working on this bash script for export all databases from MySQL but exlude some ones and also system ones. This is how it looks like: read -e -p "Enter MySQL root user: " -i "root" ...
0
votes
0answers
19 views

Big cpu caused by mysql

I have big cpu caused by mysql, 3 vcores, centos 6 64bits http://s3.postimg.org/z8l73e98z/mysql.png [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql symbolic-links=0 ...
0
votes
2answers
34 views

Heavy load causing MySQL Slave threads to remain “locked” or “Sending data” indefinitely

We have been rapidly adding MySQL servers as slaves to our master database server to help alleviate a massive increase in search (read-only) traffic to our web service. This past week, I was tasked ...
0
votes
1answer
56 views

How to speed up mysql query against a 204 million record table

For some reason my server has been finicky lately and for the life of me I can't figure out why. I monitor the memory usage by running shell# watch -n 5 free -m without running any activities ...
1
vote
2answers
30 views

MySQL 5.6 Slave Stops Processing Binlog on Master Restart

I have a pair of Debian 7 servers with MySQL 5.6.23. The slave server is a clone of the master (but the uuid has been regenerated on the slave). For some reason, whenever MySQL is restarted on the ...
0
votes
1answer
43 views

Can't Delete Orphaned MySQL Temp Table

One of my servers had a hick-up yesterday and decided to leave temporary table while (while running alter table add indexes). ls -l sql -rw-rw---- 1 mysql mysql 8570 Mar 13 12:05 #sql-ib32694.frm ...
0
votes
1answer
22 views

Padding MySQL queries

I'm trying to retrieve logs of our plant where a certain event has occurred. At the moment, I can query the actual event by using an alarm_code field. However, I'd also like to include about an ...
0
votes
3answers
25 views

What is the best way to have full text search where data in database is frequently updated

I am working on an application where database is continuously and periodically gets updated , the frequency of updating of data is daily, weekly, monthly, and yearly based on their type. I want to ...
9
votes
3answers
686 views

Is a 5+ column primary key bad for large (100 million+) table?

I was reading about some real life DB issues, and one project had a 100 million row plus table that had 5 columns as its primary. I'm thinking this is bad, but can anyone tell me exactly why? EDIT: ...
0
votes
0answers
13 views

Unable to Login MySQL server

I am trying to connect to MySQL through Command Prompt .But I always get "access is denied for 'admin'@'localhost' user . " (Error 1045). This MySQL is running on Windows 2012 R2 server. There ...
0
votes
1answer
24 views

How to turn Event Scheduler On permenantly in mysql

How do i turn on the event scheduler in mysql permanently. I'm using phpmyadmin and i have scheduled an event to copy records from one table to another everyday at a specific time, but the records are ...
0
votes
1answer
19 views

Moving two databases from MySQL 5.1 [Prod] to MySQL 5.6 [Stage], not working [Windows]

I'm in the process of upgrading our production MySQL from 5.1 to 5.6, on a Windows Server 2008 R2 server. What I'm trying to achieve is to move 2 databases [say abc and xyz] from Prod server to a ...
0
votes
0answers
21 views

is it bad practice to do a loop to see if a url parameter is set?

I'm working on a way to include views on my site - if any is requested. Whenever the user access a page, that is valid, I also scan another table to see if there is any available views, and at the ...
0
votes
2answers
28 views

mysql does not start: error 13 on bin file (permissions are set correctly)

I just renamed the hostname and rebooted the server and now mysql 5.6 wont start. (debian 7 + dotdeb) 150312 20:40:15 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql.mnt ...
0
votes
1answer
22 views

MySQL: What exact commands does each privilege level allow?

I am configuring some new logins for users who have already been using the relevant MySQL servers under other logins. I would like to limit their privileges to the minimum each user needs, based on ...
0
votes
1answer
12 views

What if we skip the slave by counter 1 when it failed at event 1 of a transaction which has events 2 and 3

We have a master-slave replication which has all Innodb data. I ran 3 update statements under one transaction on master. ============= start transaction update T1 update T2 update T3 end ...
0
votes
1answer
25 views

Filling a column with incremental numbers

I got an SQL query like this: SELECT o.option_id,v.value,o.sort_order FROM eav_attribute_option o INNER JOIN eav_attribute_option_value v ON o.option_id=v.option_id WHERE v.store_id=1 AND ...
0
votes
1answer
23 views

Can we disable binary logging for one specific session or user in AWS RDS

Currently we have a situation to disable binary logging for one set of queries on AWS RDS. We thought to set log-bin=0 for that specific session. As per Amazon, this is not possible. Is there any work ...
0
votes
0answers
11 views

Will breaking down a bulky insert reduce the number of IOPS on MySQL?

Our RDS instance is setup to handle 1000 Provisioned IOPS. This number is fine for most of the time. But at some point we need to run several insert operations (each inserting 2K records), our IOPS ...
0
votes
0answers
10 views

Database Design for Resume and Sections

I am trying to figure out if I am on the right track here. resumes id user_id resume_sections id name desc Sections are those that we normally find in resumes, experience, skills, education and ...
0
votes
1answer
30 views

Grant All privileges on all databases to a Mysql user

I try to give a user all the privileges on all the databases : mysql> GRANT ALL ON "." TO 'AppBD'@'192.168.1.5' IDENTIFIED BY 'admin'; ERROR 1064 (42000): You have an error in your SQL syntax; ...
-2
votes
1answer
36 views

Mysql 5.0 certification Certs [closed]

I have just got the MySQL 5.) certification guide .I am a programmer analyst using Cobol Cics Adabas natural and wish to know what test is required to take after I complete studying the book .. I ...
0
votes
2answers
26 views

Limit columns to certain width in `mysql` command

The mysql command gives nice tabular outputs that take into consideration half and full width spacing. For example: > select 'The quick brown fox jumps over the' text union select '01234567890'; ...
0
votes
0answers
27 views

MySQL - Group By - How does it determine which row to return from joined table

I am getting desired, but inexplicable behavior on a particular query, and wanted to get more information before pushing up. I have 3 tables: foo bar bar_image And paring back all distractors, ...
0
votes
0answers
23 views

HDD being used 100% even when data files are not on that disk

I am facing very high disk IO. Ihave 2 HDD - 1 is a SATA disk and the other is a SSD. The sata disk is showing 100% disk utilization. My.cnf is as follows [mysqld] datadir = /mnt/disk1/mysql ...
0
votes
0answers
15 views

MySQL Data User Ownership

Which OS User will own MySQL Datafiles? For example: If i run the next command: create database test; It creates a folder on the datadir. Is there a variable that controls the ownership and ...
0
votes
0answers
7 views

Amazon Web Services EC2 instance running MindTerm java app. Question

If I'm running an Amazon Web Service (AWS) EC2 instance, using the MindTerm java-app... what do I type into the console to retrieve mySQL Hostname, Username, Password, and Database Name information? ...
0
votes
2answers
30 views

troubleshoot high value for mysql innodb pages written per second

Our database is writting about 600 pages a second to its innodb buffer pools. Usually this value is about 10 pages/sec, so the server is experiencing a very high IO utilization, around 50%. Is there ...
0
votes
2answers
38 views

How can user determine which hash their password uses?

Is there a query that a MySQL user that does not have admin rights can run to determine if they are using the old (pre-4.1) hash or the new (4.1-and-later) hash? This user was explicitly granted ...
0
votes
0answers
31 views

mysqlfailover utility (as a HA tool)

I am currently working on setting up a Master-Slave replication and would like to use the "mysqlfailover" tool. However, when I have been trying to use it, it gives me an unreliable result. Often when ...
0
votes
1answer
30 views

Group by without temporary table and filesort

My aim is to make the following query faster. SELECT SQL_NO_CACHE Links.id,Links.link,sum(ID_Links_Words.count) AS wordCount FROM Links LEFT JOIN ID_Links_Words ON Links.id = ID_Links_Words.link ...
0
votes
0answers
16 views

MySQL Replication 2003 error connecting (servers behind monowalls)

I'm trying to get MySQL replication, Master-Slave, configuration working. On my slave when I do a SHOW SLAVE STATUS\G; I get a 2003 error: Last_IO_Errno: 2003 Last_IO_Error: error connecting to ...
0
votes
0answers
14 views

mysql collation-server not respected

I've configured my server (5.5.41) with: character-set-server = utf8 collation-server = ...
1
vote
0answers
14 views

Poor performance filtering mysql spatial join

First of all, sorry for the crossposting. I ask this question in stackoverflow and they sent me here I have a mysql table with spatial references (GEOGRAPHIC_FILTER), like cities, countries, natural ...