All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.

learn more… | top users | synonyms

1
vote
1answer
32 views

Justified multi-value field in MySQL?

I have a table of data that contains 10 point values based on a score for an event (0 - 9 points). If a time is within the range, the point is awarded. There are 20 possible events. Is this a valid ...
-1
votes
0answers
21 views

Inner Join two select statements

I try to apply inner join on two select statments. 1st Select fetches 8K records 2nd Select fetches 8.2k records When apply inner join it fetches 300K something records. I don't know whats wrong ...
1
vote
1answer
117 views

pt-query-digest results are empty

I have a slow log generated by MySQL 5.1.71-log, that I've copied onto another machine. It appears I'm not getting any results from pt-query-digest. $> pt-query-digest slow.log # 2.1s user time, ...
2
votes
1answer
110 views

optimize mysql with mysqltuner Recommendations

Every day at 18:00 mysqlserver became very slow How do I apply the suggestions by mysqltuner for optimize mysqlserver CentOS release 6.6 (Final) MySQL version 5.6.28 64-bit architecture 32GB RAM ...
0
votes
1answer
9 views

Specify what columns to display in a SHOW COLUMNS statement

Does mysql offer any possibility to specify what columns to display in a SHOW COLUMNS FROM my_table statement ? from this : Field Type Null Key Default Extra ...
0
votes
1answer
172 views

MySQL Local Variable Scope and Triggers

I have a couple triggers that automatically update invoice data and set some statuses in the database. However, it appears that if 2 Triggers have variables that are named the same, they get ...
0
votes
1answer
1k views

Why does max_connections in my.ini not match concurrent connections in Mysql instance config wizard?

MySQL 5.1.x | Windows Server 2003 Can someone please clarify why max_connections in my.ini is much larger than the manual value I specify in the Concurrent Connections Dialogue? For example, if I ...
0
votes
1answer
992 views

How to export an Access database and import to MySQL?

I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has ...
0
votes
2answers
28 views

Formatting out a column value - mm:ss.hh

