MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
13 views

Restoring Magento MySQL db to

We are moving a Magento site to a new server. When restoring the database, it terminates with error message: ERROR 1064 (42000) at line 11953: You have an error in your SQL syntax; check the ...
0
votes
2answers
33 views

Combine two queries from 1 table, 1 to Many

I have the following queries select o.increment_id, o.customer_id, round(o.base_grand_total * o.base_to_global_rate,2) as revGBP, DATE_FORMAT(o.created_at, '01/%m/%Y') as 'MonthofOrder', from ...
0
votes
1answer
23 views

Unresponsive database, sleeping processes

my mysql database suddenly became unresponsive: OperationalError: (2003, "Can't connect to MySQL server on '<IP_address>' (110)") After killing the processes: ...
0
votes
0answers
14 views

MySQL Case always executes the same [duplicate]

What I want to do is to set DATE_REACT a value when the first condition is satisfied, and a different value when the first condition is not satisfied. The problem is that the first condition is ...
0
votes
2answers
21 views

MySQL Case problem

I am trying to run a SQL code (I use MySQL). What I want to do is to set DATE_REACT a value when the first condition is satisfied, and a different value when the first condition is not satisfied. The ...
0
votes
1answer
18 views

Mysql got signal 11 error

6 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 2014-09-26 12:51:53 14166 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11 ...
0
votes
1answer
32 views

MySQL keeps crashing

I've restored my vserver from a backup which was created by my host. After that my MySQL server is not starting anymore. I've tried several ways to recovery my tables, but it's still not working. ...
0
votes
0answers
21 views

How to split task (read and write) between two mysql server via HAproxy load balancing?

I have done some test and setup two (A and B) different database server from the following link - https://www.digitalocean.com/community/tutorials/how-to-use-haproxy-to-set-up-mysql-load-balancing--3 ...
1
vote
1answer
20 views

different log file for master and beta mysql

Hi i am facing a problem while shipping my database log I have three database server dev, beta and master and i maintain log files for dev on github and every log file has a version given to it like ...
0
votes
2answers
17 views

Set of datetime versioned rows, how to build the most up to date row

I created this SQL fiddle with the sample data The sample data is this: -- -- Table structure for table `dogs` -- CREATE TABLE IF NOT EXISTS `dogs` ( `version_stamp` datetime NOT NULL, ...
1
vote
1answer
29 views

want to find out which databases are used in last 30 days or not

I have about 120 databases in my SQL. I want to migrate so I want to know which databases are not used in last 30 days.
-1
votes
0answers
19 views

SQL: How to optimize a 82+GB MyISAM Database? [closed]

I have a MyISAM DB with some content (users and admins account and thematic content). All query from PHP to my DB with mysql_ library (not mysqli!) have a mid process time 8-12 seconds, if online of ...
0
votes
0answers
18 views

Mysql : too many columns performance [duplicate]

i have a table with 1500 column in my database , my server Ram is 16 and i have 8 cpu , but mysql using 100% of this cpu ,as i traced and checked the slow query logs,i see this problem related to this ...
2
votes
1answer
33 views

What is the best storing device for DB transaction log?

I'm using MySQL with InnoDB storing engine. Transactional log is placed to dedicated HDD. Still as it is HDD atopsar shows big load (>50%) to this HDD because of big amount of small IOs (about 50 ...
1
vote
1answer
10 views

Speed Up Index Creation in MySQL

In MySQL 5.5, I have a table which is recreated on a daily basis and for which the process of adding an index is taking about 50 minutes which I'm hoping to reduce. At the time when the index is ...
0
votes
1answer
31 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)

I can't connect to mysql, through my Ubuntu machine. I get this error. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) I've tried many ...
0
votes
0answers
7 views

MySQL Replication problem with VIEWS and “Sub-Databases”

I've got three servers that should do a master-master replication. On server 1 i got "01_maindb" which holds the master tables. I replicate this table to the two other servers without problems. ...
1
vote
1answer
38 views

Whats wrong with my index?

