MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
18 views

Multiple Selects Into Multiple Columns Encrypted [on hold]

I am trying to do two select statements on the same table. However I get errors. The reason for this query is one of the columns is 256 bit CRC encrypted. Here is my query: SELECT (select COLUMNA ...
4
votes
3answers
134 views

How to detect inactive tables?

I started working on a project whose former developer ragequited, and it left a complete mess both in the code and database. The server is using MySQL 5.5 There are a lot of tables created for backup ...
0
votes
1answer
123 views

MySql: Slow join and group by on indexed columns

The following query takes 15-20s to run SELECT "Trade_US"."ID" AS "Trade_US.ID", "Server_US"."Name" AS "Server_US.Name", "Trade_US"."TradeTypeID" AS "Trade_US.TradeTypeID", "Users"."ID" AS ...
1
vote
3answers
7k views

MySQL 5.6 Failure

I have the following in RPM_UPGRADE_HISTORY in /var/lib/mysql MySQL RPM upgrade to version 5.6.10-1.linux_glibc2.5 'pre' step running at Fri Mar 15 15:41:26 EDT 2013 ERR file(s): -rw-r----- 1 mysql ...
1
vote
1answer
26 views

Need help rectifying IN/NOT IN clause

Hi there everyone! I have built a link/content sharing site. The way it works is that each link can have multiple categories assigned to it. A video of a motorcycle race might have motorcycle, ...
0
votes
2answers
45 views

Recommendation for the mysqldump?

I have approx 90 GB of database, I need to schedule a mysqldump backup , thats why I Required a recommendation how much time it takes for the full hot backup? Because I didn't taken that much size of ...
1
vote
1answer
405 views

creating a report on the mysql jasperReport server

I have mysql local database, in it I have sample data mart. I have installed jasperReport server to my computer. Just using this tool, I want connect to the local mysql database and just create a pdf ...
0
votes
1answer
14 views

Filter mysql group by negative having contains

How can I get all of the values from 1 column, which do not (or do) have a specific value in one of their rows? For instance, consider example table: | ColA | ColB | --------------- | aaa1 | zzz1 | ...
0
votes
0answers
7 views

InnoDB problem when upgrading to Joomla 3.X

we have different Joomla and WordPress sites on 1 server. We want to upgrade a Joomla 2.5 site to Joomla 3.X. The upgrade only works when we remove the dbdata1 file in MySQL(it is automatically ...
1
vote
3answers
43 views

Automate CSV files to MySQL Database?

I'm a little mind struck at the second as I am looking to automate the following sequence: Extract Data from Microsoft Access Save files as CSV Connect toMySQL server Run one SQL file that exports ...
0
votes
1answer
106 views

Tuning Mysql and Monitoring

I would like to know if anybody can point me towards a tool/way for MySQL database tuning ... Actualy the tunning of my.cnf is like below My database is in MyISAM | Mysql 5.1.73 key_buffer = 500M ...
0
votes
0answers
11 views

Auto created accounts mysql

i have a small question about accounts auto-created after a fresh mysql install. there is an account with Host = localhost, user = 'No user name specified', password = 'No password specified' if i ...
0
votes
0answers
16 views

Concurrency Problem in Inserting data

In a PHP-MySQL app we have a memeber table that we use to store our members data. Before inserting a new member we check member existence based on mobile number and if there is any record we update ...
0
votes
0answers
15 views

Manage duplicate records and other entries based on duplicate records in MySQL

I have following list of tables for my PHP Application. wi_individual_g(ind_id,ind_name,ind_father_name,ind_spouse_name,is_employee,org_id,ind_dob,...) wi_individual_p(ind_id,prg_id,...) ...
0
votes
1answer
20 views

set global variable parameter?

My prod_server version is 5.1.47 and want to set the slow query log dynamically for certain period of time. I refered one site(http://toastergremlin.com/?p=276) there is mentioned below 5.1.6 we need ...
0
votes
0answers
16 views

show remaining products

I want to show remaining stock after selling. I can use view table to show the remaining stock but its not a good practice.Is there any other possible way to work on??
2
votes
1answer
291 views

Best Practices for Creating and Deleting Records in MYSQL

I'm fairly new to working with databases, but I've currently have a webCrawler that I've written in C# using MYSQL database. The crawler is frequently writing and deleting records from the database ...
0
votes
1answer
276 views

How to organize the tables of a MySQL database with several statistics data of several years?

I am developing an app that must provide statistics information about the distribution of the money that a person spends each year in taxes in the city where he lives. The user should select the ...
1
vote
1answer
411 views

Connecting to MySQL 5.1 using IBM Data Studio

I am trying to connect to MySQL database version 5.1 hosted on a web server using IBM Data Studio 4.1. I am getting an error "The JDBC driver class was not found in the specified JAR or .zip file. ...
0
votes
1answer
85 views

MySQL: summary query for date activity by last 7 days, week and all year totals

I have a customer table with records like ID Name Date Status 1 Joe 2014.02.01 New 2 Bob 2014.02.02 Requested 3 Rob 2014.02.02 New 3 Dale 2014.02.02 New 4 Jane 2014.02.03 New ... assume ...
0
votes
1answer
17 views

performance of handling many inserts into an Amazon RDS instance; are there other options? [on hold]

I am looking at using Amazon RDS for MySQL. However, the performance has not been acceptable. Using SQLite, I get about 1000 inserts per second whereas on Amazon RDS, I'm getting about 5 inserts per ...
1
vote
2answers
23 views

MySQL, RAM disk for tmpdir - how to figure out what size it should be?

We regularly run a few large SQL queries to generate reports. It seems that the bottleneck is the amount of time that is spent writing to the tmpdir, which is currently on disk. We are upgrading to a ...
9
votes
4answers
3k views

Benefits of using backtick (`) in MySQL queries?

In MySQL we can create queries with or without the backtick (`) symbol. Example: SELECT * FROM TEST; SELECT * FROM `TEST`; Both works fine in mysql-console. Is there any technical difference ...
0
votes
1answer
15 views

Is there any way to perform atomic updates of stored procedures in MySQL?

I know that MySQL does not support atomic updates of stored procedures yet and it is bug which was reported on 2005 but not yet resolved.(http://bugs.mysql.com/bug.php?id=9588). In our project ...
1
vote
1answer
441 views

How to removing or reduce the size of redo logs in MySQL cluster

Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
0
votes
1answer
44 views

GROUP BY on two large joined tables

I have two tables: Person ------ PersonID (PK) GroupID DeletedDate PersonData ---------- PersonID (PK) FieldID (PK) Value The fields are custom-created; hence the schema. I am trying to run a ...
0
votes
1answer
22 views

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again?

what will happen to the binary log if it reaches its maximum value ? Does it reset to mysql-bin.00001 again ? I know the below points exist means, there won't be any reset happen in binlogs. I ...
1
vote
1answer
106 views

InnoDB internals - checkpoint, LSN, dirty pages

I'm looking into InnoDB internals regarding buffer pool, checkpoint and dirtypage. However there isn't enough information to answer my question. When I run show global status, I can get ...
3
votes
1answer
177 views

MySQL fulltext selection performance

I have 1.5M rows in a table. Following is the table create code: CREATE TABLE `jobs` ( `id` INT(8) NOT NULL AUTO_INCREMENT, `job_id` VARCHAR(50) NOT NULL DEFAULT '', `title` VARCHAR(255) ...
0
votes
2answers
29 views

Transaction has set autocommit = 0, but still the update happens before I commit

I have multiple MySQL InnoDb tables, I am trying to alter/insert/modify many of them in a SQL transaction, I set autocommit to false, so that if some SQL statements fail, I do commit the rest of ...
0
votes
2answers
333 views

mysql.sock not found on CentOS 7 machine

I am getting the following error when I try to log into mysql from the CentOS 7 terminal of the machine where mysql is installed: ERROR 2002 (HY000): Can't connect to local MySQL server through ...
0
votes
1answer
26 views

Possibly a silly question: Can I install MySQL on an External HDD connected to my Router?

I have a 1TB Western Digital External HDD and I was wondering if I can turn it into a MySQL Database? The HDD itself is connected to my router via USB (BT Home Hub 3) and I would like to experiment ...
1
vote
2answers
23 views

Number of connection running within certain period of time?

Is there any way to capture number of connections or processes which is running on the prod server each 10 mins of interval? And MySQL version is 5.1.47.
1
vote
1answer
26 views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
0
votes
1answer
114 views

Add partition works but not the drop partition

We have set an event as below. What we notice is that the add partition is working well as we can see on a daily basis the partition list is growing but the drop partition is not working well any ...
1
vote
1answer
102 views

Mysql join table order by index

First Master Table CREATE TABLE `edipostingmaster` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `applied` int(11) DEFAULT '0', `fileName` varchar(255) DEFAULT NULL, `checkNo` varchar(100) ...
0
votes
0answers
17 views

MySQL ALTER TABLE table_name AUTO_INCREMENT=1 doesn't work

I'm using yii and it's test system. Yii's fixture manager resets tables and their AI keys so: DELETE FROM table_name; ALTER TABLE table_name AUTO_INCREMENT = 1; It was working good on server before ...
0
votes
1answer
118 views

getting “table is full” error even if the table size is much smaller than tablespace

Currently I am using MySQL NDBCluster 7.3.5. I have created one UNDOFILE hhme.dat with INITIAL_SIZE=200m. Also one tablespace hhmefep_tbs with DATAFILE hhmefep_tbs.dat having INITIAL_SIZE=500M ...
0
votes
2answers
26 views

SELECT that is null if there is one more register in this date that is not null

I'm trying to make a query that I can't produce... This is my table capturainfo captureid int(11) userid int(11) date date dateinit datetime datefin datetime I need to select ...
0
votes
1answer
38 views

MySQL: Get comma separated values from a table, should not exist in another table [on hold]

I have two tables, table structures as below. Table: items Id item_name item_ids 1 pens 10,11,12,13 2 books 20, 30 3 computer 50, 60, 80 Another table : ...
2
votes
1answer
521 views

MySQL Queries take up to 35 seconds

My site is very slow sometimes, so I activated the php-slowlog to find out whats wrong. It is full of mysql-functions like mysql_query. So I activated the mysql-slowlog and found out that some querys ...
1
vote
2answers
31 views

InnoDB row metadata size (minimum row size)

I'm trying to decide whether to normalize a thing further, and need to know what the smallest a row in InnoDB can be (I've got MySQL 5.6). This is not exactly my case, but for simplicity, let's ...
6
votes
2answers
4k views

Running SQL Query on all databases

I have one hosting account using cPanel and phpmyadmin. I have 50 databases under this account, all WordPress. I need this query modified so that it runs through all databases to update the ...
2
votes
1answer
2k views

Extract MySQL information from a compressed tar.gz file

I have a back up-of a MySQL database which is contained in a .tar.gz file - I need to restore it. I've never had to do this before. The only way I can access the database is through phpmyadmin. There ...
0
votes
0answers
14 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
0
votes
1answer
52 views

Can queries containing deterministic user defined functions be cached in mysql query cache?

According to the mysql 5.6 docs: A query also is not cached under these conditions: ... It refers to user-defined functions (UDFs) or stored functions. However, I have seen claims that if ...
0
votes
2answers
140 views

How do I find duplicate values in multiple columns over different rows?

I have a database with a table of games (some columns omitted): gameid hometeam awayteam `date` Sometimes games are added with the same home and away teams, but on a different date that is just 1 ...
0
votes
1answer
38 views

SQL error: Unknown column in 'where clause' [on hold]

I have following very simple PHP MySQL Query: $sql = 'SELECT * FROM bundesland WHERE bkuerzel = ' . $_GET['q']; $result = mysql_query($sql, $con); When I execute the query with a click on a item ...
1
vote
1answer
851 views

mysqlcheck --repair a specific table?

I logged in my server via SSH and committed a "repair table xxx" query on a MyISAM table with 34 million rows and 69GB of data. Unfortunately the SSH connection was lost. When I logged back in I found ...
-1
votes
1answer
16 views

Query error int/varchar LEFTJOIN [on hold]

Can someone tell me what´s wrong with this query? $sql = "select bans.id as banid, bans.type, bans.data, bans.reason, bans.expire, bans.added_by, bans.added_date, players.id as playerid, ...