MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
1answer
42 views

Backup live MySQL database

I have a single MySQL database Server version: 5.5.35-cll MySQL Community Server (GPL) ENGINE is MyISAM I use 'mysqldump' to backup and restore the database. Size of the dumpfile is 3GB+ Once a ...
0
votes
1answer
25 views

Implementing older version of mySQL on RH9

I'm building a virtual machine running Red Hat Linux 9 (Shrike) and MySQL. This is to virtualize a current production system that needs new hardware. Questions: Can I copy the existing mysql ...
0
votes
1answer
49 views

Huge load on CPU because of mysql process

I am getting a huge load on my linux servers because of this query. CPU is on 500% load & this query is causing load. /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql ...
0
votes
1answer
34 views

mysql view with user variables

I have a query that calculate distance from point a to point b using gps coordinates, and would like to make it view. Is it posible to pass variables that will replace xxx and yyy in my query with ...
0
votes
1answer
573 views

MySQL: split value in column to get multiple rows

I have some data in a table like so: product_id categories 10 9,12 11 8 12 11,18,5 I want a select statement that would produce this output: product_id ...
0
votes
1answer
62 views

MySQL Replication Master push to Slave

I have two servers that need to be synced. One is online and has a public IP address. The other is internal and has no public IP address - nor is there a way to get it a public IP so that's off the ...
0
votes
1answer
34 views

MySQL: Algebra in Union operation

I have below query: select entity_id from table1 exc UNION select entity_id from tabl2 inc On execution, I got 24419 rows. When I execute select entity_id from table1 exc I got 16235 rows and on ...
0
votes
1answer
38 views

How to get the last inserted id using scope identity without using a stored procedure in Mysql?

My project contains 2 tables one is profile_table and another is address_table Profile_ table contains: +------+---------+----------+ | sid | sname | saddress | +------+---------+----------+ | ...
0
votes
1answer
36 views

Column to Row and Vice Versa

I need to create a new table by combining the contents of two different tables. Is there any way to transform columns into rows and rows into columns in MySQL? I tried using JOIN but I can't seem to ...
0
votes
1answer
54 views

Automobile database logic

I am building a web based quoting system for a local automobile dealership. I think I have figured out the logic for the databases but I want to get a second opinion before I start just to make sure ...
0
votes
1answer
329 views

MySQL count multiple columns and sum the total occurrence

I have the following table, say, MyDRAW ... DRAWNO PRIZENO FIRSTD SECONDD THIRDD FOURTHD M123/14 8458 8 4 5 8 M123/14 7214 7 2 1 4 M123/14 1640 1 6 4 0 ...
0
votes
1answer
77 views

The total number of locks exceeds the lock table size, even after increasing buffer pool size

