MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
405 views

Is it possible to optimize a range query so an explain statement would state “using index” instead of “using index condition”?

I have a very large table where specific queries made by my application are timing out. The table looks something like this: LargeTable ------------ Id [BIGINT(20)] UtcTimestamp [BIGINT(20)] Pivot ...
0
votes
0answers
261 views

Can't stop MySQL server on Raspberry pi

I can't stop mysql server on raspberry pi. If I use mysql workbench I have been able to start and stop the server perfectly fine for months. However it now refuses to stop! How do I force it to stop? ...
0
votes
0answers
188 views

MySQL stops responding (at almost regular intervals)

Using mysqld (latest xampp version). My.ini port= 3306 socket = "D:/xampp/mysql/mysql.sock" basedir = "D:/xampp/mysql" tmpdir = "D:/xampp/tmp" datadir = "D:/xampp/mysql/data" pid_file = "mysql.pid" ...
0
votes
0answers
25 views

What can cause database slowness for finite time frames other than more requests or heavier requests

I'm trying to understand possible reasons for high variance in time spent in MySQL Database in my web application. There are hours in which everything is smooth, and hours that are much slower. For ...
0
votes
0answers
73 views

Lock timeouts on a table with two keys, where only one connection writes for a given value of the first key at a time

I have a table user_rollup_message_list that is keyed by (user_id, message_reference). It is a write-heavy table, and gets enough writes that I get many lock timeouts, with a timeout of 50 seconds, ...
0
votes
0answers
73 views

unexpected null returned from calculated columns

I'm working on a program that will calculate journey times based on bluetooth MAC addresses and i'm trying to nail down the mySQL commands I need before I get cracking on the software part of it. i ...
0
votes
0answers
19 views

How can i used mysql enterprise backup in window?

I am using MySQL server 5.1, how can i used MySQL enterprise Backup, and how can i get MySQL Enterprise Backup setup, for MySQL server 5.1? Can you Please, provide a link of MySQL Enterprise Backup, ...
0
votes
0answers
221 views

Mysql high delay in critical peak | Professional Help request

I have a Centos 6.4 under 2.6.32-358.18.1.el6.x86_64, running Asterisk 11& A2billing in real-time switching with Mysql 5.5.33. My Server it's a Dell R420 having dual Intel(R) Xeon(R) CPU E5-2470 ...
0
votes
0answers
125 views

my mysql stop running and restart after minutes. why?

I have a problem with my mysql. My site was down for a few minutes with this error: Unable to connect mysql ... And I saw this log in \var\log\mysqld.log : 131005 12:23:38 mysqld_safe Number of ...
0
votes
0answers
211 views

MYSQL LOAD DATA INFILE taking a long time

I have a MYSQL DB running on a raspberry pi. Now under normal circumstances MYSQL actually runs slightly quicker than it did on my much more powerful desktop. However I am trying to insert 60 million ...
0
votes
0answers
64 views

How many days old log is stored in .mysql_history

I would like to know how many days old log is stored in .mysql_history in mysql server and also i want to know is it possible to find the date or time when the particular command or query is executed ...
0
votes
0answers
59 views

Performance setting for MyISAM tables - my.cnf file

I have a 4-core MySQL server with 4 GB of RAM, holding 19 MyISAM tables (total: ~164GB of data) and 32 innodb tables ( 5mb ) . QUESTIONS Since the databases size is smaller than the available ...
0
votes
0answers
37 views

MySQL create all rows for (over) normalized schema at start or as data is available

I am developing an app, and using MySQL and the db schema is provided. To me the db looks (over)normalized. Data for a single user will be spread over dozen tables, and around 150 rows in total. Some ...
0
votes
0answers
116 views

mysql regex pattern

iam using "lib_mysqludf_preg" & need to excute some query to achieve this goal: my coulmn contains "some html tags , some txt & some imgs tags" i need to delete all full img tags in this ...
0
votes
0answers
79 views

Need advice on this EER Diagram

This db will work with a CakePhp app and need advice about design. Is it good idea to put orders on center or should I put clients on center? Clients has orders and an order record can only have one ...
0
votes
0answers
351 views

Optimizing join between big tables

I have a server on my pc and I need information across several large tables (~ 20MM each). I installed WAMP on my windows 7 and use mysql for this. No idea how I can optimize the configuration of ...
0
votes
0answers
129 views

