MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
100 views

Connection occasionally fails connecting to MySQL on Amazon RDS from PHP

We're moving MySQL databases from our own EC2 instance, to a multi-zone RDS instance. These are accessed from a load balanced lighttpd + PHP cluster. We've noticed that quite often, in the morning, ...
0
votes
0answers
121 views

slow query in amazon rds

I am having trouble I have an animal report which ran fine on my PC and on my EC2 instance with MySQL. I have just moved my Mysql in to Amazon RDS as we need to scale, and now this query is going ...
0
votes
0answers
46 views

I need a way to implement an incremental Backup/Recovery on mysql client

I need to be able to do a point-time recovery in mysql client from the mysql server. For example I need to Download only the information that have change since last backup. I can do that using log,but ...
0
votes
0answers
49 views

MySQL production vs. development

I have a production database server which I am using for a live web site. I want an exact copy of this database on a separate server, so I can develop against it. My development will involve ...
0
votes
0answers
26 views

Database cache problem

I have server based on Linux 64 Bit centos 6.5 and Mysql innoDB engine I created database for php script require database installation , after i successfully finished installation for first time i ...
0
votes
0answers
17 views

result time long

İ lose 3-4 minute when this query running in mysql.How to write I this query more optimal: select u.*, d.device_id, d.name from users u inner join pass_logs p inner join devices d ...
0
votes
0answers
87 views

How to move MySQL 5.6 data file on Windows 7

I don't get it. I am administrator on my machine, but I cannot move the data files. I get access denied errors when I attempt to. There was no my.ini in C:\Program Files\MySQL\MySQL Server 5.5, so I ...
0
votes
0answers
40 views

Can't run subqueries on my server (MySQL)

I have a weird problem, where I can run sub-queries just fine on my local machine, however they seem to be hanging forever when I attempt to run them on my server. Note that my server has plenty of ...
0
votes
0answers
63 views

MySQL migration to new hardware + upgrade + huge DB + windows

I am relatively new to DBA work and have a critical task in front of me, I really appreciate any detailed help you could offer. What I have a is a roughly 340 GB MySQL database on a Windows server. ...
0
votes
0answers
483 views

TokuDB fails to load in MariaDB, even when transparent hugepages are disabled

Earlier, I upgraded my website server to Ubuntu 14.04 LTS. I had a very nice setup with MariaDB and the TokuDB engine. However, the setup was kind of messed up when TokuDB refused to load properly, ...
0
votes
0answers
112 views

Error generating mysqldump with flush tables read lock option

I wrote a simple bash script that generates mysqldump while locking the tables. # Generate mysqldump that will be used on client side Q1="USE test;" Q2="FLUSH TABLES WITH READ LOCK;" Q3="SYSTEM ...
0
votes
0answers
41 views

MySql query keep running for a long time

Following query keep running for a long time and I'm using MySql 5.5.34 on XAMPP on Windows SELECT id_package, `pck`.`fk_sales_order`, `pck`.`fk_picklist`, count(pci.id_package_item) as items, ...
0
votes
0answers
20 views

How is the key length determine in an index?

Aside from explicitly setting the key length when creating an index, how does MySQL determine the appropriate key len shown when running "explain"? Thanks
0
votes
0answers
55 views

MySQL best practice DB recovery

I am trying to figure out what is the best practice is for Mysql recovery after a power failure. I need to find a way that if a server (which is running on a virtualbox VM) goes down when it goes ...
0
votes
0answers
258 views

Mysql Insert taking too long. Table need optimzation

I have around 60 tables and a video table with over 600,000 rows. with 4 Btree and 2 FULLText Indexes and have around 30 Columns. Server Specs are high, over 30G of Ram, Intel Xeon Processor. Mysql ...
0
votes
0answers
359 views

PHPMy Admin Exporting Importing with Foreign Key Constraints

I have a major issue here, How do I export a MySQL Database from PHPMyAdmin whilst retaining all the table relationships(foreign key constraints) - I have noticed performing a quick export does not ...
0
votes
0answers
657 views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
0
votes
0answers
19 views

