MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
240 views

Using a `mysql_query` to insert category values

Ok I'm importing direct from a csv to MySQL, using a mysql_query to insert values. How do you insert category terms into the Wordpress database structure assigning them to a post. Below are two import ...
0
votes
0answers
209 views

MySQL my.cnf File Optimization help

I need help for Optimizing my MySQL Server for my Dedicated server with configuration of Intel Core 2 Duo CPU E7500 @ 2.93GHz 4GB of RAM installed. OS installed is CentOS 6.5. Mostly on my Dedicated ...
0
votes
0answers
54 views

mysql logs same query multiple times or is it application problem?

I have temporarily switched on logging on the server. The site is used in the US and local time there was 4 in the morning so not many people are using it at that time. What I did was delete any logs ...
0
votes
0answers
13 views

Users_With_Messages Table normal form

I have the following tables in my database: Above these tables (not pictured) is a Users table where the SendingUserId and ReceivingUserId are keyed onto (they are foreign keys). Are these tables ...
0
votes
0answers
17 views

High bandwidth on virtual IP

Description of the environment : An apache server (Drupal) connected to mysql server using a virtual IP. The problem : The (outgoing) bandwidth on VIP has exploded (after a new site version ...
0
votes
0answers
54 views

Percona slower than vanilla Mysql 5.6

A lot of folks had suggested to use Percona as more robust and enhanced version of Vanilla Mysql. I just setup Percona 5.6 today on our server to see how it holds up against our traffic. I noticed ...
0
votes
0answers
97 views

Log-slave-updates in multi master replication using Tungsten replicator

I m setting up a system as follows with 2 masters and 2 slaves. M1 <----> M2 (Tungsten Replication) M1 ----> S1 (MySQL Replication) M1 ----> S2 (MySQL Replication) I have enabled the ...
0
votes
0answers
17 views

Securing database from intruder DUMP

What would be the best way to secure a MYSQL database that contains customer information from being dumped by say a injected SQL or Remote file inclusion? Can the DUMP function be turned off globally ...
0
votes
0answers
36 views

Normalization of irregular relations?

I have two tables in MySQL: The orders table CREATE TABLE `orders` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `transaction_id` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `task_id` ...
0
votes
0answers
70 views

CREATE VIEW joining two tables, only displaying rows from the first table with the most recent date in the second table

I have multiple tables. My main table has a composite key consisting of a phone number and an order number. I want to create a VIEW where only the subscriptions with the most recent order date are ...
0
votes
0answers
160 views

Upgrading MySql 5.1 to MySql 5.5

I followed a tutorial to update My MySql 5.1 to 5.5 (actually i wanted to upgrade to 5.6, but the tutorial mentioned that i should upgrade to 5.5 first and then to 5.6). However, after removing ...
0
votes
0answers
42 views

Upgrading MySql 5.1 to MySql 5.5

I followed a tutorial to update My MySql 5.1 to 5.5 (actually i wanted to upgrade to 5.6, but the tutorial mentioned that i should upgrade to 5.5 first and then to 5.6). However, after removing ...
0
votes
0answers
21 views

MySql cannot get started after increasing buffer_pool_size and log_file_size in my.ini

I try to change buffer_pool_size to 256 MB and log_file_size to 64 MB in my configuration file. After the changes made, I was unable to start MySQL service. System RAM size is (1.99 GB usable)4 GB. ...
0
votes
0answers
64 views

MySQL — COMMIT in 'stage/sql/init' state

MySQL 5.6 instance hosts a single database (for the TeamCity CI app). The app is quite write-heavy (about 2/3 of total database activity) and often seen waiting for database to complete a commit, ...
0
votes
0answers
101 views

Mysql DB recovery

Mistakenly I have deleted "ibdata1" file in mysql server. Now my database is not working. All the tables are corrupted. But still I have "ib_logfile0" and "ib_logfile1" files.Also I have a recent ...
0
votes
0answers
669 views

mysql takes too long on “checking permissions”

We have about 20 databases with about 8000 tables each. Modifying the software is not an option (it is bought), and it seems most of the cpu is consumed by "checking permissions". While the s/w ...
0
votes
0answers
152 views

MySQL: after query optimization the CPU is still over 100%

my first time here! First of all I want to say that I'm not a DBA and I have a very little experience with MySQL but I like to study and understand what I'm doing. I have a virtual machine (2gb RAM, ...
0
votes
0answers
59 views

Mysql database recovery in linux

Is there anyway to get back database if I deleted database. Is mysql creates temp file which contain temporary data from database and whether I can recover from that Edited: cp my.cnf my.cnf41 mv ...
0
votes
0answers
32 views

Organizing trending posts

I have a page where a user can see the most trending posts under a hashtag name (e.g. #soccer). My question is, how should I be organizing the most trending posts? Should I create a cron job that ...
0
votes
0answers
108 views

Match unique id's on import- csv to sql

I have a csv file that I would like to import into a phpMyAdmin database (Wordpress). The CSV file is formatted as shown below: list-id | post_title | slider | ...
0
votes
0answers
97 views

Upgrade from mysql 4.1 to mysql 5.5

I was going through upgrade process of mysql server. It is mentioned that to upgrade from 4.1 to 5.5 we need to upgrade step by step like first to 5.0,5.1 ...5.4 and then 5.5. I have some questions : ...
0
votes
0answers
3k views

getting SQL Error (1452): Cannot add or update a child row: a foreign key constraint fails (Unknown error code)

I am getting error with MySQL NDB Cluster 7.3.5 as described below: I have two tables: -User Profiles -User Services User services is a child table which contains foreign key constraint ...
0
votes
0answers
86 views

MYSQL backup options using mysqldump and mysqlbackup

I'm currently using mysqldump to backup mysql database. I heard that mysqlbackup offers a much much better performance. Unfortunately it requires MySQL enterprise version which is pricy. A few ...
0
votes
0answers
19 views

MySQL - Shift procedure execution context

I don't really if I've worded this question correctly so bare with me. I'm running a very simple proc in MySQL, something very similar to this: insert into link_table ( primary_key_1, primary_key_2 ) ...
0
votes
0answers
155 views

How to set up MySQL 5.6 Master- Slave Replication step by step

I am new to Mysql replication. I want to have 2 MySQL servers, a Master and a Slave, running on two Ubuntu 14.04 Computers. Their IP addresses will be 10.0.0.1 (Master) and 1.0.0.02 (Slave). I need to ...
0
votes
0answers
45 views

How to restore my old MySQL data folder

I have an old MySQL data folder from an earlier instance of MySQL. How can I restore my old databases into my new instance? Is there a way to merge the old data folder with the new one? The version of ...
0
votes
0answers
53 views

MySql Query for fetching first record of every hour in Table

meant to say that, every hour may have 20 record .in that i want to fetch only one record or every first record in a hour from 10000 records.In the sense in a day 24 records. see the image and see ...
0
votes
0answers
68 views

mysqldbcompare without the the SUPER privilege

I want to use mysqldbcompare with minimal permissions from my management server. A dedicated has been created with select permissions to all tables / databases. But a got such error on each table : ...
0
votes
0answers
206 views

MySQL Cluster management node does not start (node has different checksum)

Please help me to start data management node. I have installed cluster with autoinstaller and it was working. Now i'm trying to change config (i want to change amount of DataMemory) and run cluster. I ...
0
votes
0answers
62 views

Mysql, performance problems with big database

I am running on Windows 7 64 bit with 4 GB RAM (used for Drupal based website). I have database dump of about 1.5 GB. After re-installing my XAMPP server, my MySQL server began working too slow. I ...
0
votes
0answers
120 views

Cluster with shared storage

I actually use MariaDB Galera Cluster with 3 master nods. Workload is about 70% read, 30% write and it's very important to have consistent data with every select - this is why I choose Galera ...
0
votes
0answers
765 views

Why is InnoDB waiting for table metadata lock in simple INSERT/DELETE + SELECT?

I've started using a new MySQL server and moved an InnoDB table there. I'm seeing a weird behavior that when I have a long running INSERT / DELETE, any SELECT from the same table is locked which is ...
0
votes
0answers
26 views

Analize Query in MySQL Server 5.1

I try use MySQL Workbench 6 to analyze the cost, but they don't show the cost of query. How i get this costs?
0
votes
0answers
42 views

MySQL on OS X Mavericks / mysqltuner.pl issues

I've installed the MySQL .dmg for my Mac. When running mysqltuner.pl its giving me errors that it can't find mysql and mysqladmin. I added the path to --mysqladmin /usr/local/mysql/bin/mysqladmin but ...
0
votes
0answers
54 views

stress testing mysql - maximizing qps for a single user

I am running a stress test and I am trying to churn out as much qps as I can for a single user. I know this is a loaded question so I will try to be more specific. Trying to target 30,000 qps with a ...
0
votes
0answers
26 views

MySQL distributed database with mysql access to each node

I have task to implement particular database structure: Multiple mysql servers with data using the same schema. Each server can see and edit only his particular part of data. And One master server ...
0
votes
0answers
33 views

Optimise complex query

The previous developer has left an utter query inside our Joomla to search for companies or whatever that has somewhere the keyword. Here is the query SELECT DISTINCT con.id, con.title FROM ...
0
votes
0answers
95 views

Load XML is not working in mysql version 5.5

I have a requirement where i need to load xml file into a mysql table using trigger. I have written the following trigger to achieve this. CREATE TRIGGER asdb.payment_test AFTER INSERT ON asdb.abc1 ...
0
votes
0answers
63 views

Sync MySQL database and Quickbooks Database

I use Quickbooks as an accounting software. I also have a MySQL database where I record data on orders, customers, inventory, employees and etc. Is there a way for me to sync the two databases? For ...
0
votes
0answers
64 views

Very slow inner join

newby on mysql so help needed I created a my sql query, on their own they run fast but when I enter the inner join it runs forever. i did index theres id tables but no result in speed. here is my ...
0
votes
0answers
26 views

How can I determine the performance (rows/second) for a certain query on one of my tables?

I want to find the performance (rows/second) for an UPDATE query on one of my tables so I can adjust my WHERE clause to select an appropriate number of records. The table has around 10 million rows. ...
0
votes
0answers
24 views

How to ensure accents are view as different characters when adding to unique indexes?

What can I do to ensure MySQL views the following as two different values? Bee Bée When I try to create a unique index, it fails because they're the same value. I looked at the following thread, ...
0
votes
0answers
22 views

loading k:v pairs from DB into JS Object

I'm creating a single player web RPG. I'm debating the following method of storing/retrieving quest items per player id: In userstats table, have a quest_items column of type mediumtext, where I ...
0
votes
0answers
324 views

group by and order by making query very slow in mysql?

Query works fast: select SQL_NO_CACHE users.id, users.name from useres left join user_statistics on users.id = user_statistics.user_id where users.is_deleted = 0 group by users.id ...
0
votes
0answers
253 views

MySQL Replication thread hangs on flush tables with read lock

I have a MySQL master/slave set up with row-based replication. At times of higher load we've been seeing replication halt and all slave thread activity commands just hang. STOP SLAVE, SHOW SLAVE ...
0
votes
0answers
71 views

What dialect is recommended for MySQL when using TPC-DS query generator?

I am trying to do a benchmark using TPC-DS and I was wondering what value should be used in the parameter "Dialect" for the dsqgen when the tests are going to be performed in MySQL. Also, I was ...
0
votes
0answers
107 views

How I can optimise my MySQL installation?

(Debian 7 32-bits KVM with 512mb RAM - SSD storage - 1 cpu) The server is not mysql dedicated. It runs a small forum on it. (Mysql -> read-mostly) Does anyone have any advice as to how I can ...
0
votes
0answers
47 views

MySQL Create Table Statements not being replicated

I have a one master 5 slave MySQL replication setup. When I create a table on my master, it gets replicated on 3 of the 5 slaves. The other slaves however do not replicate the "CREATE TABLE" ...
0
votes
0answers
254 views

How to improve performance of large table in AWS MySQL RDS instance?

I am unfortunate enough to have a somewhat large, unoptimized table: +-------+--------+-------+------------+---------+ | rows | data | idx | total_size | idxfrac | ...
0
votes
0answers
51 views

Why do non-integer joins in MYSQL take so long?

It seems that every time I try to run a query using a non-integer join in MYSQL, it destroys the speed of my queries. Is there a better way to join on text fields (especially ones that could be cast ...