I have a time in seconds and I want to convert it to the following formats possibilities: 121.17 -> 2:01.17 | 34.28 -> 34.28 | 133.56 -> 2:13.56 I am using the following: IF(Time > 60, ...
0
votes
2answers
306 views

Dealing with data stored as arrays in a MySQL DB

So I know storing arrays in a DB field is wrong and would never do it myself, however a 3rd party plugin my company is using stores data in an array and I was wondering if you could help me try to ...
1
vote
1answer
28 views

import TSV file into MySQL table with SET datatype column

Is it possible to use LOAD DATA INFILE to load data into a MySQL/MariaDB table, where one column uses the SET datatype? My columns are separated by tab, my set members by comma. If so, how do I ...
0
votes
0answers
9 views

hosting mysql server on the cloud or local network pc

I have a question on whether to host a mysql server on the cloud or a local network pc. In the current work environment all users log on to the cloud and work from the cloud. All the work ...
1
vote
0answers
8 views

MariaDB strange user privileges issue

Server version: 5.5.47-MariaDB-log MariaDB Server / CentOS Linux 7 x86_64 I have two users: user@% and user@localhost with the same password but apparently different privileges (some privileges the ...
0
votes
1answer
22 views

database design help with multiple table relationships

Been scratching my head on how to set this up and looking for your help. Trying to create an API and not 100% how my tables should relate to one another. So lets say I have users, food, and food ...
1
vote
1answer
305 views

Maxscale read write split and route filter

I have trouble to forward all SELECT requests to the slave in a MySQL master-slave architecture. I'm using maxscale's read-write router, which does its job except for all statements using ...
0
votes
0answers
15 views

Is Mongodb a smart decision for a social network? [on hold]

So this question is more than a bit broad , I would appreciate input from those with experience working on social networking. I have been questioned many times why I have chosen MongoDB for a social ...
1
vote
1answer
146 views

MySql Innodb corruption recovery

I have a MySql database, just containing Innodb tables, that seems to have corrupted itself. It replicates to another server and it has corrupted that one too! The symptom is that I can restart the ...
0
votes
1answer
130 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
0answers
11 views

MySQL server refuses remote connection when under high load

When my MySQL server is under high load from the local machine it doesn't accept any remote connections. When load is normal it connects without any issues, but under high load neither a MySQL nor ...
0
votes
1answer
17 views

Why does phpMyAdmin execute all queries with an apostrophe?

For example, if I use the GUI to perform an INSERT, the console will log the following execution: Why does each item have apostrophes (aside from NULL)? I know that I can do a literal INSERT via ...
1
vote
1answer
42 views

How can I better model the relationships in this project?

I'm developing an internal tool (as an intern). We deal with a lot of hardware, which is all custom and managers have a hard time knowing who is developing on what machine. The three main things to ...
-2
votes
0answers
19 views

Setting up a MySQL DB: Local or on hosted server? [on hold]

I'm not new to PHP but I have never used my own computer to set up a web-programming environment. I'm having especially trouble understanding setting up MySQL locally vs on a hosted server. My ...
0
votes
1answer
17 views

How to set mysqldump using /*!40101 SET character_set_client = utf8mf4 */;?

When I use mysqldump to export mysql database, it always produce a dump.sql containing ...some other things... /*!40101 SET character_set_client = utf8*/; ...some other things... This is the ...
-2
votes
2answers
24 views

pick data from multiple tables

I am new to MySQL. My question is how to make a filter like amazon product. I made a matrimony site with filter. I wrote a query to access data from multiple tables. I give foreign key to another ...
0
votes
1answer
10 views

Could not connect to the specific instance. MySQL error number 1045. Access denied for user 'root'@'my public ip' (using password:YES)

I was using MySQL query Browser in my system and type the IP address of the remote Server and log in. I tried to create a store procedure and scheduled an event to call the procedure every two ...
3
votes
2answers
263 views

How to optimize indexes on MySQL query with various sorts

I have an INNODB table levels: +--------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | ...
0
votes
0answers
15 views

how to fixed this mysql 5.5 crash?

[root@DB-Server-master bin]# mysqld_safe --user=mysql 160429 12:10:55 mysqld_safe Logging to '/data/mysql/data/log/mysql-error.log'. 160429 12:10:55 mysqld_safe Starting mysqld daemon with databases ...
0
votes
1answer
15 views

Cant initialize MySQL. “mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended”

I am doing a fresh install of MySQL on Fedora 22. After I run mysql_install_db I try to start the daemon using mysqld_safe but it does not work. The system says: mysqld_safe Logging to ...
1
vote
5answers
315 views

Replication in same server within different databases. Mysql 5.6

What I have : a windows machine with one instance of MySQL 5.6 Server. two database named test and test2. Test database has a table called activity with columns id and class What I need : ...
1
vote
1answer
811 views

Sync MySQL with SQL Server 2008

My current project requires a form on my website to populate a table in a MySQL database with data a user submits via the form. This will work great but my complete goal involves getting that data ...
0
votes
0answers
17 views

MySql Error : Database page corruption on disk

Recently Ive setup a xampp in my store location. on Windows 7 32 bit, 2GB RAM - Pentium PC. (XAMPP) xampp-win32-5.5.19-0-VC11 PHP application is Point of Sale. With latest mysql server and PHP 5.5. ...
0
votes
1answer
129 views

mysqlslow - excluding queries from mysqldump

I would like to ignore the queries in my mysql-slow log that originate from mysqldump using SQL_NO_CACHE as the trigger word. My experiences using regex are limited at best and I'm unable to find any ...
3
votes
1answer
165 views

drop table from outside?

A poorly designed script ran on my MySQL 5.6 instance for 24 hours before I stopped it by killing the MySQL command line client and rebooting the machine while the script was still running. The ...
1
vote
1answer
22 views

MySQL datetime to just date

Currently I have a table containing a column of type datetime. I have no need for the use of the HH:MM:SS that trail the variables stored in this column. I just need the YYYY-MM-DD. Is there any way ...
2
votes
3answers
94 views

Poor performance of JOIN, WHERE, ORDER BY combination (MySQL)

Goal: select 10 most recent rows from posts which are related to a specific user. There are two tables: posts (~5,000,000 rows) and relations (~8,000 rows). posts columns: ...
-4
votes
0answers
31 views

Query for columns

I need help writing a query. I have a table named "schedule", with columns "start time" and "end time", both with the time data type. Student have today discipline "Networks" from 11:00 (in start ...
0
votes
2answers
156 views

Large query with subquery runs indefinitely after mysql update

We recently did a big server update, in the process migrating from mysql-5.0 to 5.5.40 Several of the queries, which had been running well on the old server, now grind everything to a screeching halt. ...
1
vote
1answer
170 views

Please suggest my.cnf configuration based upon mysqltuner findings

I have been facing a lot of slow browsing on my site nerdeky.com. My server administrator suggested me to use mysqltuner.pl to find and tune my databases. Can anyone select me what should be the good ...
0
votes
0answers
15 views

MySQL 5.6 performance_schema not showing queries from application

I'm seeing a strange problem with perfromance_schema... it seems queries are not getting logged as I expect them to be. For example, this is what I get: mysql> SELECT `SCHEMA_NAME`, `DIGEST_TEXT`, ...
0
votes
1answer
25 views

MariaDB - cannot set max_connections and wait_timeout through my.cnf

I am struggling to set max_connections and wait_timeout parameters in /etc/my.cnf but MariaDB does not seem to read the parameters from the file (it reads some of the others, I haven't checked all). ...
0
votes
3answers
9k views

Why decrease the wait_timeout configuration parameter in MySQL?

Question I'm working on an application that uses a connection pool in Apache Tomcat to communicate with MySQL. I was wondering why would you want to use a smaller wait_timeout than the default of ...
-4
votes
0answers
31 views

Mysql 5.5 improvements for MyISAM? [on hold]

What new improvements MySQL 5.5 announce for MyISAM as compare to MySQL 5.1. or is there any change in 5.5 for MyISAM
-1
votes
2answers
19 views

MySql: Migration from 5.1 to 5.5 [on hold]

What are pros and cons of migration from mysql 5.1 to 5.5 (MyISAM)? I am working with 500 million records, It can be very costly if it slows down. Are there any recommend settings?
-3
votes
0answers
62 views

MySQL database repair - innodb tables [on hold]

I'm using navicat premium and the UI is reporting that the database is corrupt and asking to be repaired. I have some innodb and some MyISAM tables. I did repair but issue not resolved Is there any ...
0
votes
1answer
147 views

How to get mysql automatically running when I start tomcat apache on Windows?

When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
0
votes
1answer
21 views

error 1146 when importing mysql DB

I'm trying tu dump and re-import a database, I'm using the following bash script to export (I have reasons to export each table separately) for x in `mysql --skip-column-names -h [host] -u [user] ...
0
votes
0answers
47 views
+100

MySQL replication/cluster of multiple databases

I looking for a suitable MySQL replication technology. I'll try to explain our use case first. We have several applications: - 1 public web application - multiple customized enterprise web ...
0
votes
0answers
21 views

What can cause the the table cache in MySQL to consume much memory?

I have a server with a table_open_cache of ~2000, and a query cache of ~128M. We have ~350 InnoDB (no MyISAM) tables; innodb_file_per_table is disabled; there is no partitioning; MySQL is 5.6. After ...
0
votes
1answer
103 views

Mysql 1 way replication master lost data replication still has

Had a master mysql on (windows) improper shutdown. Many records could not be recovered and investigation found slave had records master did not have. Did not restore over master - left as was. As if ...
1
vote
1answer
559 views

Setting MySQLDump to keep running in the background after session times out

I'm tryng to set up a new Slave DB by copying another Slave DB. Normally I would simply use MySQLDump to dump the Slave and create a .sql file, then import that into the new database. However, as our ...