I am trying to partition a table with 200 million records in it. This table already exists: CREATE TABLE linkmap_ntoken ( target_nToken varchar(200) NOT NULL, ntoken_hashcode int(15) NOT NULL, ...
0
votes
1answer
67 views

mysql cluster table full error

I installed a new mysql cluster on windows (for evaluation). I created a table using command below. After I insert just over 1 million records into the table it gives me the "table datadump is full" ...
0
votes
1answer
57 views

MySQL connection timeout error retrieving big results

All of the sudden our MySQL 5.6 server (on Windows server) started to give us this error: "Lost connection to server during query". We never had this problem before and we haven't touch MySQL config ...
0
votes
1answer
190 views

My.cnf with 64GB RAM

May the following my.cnf file be fine for a dedicated server with 64GB of RAM (on Debian)? I'm running just one website on the server and on high load data insert in some table takes centuries...it ...
0
votes
1answer
42 views

mongodb equivlant query to this sql group by

I have a collection where most documents have an ISODate column. I'm wanting to get a basic count by date for that column. In MySQL if I had a datetime column on a table, to get what I'd want I'd do ...
0
votes
1answer
89 views

Unable to connect to Mysql at peak time

I have two servers one is application server and another is database server. Continuously I am firing query to mysql. At peak time I get error - Can\'t connect to MySQL server on \'IP Address\' (99) ...
0
votes
1answer
29 views

Replication in mysql with many servers

There are 3 shops. In each of these is a mysql server. I want all servers to synchronize their date if at least one server changes the date. I read a bit of literature and realized that I need ...
0
votes
1answer
41 views

Best Indexing Strategy for Query with Equality[A], Range[B], Group By[C], AND Order By[count(P)]

I have a poorly performing query: SELECT user_id, count(item_id) as count FROM table items WHERE category = 'magazine' AND created_at > 1384754400 GROUP BY user_id ORDER BY count(item_id) desc ...
0
votes
1answer
74 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
1answer
63 views

DB disk space requirements comparision between MySQL versions

I have 2 labs where MySQL is installed. DataBases are created and deleted dynamically by certain internal processes. InnoDB is the Engine used. In one lab, MySQL version 5.0.77 is installed. The DB ...
0
votes
1answer
90 views

Does MySQL load the entire row into memory, or just the columns used in WHERE, ORDER BY and GROUP BY?

I have a table that isn't very large row wise (in the 100ks range), but that contains a lot of raw data that is very large in size. Despite having a relatively little number of rows, it's around ...
0
votes
1answer
65 views

From freelancer to team of two : best way to share/sync db?

I am a webdev. I have just hired a dev. Before that I was alone. Thus, I have to change a bit my organization. I am looking for the best way to develop on the same database (mysql). I am considering ...
0
votes
1answer
287 views

mysql 5.6 GTID replication 'Got fatal error 1236 from master when reading data from binary log'

I Checked SHOW SLAVE STATUS error is "'Got fatal error 1236 from master when reading data from binary log: ''The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master ...
0
votes
1answer
74 views

Relation between multiple hierarchical taxonomies linked to a single entity

I am working on an online test application which supports multiple choice questions. I have created schema for taxonomy (classification) system to be used with questions. taxonomy(id, name, slug, ...
0
votes
1answer
59 views

Mysql query in Database

How to get all the tables from database with all values in tables using single query.. I tried using $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); $arrayCount = 0 while ($row = ...
0
votes
1answer
47 views

Amount of data in a database table

I am trying to run an alter query on a table, and its giving me a Lost connection to MySQL server during query MySQL server has gone away. The query that I am running is alter table table_name ...
0
votes
1answer
697 views

Fedora cannot start mariadb/mysqld

I've done these commands: $ sudo yum install mysql $ mysql_secure_installation $ sudo service mysqld start $ sudo service mariadb start yum installs fine, but when I try to start the services or do ...
0
votes
1answer
334 views

statistics State in MySQL Processlist

I have a busy MySQL Server having query SELECT sys_sess_state, index_state, timeout_lvl, last_queued_dt, last_polled_wait_dt, create_id, create_dt, modify_id, modify_dt FROM PQR_AM_SYSTEM_SESSION ...
0
votes
1answer
71 views

Is it possible to optimize this query? Or any recommendations to speed it up?

After looking at my mysql slow log file I see that almost every entry there is related to this query: SELECT n.nid AS nid, AVG(v.value) AS rating FROM node n LEFT OUTER JOIN votingapi_vote ...
0
votes
1answer
40 views

Uninstalling MySQL on Solaris

I have installed MySQL 5.5.31 in Opensolaris. When I tried starting the MySQL server, it says bash: mysql: command not found So, I decided to uninstall the whole lot and try doing again. But I could ...
0
votes
1answer
71 views

primary key: username+current time or serial

I need to choose a primary key, but I'm not sure what the best option would be. Currently I'm in a scenario where a user has machines (workers) calculating hashes. For each user I track the current ...
0
votes
1answer
49 views

MYSQL Optimize tables on Innodb in production environment advice

According to mysqltunner.pl I have 177 Fragmented tables. I have over 5000 tables and 200 databases. If I run optimize table on each of them, do you think I should take down the application to ...
0
votes
1answer
46 views

Select historical prices for an exact datetime - MySQL

I have a price_list table where I store historical prices for each item. columns are - id, name, price, start_date, item_id When a price is changed, a one new row is inserted with a current ...
0
votes
1answer
63 views

MySQL cluster concurrency

I have a little application that executes select queries against a MySQL cluster. By using 1 thread to read a record the latency is x. By using 2 threads to read records concurrently the avg latency ...
0
votes
1answer
29 views

Server down after PDO connection

I don't know is this off-topic for this site but I have site that run on PHP and MySQL. And I want to change my MySQL connection to PDO. This is my connection file that I include in every file at the ...
0
votes
1answer
85 views

facebook group alike database scheme

Here are my requirements: one user can have many tasks one group can have many task one group can have many users only invited user by a user can be added into a group Does this db design appear ...
0
votes
1answer
48 views

Is it suitable innodb_buffer_pool_size for MySQL Master-Slave

I am wondering how to decide the value of innodb_buffer_pool_size for my Master-Slave style database. I have a set of MySQL, 1 x master + 1 x slave. As I know that the innodb_buffer_pool_size is ...
0
votes
1answer
91 views

How to get names form 3 different tables

I have 4 tables to proceed. In table A I have the parameters of columns in tables B,C,D and the names are there. TB_A ...
0
votes
1answer
67 views

wordpress table is crashed and should be repaired

I run a wordprees website and use a managed VPS server with cPanel/WHM. Got bellow error log and check the table. I repaired the table with repair table command from phpmyadmin. But this problem occur ...
0
votes
1answer
59 views

MySQL thread states when changing an in-memory temporary table to disk-based

In High Performance MySQL (3rd edition) they state that: You can't tell whether a table was created in memory and then converted to on-disk or just created on-disk to begin with... What I was ...
0
votes
1answer
108 views

Debugging error report percona 5.6

I'm running percona 5.6 on a new centos 6.4 server. Things seem to work OK. I personally only really use InnoDB tables for my databases, but only the standard 'mysql' table is in MyISAM format. I ...
0
votes
1answer
52 views

Add column on huge InnoDB table in MySQL 4.1

I need to add a column on a huge InnoDB table (200GB) which resides on MySQL 4.1.21 (SunOS). CPU has 16GB RAM and 200GB of more disk space. Is there any quick way of adding this rather than ALTER ...
0
votes
1answer
115 views

Getting the top count of records from a table for each month and user

I have a table where translations are stored along with the user_id and when the translation was added. I want to create a query that shows the 'Translator of the month' (the person who did the most ...
0
votes
1answer
87 views

MySql - is possible that performance issues are caused by dynamic SQL?

We have this MySQL SP, which uses dynamic SQL. It seems it does NOT perform well under load. It is possible that this SP becomes slow under load because it uses dynamic SQL? Can dynamic SQL cause ...
0
votes
1answer
120 views

Optimizing multiple MySQL sub-queries and joins for multiple runs

The query (below) that's running is taking ~0.6 sec which normally would be fine but it gets run almost 1300 times for different custids. How can I make it run faster? Setup: Mac OS X 10.7.5 MySQL ...
0
votes
1answer
244 views

MySQL select query result set changes based on column order

I have a drupal 7 site using the Views module to back-end site content search results. The same query with the same dataset returns different results from MySQL 5.5.28 to MySQL 5.6.14. The results ...
0
votes
1answer
85 views

Innodb buffer pool indexes versus data usage

The server has 128GB of RAM. The innodb_buffer_pool_size is set to 106GB. mysql> show global variables like 'innodb_buffer_pool_size'; +-------------------------+--------------+ | Variable_name ...
0
votes
1answer
30 views

Migrating database with views trough phpMyAdmin causes error in second host

I'm trying to migrate a database which contains some views and I'm doing trough phpMyAdmin export feature. MySQL version on servers are: Server to migrate: Server version: 5.5.34-0ubuntu0.12.04.1 ...
0
votes
1answer
81 views

MongoDB Storage Architecture (MySQL innodb_file_per_table equivalent to MongoDB)

I am new to MongoDB.I looked inside dbpath I found users.0 - 16.8MB users.1 - 33.6MB users.ns - 16.8MB Further when I dig deeper I found, The .0, .1 files are datafiles. Each datafile is ...