MySQL : Open-Source, Relational Database Management System
0
votes
0answers
18 views
Retention policy for tmp files created on Mysql slave
What if suppose load data infile is issued in master and I see that it gets replicated to slave first by IO with the infile SQL_LOAD data files and then it triggers its DMLs using SQL Thread.
My ...
0
votes
0answers
24 views
MySQL becomes unresponsive because user reached its OS quota
In CentOS 6.3/MySQL 5.1.67 I had an user that runs wordpress reaching its OS space quota (mostly files, the DB is less than 100Mb). When the user tried to create a post it triggered an [ERROR] ...
0
votes
0answers
65 views
MySQL Pivot Table Naming Conventions
I have some tables (users, jobs, customers) that are each tied to 'groups'. As each table is linked to 'groups', I feel inclined to call the actual group tables user_groups, job_groups and ...
0
votes
0answers
11 views
How to replicate some databases from a slave to another slave?
Right now, we have a MySQL 5.5 master which replicates all 10 of its databases to two slave servers, slave1 and slave2. I want to offload some processing to slave1, so I want to move two databases ...
0
votes
0answers
34 views
InnoDB best index practises
I have an InnoDB table with around ~3.7m rows in it. Here are my current indexes:
...
0
votes
0answers
50 views
MySQL Partitions
I've done a lot of work with MySQL but generally on a much smaller scale than this, so please excuse my ignorance.
We've got an InnoDB table which is currently storing ~3.5 million rows, which I know ...
0
votes
0answers
22 views
mysql crash SIGSEGV under stress
I am running a server in C++ which is using MYSQL client library. When simultaneous connections are 200 or more I see mysql doing a SIGSEGV. How to handle them
Thread [17] 2844 [core: 0] (Suspended : ...
0
votes
0answers
131 views
Achieve PostgreSQL hstore functionality in MySQL
Please suggest any MySQL 5.5+ Engine that can support collection of key-value pairs be stored in any column of a table.
I don't know if this feature is available out of the box in MySQL like ...
0
votes
0answers
26 views
MySQL adding hosts in user table that were deleted in the past?
Ok this is going to sound a bit complicated...basically, I was testing some things related to granting and revoking privileges to given host names on mysql. Let's say these 'test hostname values' ...
0
votes
0answers
14 views
Stop logging a single users queries in the MySQL logs?
Is there anyway to setup a specific user who's queries won't be recorded in the log files? So that an application can have a user who to query sensitive data separate from a standard user for making ...
0
votes
0answers
37 views
MySQL Stored Procedure
I am developing a database for an eCommerce website, I have written the stored procedure for the following tables,
user_master,
authentication_master,
country_master,
public_master.
I have ...
0
votes
0answers
39 views
Mysql notifier Error
i'm getting error when opening Mysql notifier High Severity Error Element 'UpdateCheck' was not found. Line 3, position 2. My mysql server is running. why it's showing this error.
0
votes
0answers
57 views
Stored Procedures and Functions in MySQL
I just need to know about Stored Procedures and Functions in MySQL.
While I designing a database for an eCommerce website, I was in a situation to write stored procedure for my database, this is new ...
0
votes
0answers
22 views
Checking of one specific element of one array is in another array?
Suppose I have two arrays. One looking like (3, 9, 10, 39), and one looking like (4, 10, 9, 48, 391, 2).
How would I (through pure MySQL) check if one of the elements in the first array is inside the ...
0
votes
0answers
119 views
MySQL Database Recovery from ibdata1 and .frm Files Fails
My MySQL database server crashed but I managed to recover copies of the ibdata1 and .frm files.
I have followed instructions, including some from this site, that say to do a clean install and ...
0
votes
0answers
44 views
MySQL max_connections Changed Without Notice
I'm running a Linux (512MB of RAM) server with MySQL 5.1.
I host an app that is used by a small # of users (less than 50). Everything has been working fine until yesterday, connecting to my DB would ...
0
votes
0answers
87 views
How long would a delete take for 50 million records in MySQL/InnoDB?
How long would a delete take for 50 million records in MySQL with the InnoDB engine?
Server Config:
MySQL Version 5.0.77
CentOS 5.4 Final
64 bit 16GB RAM
RAID 5
Processor Model : Intel(R) Xeon(R) ...
0
votes
0answers
42 views
Mysql scheduler is not running
I have create few events in my db. One is to daily create partition. Another is to summarize data on every second from another table. I notice everything is not running. What would have cause the ...
0
votes
0answers
480 views
1286 - Unknown storage engine 'InnoDB'
I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
0
votes
0answers
18 views
MySQL longtext , when search turkish characters it is empty
my long text field data is storing hexdecimal
for example :
Data
Allah'tan ayr\u305 ? olursa rabbini unutursa kendini unutursa ne olur? G\u246 ?n\u252 ?l cehenneme d\u246 ?ner. Onunla beraber ...
0
votes
0answers
364 views
'Incorrect datetime value: for column 'last_login' at row 1'
i am getting below error:
Last_SQL_Errno: 1292
Last_SQL_Error: Error 'Incorrect datetime value: '2013-03-10 02:00:00' for column 'last_login' at row 1' on query. Default database: 'platform'. ...
0
votes
0answers
20 views
View is not dropping
I tried removing a view in HeidiSQL, and it froze bunch of times. So I connected to a database with Putty, ran a command
DROP VIEW item_view;
and nothing happened, its still running and command ...
0
votes
0answers
39 views
How we can synchronize a MySQL database to an Oracle database?
How we can synchronize a MySQL database to an Oracle database?
The Oracle database is in secure zone that can only be accessed by application servers. We have multiple MySQL databases in different ...
0
votes
0answers
64 views
How can I get multiple rows instead of columns after self-joins?
This is my situation (the real table isn't about people but about paths):
[Table: People]
id | name | type | related_to
----------------------------
1 | | | 0
2 | Nico | Friend | ...
0
votes
0answers
33 views
Conditional Import
I have 300+ flat files. I am importing/loading them using
LOAD DATA LOCAL INFILE 'D:\\MxxT\tot2098.TXT'
INTO TABLE Twenty.F98
FIELDS TERMINATED BY '' lines terminated by '\r\n' ;
on my MySQL ...
0
votes
0answers
11 views
hosting account with advanced mysql privileges
Is it possible to have a mysql database where either:
a) the user has limited permissions on a table by table basis (e.g. can only select, insert from table_a, and can only update table_b)
b) ...
0
votes
0answers
66 views
Migrating database from OSX to Linux
I followed the setup in below link, to setup mysql. Basically, I am have a master on OS X server and want to setup a linux slave.
Create a mysql slave database from master database
After I copied ...
0
votes
0answers
50 views
How can a SQL database be migrated to MySQL faster?
I have a SQL Server DB. I want to migrate that DB to MySQL. In my SQL Server DB, some tables has about 50,000 to 1,00,000 records. I am trying to migrate the DB by DB migration tool embedded in MySQL ...
0
votes
0answers
48 views
Returning multiple resultset from the same table
i am working with mysql procedure. final result set i have got in to one table.
now i need to return for each set i need to return the value.
example:
like this is contents in my the table.
i need ...
0
votes
0answers
76 views
mysql alternative to prepared statements in triggers
I'm trying to get some stored procedures to fire from a MySQL 5.1 trigger. When these were called without triggers, I used prepare and execute statements to build queries and other SQL calls. I have a ...
0
votes
0answers
46 views
Multiple restores using incrementals and xtrabackup
I'm using Percona's innobackupex/xtrabackup tools to maintain backups of some innodb only mysql instances.
I've run into a situation where it seems after I do an initial restore the act of applying ...
0
votes
0answers
55 views
MySQL Communication link failure
I have several batch processes in which i insert and delete data large amounts of data and occasionally i receive this error.
Communications link failure
The last packet successfully received ...
0
votes
0answers
36 views
Duplicate entry '0' for key 'UQ_CallsIDCC'
I have my own Server with Voice Switch and not really familiar with SQL.
Having problem with following:
02-25 12:05:32 MySQL error description : Duplicate entry '0' for key 'UQ_CallsIDCC'
02-25 ...
0
votes
0answers
55 views
MySQL flush tables taking too long
I am using MySQL 5.1. I have many databases with a lot of tables.
I used to do a Flush Tables once a day, and it used to take about 5 minutes. Since last Tuesday, it takes about 1.5 hour to be ...
0
votes
0answers
45 views
400GB Innodb table with deletes and no data_free?
I have an Innodb table which is over 400GB and performing quite a lot of deletes on it, so I thought I should try to optimize the free space kept it is probably creating. I ran this query to find out ...
0
votes
0answers
63 views
Single slave - multiple master MySQL replication?
I need to replicate different MySQL databases from multiple master servers into a single slave server. Have installed multiple mysql instances on single machine with 2 different my.cnf & my1.cnf ...
0
votes
0answers
38 views
How to use MySQL proxy with Python
I have two questions regarding MySQL proxy:
How can I use MySQL proxy to track all data which to my server?
How can I embed the MySQL proxy into a Python script to track
all traffic which is coming ...
0
votes
0answers
58 views
How to do point in time recovery of binary log files into .sql file
I have written a shell script to do an incremental backup of MySQL database.
For point in time recovery I'm using the binary logs generated in /var/lib/mysql directory.
For point-in-time recovery, Im ...
0
votes
0answers
38 views
Phpmy admin not showing my table but mysqldump
I have a db running and suddenly when I go into my phpmyadmin under the db it shows no tables and when I tried to do dump it shows me some of my tables are crash. What is best survival in this case?
0
votes
0answers
24 views
Table that writes most of the time, and also read for autocomplete, which MySQL engine to use?
Recently I met a challenge for my autocomplete search (http://stackoverflow.com/questions/14923342/search-wildcard-multiple-columns-in-rails-using-one-param). I am using "SELECT ... WHERE MATCH(...) ...
0
votes
0answers
45 views
What would this non-'unique index with a unique search condition` query lock?
I am not sure about this part of the transaction manual
For locking reads (SELECT with FOR UPDATE or LOCK IN SHARE MODE), UPDATE, and DELETE statements, locking depends on whether the statement ...
0
votes
0answers
65 views
how to install zabbix agent in agent host which we are adding from server to monitor
following this site i have intsalled zabbix server and agent in centos 6.0
zabbix version :1.8.5
http://www.youtube.com/watch?v=sKfYm-3thRM
but i am unable to add agent that is how to add other ...
0
votes
0answers
107 views
Mysql Incremental Backup and point in time recovery
I'm writing a shell script using the concept of binary logs for point in time recovery.
Now, the scenario is such that a full-backup will happen every alternate day and Incremental backup should be ...
0
votes
0answers
25 views
how to tranlate MySQL code so that it can be used in PHP MyAdmin
I have a problem with my database view that is answered in another post. The answer shows the following solution:
mysql -uusername -ppassword -A --skip-column-names -e"
SELECT CONCAT('SHOW ...
0
votes
0answers
73 views
Performance Optimising MySQL query
I have this query in my mysql database, when i execute this, it takes about 4 sec. To give me the result (on xampp 1.8.0 with mysql 5.5)
I was wondering if there is any way to enhance this query so ...
0
votes
0answers
335 views
How to use SUBSTRING using REGEXP in MySQL
I have the following situation. I have to substring regular expression from description using MySQL.
Description:
Lorem D9801 ipsum dolor sit amet
Where D9801 is REGEXP. Every strong text ...
0
votes
0answers
41 views
row locking or avoiding duplicate insertion on primarykey/otherfield combo
i have a table that stores additional data pertaining to files/images saved in files elsewhere, each entry can be associated with another type in the system,
for users there may be one or more ...
0
votes
0answers
26 views
MySQL partitioning by customer
We have a product that uses different MySQL schemas for different customers, and a single Java application that uses different persistence units for one for every customer. This makes it difficult to ...
0
votes
0answers
29 views
MYSQL Clutser (NDB) varchar storage requirement if indexed(Unique Index)
In MySQL Cluster (ndb engine) disk based table, if a column is varchar(255) with UNIQUE INDEX defined then,
For Latin(default) char set, does varchar column takes fixed size?
For UTF-8 (3 char ...
0
votes
0answers
87 views
table is full in innodb
One of the table t_keyword_stat_ga in the my DB on server(currently the master) was set as INT for a column id. This column is also set as the auto_increment. As noticed today the INT column reached ...