I have a table, here is the structure: CREATE TABLE `table_data_cache` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `date` date DEFAULT NULL, `enterTollgateNumber` bigint(20) DEFAULT NULL, ...
0
votes
0answers
11 views

period causes results to not display

I have, as an example, the following in a mysql database table: (28,'man vs. wild','discovery',1) Info on my db: mysql 5.5.37 InnoDB utf8_unicode_ci fulltext When I do a search such as this, I ...
2
votes
1answer
67 views

Optimized table design

I am building an advertisements system for websites ( a plugin for a framework ). I am not quite sure how I should set up the table in terms of indexes. Basically there are two options for billing - ...
1
vote
1answer
38 views

Threads_cached 0 while thread_cache_size > 0

I'm trying to little bit understand with some MySQL (in my case - MariaDB) performance. One point I found - "threads caching". So - I set: thread_cache_size = 4 in my.cnf and restart server. In ...
0
votes
1answer
15 views

MySQL: Adding innodb_log_file_size in my.cnf causes not starting MySQL service [duplicate]

I checked and found that InnoDB pluginis active. By default, Innodb_log_file_size=5MB. As per the MySQL Documentation, its ideal values range from 1MB to 1/N-th of the size of the buffer pool, where ...
0
votes
0answers
26 views

Need to show Row Data in The form of Column using MYSQL?

need to show the renewl_year data in the form of column like MEM_Code renewl year 2003 renewl year 2004 renewl year 2005 Paid_amount sum using query:
0
votes
1answer
23 views

How to optimize a very slow query with joins and group by?

I have this GTFS database : All the ***_id columns are indexed, and there are foreign keys between tables (such as a FK on trips.route_id to routes.route_id). So basically the link between a stop ...
3
votes
1answer
42 views

Using an index for both asc and desc on a string column

I know a trick to make order by queries faster when we want to order by asc and desc. For integers store a negated value. So if I store -7,-11,-8,-5,-1,-2 the order by asc will give -11, -8, -7, 5, ...
1
vote
1answer
19 views

MySQL permission denied for database

I have a remote MySQL server running on x.x.x.x. And there is a database named abc. I can do the following mysql -h x.x.x.x -uroot use abc But when I try to mysql -h x.x.x.x -uroot --database=abc ...
1
vote
2answers
40 views

MySQL Slave has unmanagbly higher IO load than master

A MySQL slave having a higher disk load than the master or not being able to keep up is not unusual, nor are questions about it on Stack Exchange, but I did want to run my issue by here, because in my ...
0
votes
1answer
15 views

MySQL server often randomly disconnected

On my web server (OVH/Ubuntu) I have 2 or 3 times a month a mysql interruption, that is all my data are not loaded. I have indeed this following error. SQLSTATE[HY000] [2003] Can't connect to MySQL ...
0
votes
1answer
22 views

MySQL server: Unable to connect with root because of skip-name-resolve option

We had our MySQL server on an old server. We decided to move all of the databases to our new server. Old MySQL Server engine 5.5.31 New MySQL Server engine 5.5.38 We created one general dump file ...
0
votes
1answer
29 views

SQL “select” query for getting 0 instead of null?

In the database I have some value as null . So while fetching these null value from database it should be treated as 0 not as null. Note:- I don't want to be it done by code but from SQL query.
0
votes
2answers
48 views

How to count this table

Hi, how to count value in table like this? This just example: SELECT COUNT(name1) AS newResult1 FROM table As this code just count column name1 and it will give result of 3. What I want to do ...
0
votes
3answers
28 views

how to compress / decompress the mysql database in server?

I'm having lakhs and lakhs of records in my database each year. I often use current year and previous year database only. is it possiable to compress / decompress the mysql database, either in ...
0
votes
0answers
16 views

Which tool is best for creating cluster:Percona Xtradb cluster ,Galera Cluster,all masters topology of Tungsten Replicator or ScaleBase? [closed]

I work in e-commerce site having data around 60 GB and want to set up a cluster.Want to know which tool is best :Percona Xtradb cluster ,Galera Cluster,all masters topology of Tungsten Replicator or ...
0
votes
1answer
18 views