column alias not displayed as column name when export the result of mysql query to excel

I am trying to get the total number of tables present in each database and export it to excel sheet. so i had tried this mysql -h192.168.0.xxx -P -uxxxx -pxxxx information_schema -e " select ...
0
votes
0answers
66 views

Percona cluster performance issue

We have 3 servers running in a percona mysql cluster. Two of the servers in the cluster are running on older hardware specs. The third is a real monster with a lot of RAM and SSD hard drives and so ...
0
votes
0answers
228 views

How to increase MySQL performance with joins

I have a MySQL database with InnoDB engine. Particularly one of my queries became very slow. The query is shown below: SELECT t1.`ARTREF1` FROM `lijnen` AS t3 INNER JOIN (`kortingen` AS t2, ...
0
votes
0answers
40 views

How to optimize this query more?

First at all I am nood into SQL thing, Now I am working on a class project where I have some tables like Table user user_id | username | name 1 | nihan | Nihan Dip 2 | dip ...
0
votes
0answers
90 views

Query Execution Plan for MySQL

In Microsoft SQL Server you can see Execution Plans for queries to see how a query is executed, what joins take the most time and see any missing indexs now i want to do the same for MySQL scripts ...
0
votes
0answers
61 views

designing mysql for large tables

Currently I've been assigned the task to research ways to speed up an existing project. It's going to be rebuild so we can start from scratch, the current implementation has been build by another ...
0
votes
0answers
66 views

MySQL randomly refuses to use index

Mysql randomly refuses to use indexes for even simple queries. 1 example from slow-query log: # Time: 130904 12:19:59 # User@Host: cron[cron] @ [10.71.41.38] # Query_time: 58.488760 ...
0
votes
0answers
177 views

Drupal database doesn't work after MySQL restart

I've installed Drupal 7x on my local XAMPP 1.8.3 Server. Everything went fine but after adding some modules, changing the drupal theme and restarting the MySQL Server, the MySQL Server is dropping ...
0
votes
0answers
611 views

How to configure MySQL master & slave to backup master to slave?

I have a complete backup of one database from master to slave. Now I want to back up two databases from master to slave. But use the same ways it doesn't work. What should I do? Master's conf ...
0
votes
0answers
29 views

Reliability of blobs in MySQL

I'm in the process of migrating an application working with Oracle to MySQL. That application stores data in the form of blobs, which can be pretty big. The Oracle production database is 60 Gb large ...
0
votes
0answers
168 views

Error restoring a MySQL dump file

I have an error when I try to restore a dumped file from the same server and version of MySQL. I used this to produce the dump: exec('mysqldump --user=... --password=.. --host=localhost data_base ...
0
votes
0answers
116 views

mysql.sock missing

I started my MYSQL database this morning but failed. And I tried all means I can think of: chown -R mysql.mysql /var/lib/mysql chmod g+w /var/run/mysqld chgrp mysql /var/run/mysqld chmod -R 755 ...
0
votes
0answers
107 views

Is STRICT_TRANS_TABLES required for replication?

Is STRICT_TRANS_TABLES required for replication? Particularly, I need to know about it for Percona Cluster.
0
votes
0answers
643 views

MYSQL 5.6.12 Lock wait timeout exceeded, yet no transactions\locks currently taking place?

On a development database with no other users other than myself, I'm getting the following error #1205 - Lock wait timeout exceeded; try restarting transaction when trying to run a simple alter ...
0
votes
0answers
72 views

MySQL Access Denied, tried a few things, pulling hair

I'm trying to get to know Django (my first attempts at a framework, or any backend work for that matter), and I'm seriously stumped by MySQL, and SQL in general. I'm trying to create a new database ...
0
votes
0answers
439 views

Cannot start MySQL cluster with single node

For some testing I have installed MySQL Cluster. I can get it to work with configuration suggested in Lunix guick start guide. My configuration: [ndb_mgmd] hostname=localhost ...
0
votes
0answers
47 views

Creating a dedicated HD parition at beginning of disk for data files, benefits and draw backs?

I am thinking of creating a dedicated partition on the harddisk for the mysql database data files in /var/lib/mysql , while considering those 2 points: a dedicated partition will avoid any file ...
0
votes
0answers
100 views

MYSQL replication not working with connector but works VIA phpmyadmin

I have setup a MYSQL replication, and have tested the replication by using phpmyadmin. On all occasions when using phpmyadmin, the data was being replicated successfully. But when records are ...
0
votes
0answers
144 views

Percona XtraDB Cluster With Async slaves

I have set up a 3 node percona cluster in amazon ec2. As our client required, i also had to set up an asynchronous slaves in another datacenter as well. Each async slave pointed to single percona ...
0
votes
0answers
84 views

Any drawback to lots of creating and renaming tables at InnoDB?

I'm trying to optimize an important cronjob for my program, and what it basically does is generate a long list of user ids with their score points. I have a table called user_ranks and it will bulk ...
0
votes
0answers
228 views

MySQL slave doesn't reconnect to master after master is rebooted

I've got a new MySQL replication setup with one master and one slave. In all of the following scenarios, the slave automatically reconnects to the master and resumes replication where it left off: ...
0
votes
0answers
168 views

MySQL SSL encryption

Does setting MASTER_SSL to 1 in change master ensure encryption without specifying options MASTER_SSL_CA, MASTER_SSL_CAPATH, MASTER_SSL_CERT, MASTER_SSL_KEY ? After setting MASTER_SSL to 1, show ...
0
votes
0answers
535 views

How to speed up a mysql restore from large dump file

I have a 350MB msyql dump file that takes over 3 minutes to load. I'd like to speed it up. I've tried using --opt with mysqldump (shaved off 30 seconds). The best I can achieve is 42 seconds faster. ...
0
votes
0answers
53 views

How to secure SQL database?

I made a little application with a MySQL database. I want to secure my database.I think user name and password is not enough to protect it. Because anyone can access the database by copying database ...
0
votes
0answers
155 views

mysql died with stack trace

My mysql server died while running select queries. Status of every table is good. When I went to the error log I found this: Thread pointer: 0x2ab63e0f49e0 Attempting backtrace. You can use the ...
0
votes
0answers
590 views

Push Data from MySQL to SQL Server

I am not sure if my title is correct, but I will try my best to explain the current problem. Current Scenario: I have a php web application with MySQL database (let's call it DB1) which is stored ...
0
votes
0answers
304 views

Trouble converting MySql Database to SQL Server

I have an mysql database that contains 38 tables. I used "SQL Server Migration Assistant for Mysql" tool to convert this database to SQL server Database. I successfully converted 37 tables. Only one ...
0
votes
0answers
141 views

Efficient, up-to-date way to import an Oracle database into MySql

Here's the situation: I need to automatically merge data from an Oracle and a MySql server into a single, new MySql server. The merging will happen daily, and the resulting server will be hosted on a ...
0
votes
0answers
44 views

Problem merging two tables and store the result into another table in MySql Database

I have two tables store_timing and business_news. Both the tables are having more than 12,00,000 records. Now I want to merge all the data from these two tables WHERE store_timing.zipcode = ...
0
votes
0answers
204 views

setup mysql row-based-replication without downtime?

Is it possible to use setup rbr on a mysql server (current version happens to be 5.5.31) to a slave without incurring downtime? (and if "yes", how?) My thought is first to configure the master and ...
0
votes
0answers
543 views

MySQL always crash on start, ibdata1 bigger than 4GB

I'm having a problem with MySQL when testing my production data. Whenever I started MySQL (mysqld), it always crash. My suspect is on my InnoDB data file (ibdata1) since the size is already bigger ...
0
votes
0answers
179 views

“Mysql2::Error: Table doesn't exist” after power outtage

The power went out while my site was running and now when trying to access my site running locally on my mac I'm getting this error: ActiveRecord::StatementInvalid: Mysql2::Error: Table ...
0
votes
0answers
126 views

How to enable SSL in MySQL on Windows?

I'm a student doing a project which uses JDBC and MySQL (on Windows). I have an application with connects to a MySQL server on a remote host. To have a secure connection, I found this : ...
0
votes
0answers
75 views

Query take a long time! Is that server issue?

When Query runs on Server (shared-server) it takes (2.5332 sec) But when I run the same Query on another Server (dedicated-server), it takes only (0.0205 sec). I don't know where is the issue! Is ...