No privileges on the admin

I am using MySQL on AWS, and I came to horrific realization that privileges were flushed shut N across the board today. I was able to view this from an other user has very few privileges, but one of ...
0
votes
0answers
39 views

Issues with Inserting due to FK constraints

I have two tables: Employee, and Department. They are setup like so, : CREATE TABLE IF NOT EXISTS `mydb`.`Department` ( `Dname` VARCHAR(25) NULL, `Dno` INT NULL, `Total_sal` INT NULL, ...
0
votes
0answers
159 views

Avoid transaction rollback when Deadlock is encountered (mysql)

I'm currently trying to handle concurrent inserts correctly using MySQL, I'm basically doing the following: CREATE TABLE foo (id INT NOT NULL PRIMARY KEY) ENGINE=INNODB; CREATE TABLE bar (id INT NOT ...
0
votes
0answers
100 views

MySQL CPU high usage

My MySQL service started to using a lot of CPU recently. Few second after restart it takes 100% CPU's. I tried already changing my.cnf file to optimize cache/buffers. I have no idea what causing that ...
0
votes
0answers
137 views

MySQL - How to grant read access to all tables, write access to a few, to one user for multiple databases?

Ubuntu Server 11.04 - a testing server with at least 10 copies of the production code. Each copy has its own database. And there are two sets of database prefixes in operation. There is an add-on ...
0
votes
0answers
194 views

Can't Add Databases through PHPMyAdmin

EDIT (should've mentioned this sooner): I'm using a Mac, running OS X 10.9.2 Being fairly new to PHPMyAdmin, I thought I was removing settings/privileges for one single user through PHPMyAdmin, but ...
0
votes
0answers
63 views

MySQL Query for combobox

I have two tables in my database.namely books and bookidofid. where bookidofid from books table is referenced to bookidofid from bookidofid table Table books ...
0
votes
0answers
132 views

How to use Select query just right after Insert on master in a query.?

I have a question on mysql replication. As usual, I deployed my db structure like the Update on master db, the select on slave. My questions. If I use SELECT query just right after INSERT in a query, ...
0
votes
0answers
30 views

Why does MySQL randomly display my databases?

Using InnoDb for the tables, Zend installation that comes with MySQL on Windows. Basically what happens is that at each system startup (not MySQL) I get a random snapshot of my databases at some ...
0
votes
0answers
88 views

Concatenate extrapolated data from two tables

I want to concatenate two tables that contain user data. The purpose is to display the duplicate user accounts based on email, IP address and connection logs. The two tables containing user data (I ...
0
votes
0answers
419 views

MySQL wont start after abnormal shutdown

I had an abnormal shutdown of the server, when I started it again I get this errors. If I remove ibdata1, ib_logfile0, ib_logfile1 its starts, but the databases aren't there...I can't restore a ...
0
votes
0answers
84 views

Auto Increment Column for Ordering

I have the following table and I just added the ord column because I need to ORDER BY ord all of my tasks selected for a user/group. I want them to always be returned in the order the user added the ...
0
votes
0answers
226 views

#2002 Cannot log in to the MySQL server / Connection for controluser as defined in your configuration failed

I use PHP/MySQL in Ubuntu 13. To reduce the size of ibdata1, i followed this post What is the best way to reduce the size of ibdata in mysql? and make necessary changes as told in the answer. I did ...
0
votes
0answers
62 views

Using triggers to sync databases

Is it more reliable to use triggers to sync 2 mysql database that has different structures than doing it on an application level? See related question at stackoverflow. How would you sync 2 mysql ...
0
votes
0answers
58 views

MySQL 5.5 InnoDB migration using stored procedure is very slow in Linux/Windows 2008 Server

I am Migrating MYSQL data from one server to another server using my stored procedure. The target server is Linux//Windows Server 2008. The migration speed is extremely poor. It takes about 5-6 ...
0
votes
0answers
101 views

started using cleardb and curious to see if way to verify that heroku connections are via ssl

I'm hooking up ClearDB's MySQL for Heroku and have set up SSL connections via provided certs / keys but am curious if there is any way to verify that the heroku-cleardb connection is running over ...
0
votes
0answers
42 views

Performance : MySQL replication or only one big server?

I'm searching about the best choice. We have to host a website with 10.000 - 20.000 visitors per day actually, growing. At the beginning, which would be the best : Having 2 MySQL servers (12 GB ...
0
votes
0answers
348 views

using Aria vs InnoDB vs MyISAM

I was wondering (if anyone knows) if Aria database is crash safe . I had some tables with MyISAM which were getting corrupted very often and switch them to InnoDB . However innodb is a bit slower and ...
0
votes
0answers
536 views

While Loops Don't Work in MySQL 5.6?

I'm trying to use a while loop in MySQL for the first time, and decided to create a simple example as a test: BEGIN SELECT 0 INTO @n; WHILE @n < 10 DO SELECT @n; SET @n := @n +1; ...
0
votes
0answers
27 views

mysql synchronisation

hello, i have 5 MySQL servers masters each one have mysql slave , and i have to synchronize data from those masters to one other mysql(central mysql who contain the common data : it can be ...
0
votes
0answers
37 views

mysql synchronization databases

hello, i have 5 MySQL servers masters each one have mysql slave , and i have to synchronize data from those masters to one other mysql(central mysql who contain the common data : it can be ...
0
votes
0answers
106 views

Can I set a lower_case_table_names value for a specific database?

I'm running a MySQL 5.5 on Linux (Debian 7) with several databases. I need to import a database originally maintained in Windows MySQL using sqldump. My issue is that this database is used by a ...
0
votes
0answers
52 views

Why does the delete/update block each other in this case?

The following drives me crazy. I have: session1>begin; session2>begin; session2>update dummy set salary=1000 where id=11; session1>delete from dummy where id=1; id is the PK ...
0
votes
0answers
111 views

Big Mysql table optimization

I have a table that I use to cache google translate API answers. Table structure is orig_string and group are indexes Now it has more that 1million rows with 35000 distinct values in group field. ...
0
votes
0answers
45 views

Is it possible to group by a fraction of the result set?

I have a database of products with prices. What I'd like to be able to do is figure out 5 different price ranges such that each range, when ordered by price, will have approximately the same number of ...
0
votes
0answers
55 views

MySQL - How to get multiple/batch averages from daily data

I'm really not sure how to tackle this so let me explain my goal... Lets say I have 30 people that enter a piece of information into a table and let's also say that 20 of these people do this between ...
0
votes
0answers
34 views

Optimizing MySQL query

I have a Sql query to optimize, its execution time is 8.5 Sec. I have made index on fields (timesheetdate,deleted) and able to reduce execution time to 8 Sec. A behavior I noticed that when I change ...
0
votes
0answers
669 views

Get categorie, subcategories and number of products assigned to each

I have a list of products, and a list of categories, and a join table. Products can be assigned to multiple categories. Categories can have one level of subcategories. The tables look something like ...
0
votes
0answers
69 views

Efficient way to fetch/update X records in a loop

What I need is a simple process that handles requests. I have setup a simple table as follows: CREATE TABLE Requests ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, request_param VARCHAR(250) ...
0
votes
0answers
95 views

MySQL import gets slower and slower until it virtually grinds to a halt, what can I do to maintain constant speeds?

I'm importing a large set of sql data into a MySQL (MariaDB 5.5) database, the files are from 200mb to 3g. I'm importing it one after the other, and it starts importing at speeds around 1MiB/s to ...
0
votes
0answers
67 views

How to update Status using IF Condition in Mysql trigger

I'm trying to write an update trigger that will Design_Update_Status to Customized when a date is entered in Custom_Design_Update_Date field and if nothing is entered that field it should update ...
0
votes
0answers
228 views

Converting UUID's from CHAR(32) to BIN(16)

I have a few questions relating to UUID's, but before I go on, let me explain our schema a bit, first, we're on MySQL 5.5 (Percona's version to be exact)... In each applicable table, we use a two ...
0
votes
0answers
54 views

MySQL/MariaDB CLI limits max password?

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...