Fastest way to alter column type in a 2-billion+ records innodb table

I have a MySQL table with 4 columns. The 1st column record_id is of type int, primary key, and auto-incremented. Now that I have added more than 2 billion records to this table I am finding that I ...
0
votes
0answers
10 views

error add new data node to mysql cluster

i'm deploying MySQL Cluster and i have prolem when i want add a new data node to cluster, i follow this link enter link description here , but i get error at step 5. When i run command: ndbd -c ...
1
vote
1answer
19 views

WARNING Error checking mysqldump version Error retrieving version from mysqldump.exe: mysqldump: unknown option '--no-beep' (exit 2)

When i go to do a manual export from mysql database to workbench, this error occurs, i dont know solve
1
vote
0answers
8 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
0
votes
0answers
6 views

Optimal config for a small vserver with ispconfig

I have a vserver with debian wheezy, 1GHz CPU single core, 512MB RAM and only 8GB HDD. Owncloud is running, but has its own database-engine How should I configure Mysql so it doesn't slow down the ...
1
vote
1answer
23 views

MySql - unique key not working

I have the following table: CREATE TABLE `timeline_lists` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `list_type` int(11) NOT NULL, `s_object_id` int(11) NOT NULL ...
0
votes
0answers
13 views

MS Access using MYSQL database and error in SQL (memo, hyperlink OLE)

I have a SQL statement that works fine in MYSQL workbench but when used in Access it produces a "invalid Memo, OLE or Hyperlink Object in subquery 'custom_values.value'. SELECT ccr1.value, ...
-2
votes
1answer
28 views

The best my.cnf for my AWS server

I have an amazon server , my mysql is very slow , i dont know what is the best configration for my server , i need to big caching system for improving my website speeds, it's my config : my.conf : ...
0
votes
1answer
20 views

innodb fulltext ibdata1 size

I am running mariadb 10 and have a large innodb table with a full text index. I have innodb_file_per_table=ON I've noticed though that the ibdata1 file grows at the same rate as my table file. I ...
1
vote
1answer
48 views

AND operator in ORDER BY clause

While debugging some code, I stumbled into an error pretty much like the following: SELECT * FROM person WHERE family_size > 3 ORDER BY birthday AND registered=0; The error is that the AND ...
0
votes
0answers
35 views

How to fix my SQL database

I have recently moved a WordPress blog into a new servor which has these caracteristics : debian, mysql 5.0.51a-24, 16GB of ram. The mysql crashed regularly with this log info: Feb 8 12:17:14 ...
0
votes
1answer
22 views

mysql replication - missing table for foreign key on slave

i have the following situation: We're running a simple master slave replication with table filters, so the slaves doesn't have all the master tables. Master has table A with FK to table B Slave has ...
0
votes
0answers
22 views

MySQL event scheduler doesn't work

I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00. CREATE EVENT IF NOT EXISTS actualizar_prueba ON SCHEDULE ...
1
vote
1answer
18 views

Innodb issue is preventing MySQL from starting

For some reason mysqld refused to start after I rebooted my server. Now when I try to start it I will get the following error: [root@vps1 ~]# service mysqld restart ERROR! MySQL server PID file ...
1
vote
1answer
25 views

Binlog not consistent between slave and master

Initially I don't see binlog on slave is updating. Today I discovered and add log-slave-updates option to slave, now it is updating. However, the filename does not match between slave and master. ...
-1
votes
0answers
26 views

Best Mysql Performance Booster for Large Datawarehouse [closed]

What are the most effective and efficient ways to improve the performance of mySQL DB hosting a large Datawarehouse. Please suggest the best methodologies and performance tweaks that should be there ...
0
votes
0answers
27 views

What is the best way to execute a MySQL script periodically on Linux

I want to execute some SQL everyday in a Linux server using MySQL to UPDATE some column's values. In order to do that I use the UPDATE ... SET ... WHERE ... statement. I want to know which is the ...