MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

2
votes
1answer
33 views

Automating MySQL DB Creation with Specific date

Here i come again with another challenge . Basically i'm looking forward for the best way to have a windows based script to create a MySQLDB, or multiple MySQLDB, once a week having the following ...
1
vote
1answer
1k views

MySQL Service is not starting on linux

I am having a problem with my database it does not want to start :( the server is running on linux centos 6.2 it was working until I emptied the logs I don't know if this have anything to do with ...
1
vote
0answers
250 views

InnoDB: error: space object of table

131212 10:35:18 InnoDB: error: space object of table 'main/wp_m_membership_levels', InnoDB: space id 119 did not exist in memory. Retrying an open. 131212 10:35:18 InnoDB: error: space object of ...
1
vote
1answer
73 views

Group by and average from related tables

Ok so this is kinda weird I'm not sure how to exactly tackle it without it being a massive query, that might be slow so this is the tables as it is Concerts: name | country_id | ticket_price foo 2 ...
2
votes
1answer
769 views

How to modify `proxies_priv` in MySQL

I recently received a warning from MySQL that stated: [Warning] 'proxies_priv' entry '@ root@serverdomain' ignored in --skip-name-resolve mode. I looked in mysql.proxies_priv and there is ...
1
vote
1answer
2k views

Recovering MYSQL databases

I needed to reinstall the WAMP server on Windows and in the process it reinstalled MYSQL as well. Now when I login to phpmyadmin, I can see my databases with the tables listed on the left side ...
1
vote
0answers
187 views

MySQL Link to PHPMyAdmin/MS Access

I have a mysql database stored on a server via phpmyadmin. I want to link this to MS Access for other users. I often link mysql databases to MS Access which are stored locally, but never DB's stored ...
1
vote
1answer
4k views

Stored Procedure Performance using Temporary Tables

I have the following Stored Procedure I would like to improve the performance of DELIMITER $$ CREATE PROCEDURE NEXT_UNIT_OF_WORK ( IN batchId INT, IN size INT ) BEGIN start transaction; ...
1
vote
0answers
100 views

Schema for yearly data models

I am developing a school management system. Most data will not be reused after the end of the school year. I am contemplating using schemas to separate data in various school years, however I am ...
2
votes
1answer
77 views

When should I start using connection pooling?

I have a MySQL database that peaks at about 300 connections/sec. What is the recommended connections per server and at what point should I start using connection pooling?
0
votes
0answers
79 views

Inserting and updating on same table

I am currently working on a database that aims to provide information regarding the amount of time people stay in a company's car-park premises. This is done using a table called "tbl_stay" which has ...
0
votes
0answers
155 views

Making cloned copies of a innoDB mySQL database

I'm trying to find a better way to clone innodb mysql database then using regular import. We use an innoDB mySQL database in production. A backup is created daily from production. Currently each ...
0
votes
1answer
63 views

How to give a client backups of their data without compromising our database design? [closed]

The client is asking for backups of their data, however we would not like to share our database design as it may lead to a security risk... inb4: Security by Obscurity is not a valid security control ...
1
vote
1answer
55 views

Is it more efficient to store 0 and 1 for a binary value or just empty and 1 in MySQL

Is it more efficient to store 0 and 1 for a binary value indicating whether a flag is up or down or just empty and then set 1 for rows where the flag is up. Using MySQL. E.g. Flag 0 1 1 0 0 Or ...
1
vote
2answers
136 views

What is a mysqld process in a MySQL cluster?

As I know, a mysqld process is a kind of a router of a MySQl cluster. It directs requests to the right ndbd node. Assuming I have 3 ndbd nodes on 3 different machines and I don't use replication. How ...
0
votes
3answers
219 views

Large database - too much time spent opening and closing tables

I have a MySQL server (5.5.31) with 450 databases of some 200 tables each. (Yes, 90,000 tables) When we're under high load, there's over 100 concurrent queries, of which 70% are either opening or ...
1
vote
2answers
107 views

Creating a mysql trigger without hard-coding database name

Is there a way to create a trigger in mysql without hardcoding the database name? Doing a typical create trigger will stop working if I dump the database and then import it into a database of a ...
0
votes
1answer
121 views

MySql One-to-zero to one-to-one

I have a table Persons with id as pk and auto increment. Then I have a table Addresses with id as pk and fk to the Persons id. But now person can exist without an address, and I don't want a person to ...
0
votes
0answers
122 views

Error adding constraint foreign key to bridge table

Hi there I am fairly new to sql development. I am current following the head first into mysql book and is on chapter 6. On chapter 6 there is a table in third normal form but it does not contains the ...
2
votes
3answers
6k views

Purge old records from mysql ibdata1 file

Is it possible to purge old records from an ibdata1 file without taking down the database attached to it? Records that have been deleted from the database are still present when I scan ibdata1 for ...
2
votes
2answers
152 views

How to store logs correctly?

(This is somewhat a follow up on my last question) I am using MySQL 5.5 with innodb. My Log table consists of two columns. One for user number, and the other for a string consisting of IP, request ...
1
vote
1answer
302 views

Mysql HY000 the table table_name is full when adding new column

I can't add a new column innodb table which size's 16MB. when I try to add, mysql says HY000 the table table_name is full. I changed my tmp_table_size and heap_size but mysql still says same error. ...
1
vote
0answers
139 views

MySQL join query indexes

After recently discovering the MySQL feature to log queries that aren't using indexes, I've been chasing these down in a large app, looking for places to improve performance. There is at least one ...
1
vote
1answer
1k views

MySQL Regex matching newline or end of string

I have a text column in mysql which contains some values separated by a newline. I want now to query by these values and thought a regex should help me with that by doing something like: SELECT * ...
1
vote
0answers
45 views

Find the neighbouring polygons of a given polygon in a MySQL spatial table in ver < 5.6.1

Finding neighbouring shapes in MySQL spatial table made up of ID and 2D geometry (polygon) fields. I have a table with an ID column and a geometry column (holding a polygon) representing various ...
1
vote
2answers
317 views

Is there a Successor or an Alternative to mk-parallel-dump?

Just read about mk-parallel-dump in a possibly-outdated version of High Performance MySQL. Sounded great, but when I went to download it I found out that it's deprecated with no equivalent command in ...
1
vote
1answer
1k views

MySQL SELECT query hangs - Opening Tables INNODB

On my server I have 6 MySQL databases. They all power Wordpress websites. For some reason, 2 of these databases are not accessible. To my knowledge they use INNODB, but I can't confirm it as even ...
0
votes
0answers
390 views

Queries get stuck for no obvious reason

We have magento running with MySQL. We're getting problems where queries would take much more time to execute than they should. In example: INSERT INTO `catalogsearch_result` SELECT 63 AS ...
0
votes
1answer
274 views

Why does importing a MySQL dump cause so many I/O?

I imported 100 SQL-format dump files. The total size was 20 GB. The resulting .ibd files after the import had a total size of 40 GB. mysqld.exe wrote 1.1 TB and read 120 GB on the disk. Why so many ...
1
vote
0answers
92 views

How can I ensure a valid MySQL -> Postgres migration? [closed]

Our projects are migrating from MySQL to Postgres. We have a Ruby-on-Rails app that handles the schema (source code is on github). We have rewritten all queries to be ANSI-compliant. We have tried ...
4
votes
1answer
1k views

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then ...
7
votes
2answers
11k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found after upgrade to mysql 5.6

I upgraded to mysql 5.6 from 5.5, and now my logs are littered with such messages on startup I found a possible solution here, but it does not seem official. ...
0
votes
2answers
636 views

Warning before issuing delete/update command in mysql/oracle , then executes

Is there any utility , function either in mysql /oracle that if i issue some delete/update command wrongly , a message must prompt at command_line* (if possible in ubuntu) asking whether "you sure to ...
1
vote
0answers
164 views

Cumulative Function in MySQL

i have a problem creating cumulative function in mysql database. let say i have a stored procedure which getting data and counting quantity/sum_quantity example A table consist of consumer goods ...
0
votes
0answers
58 views

mysqldump file size changes drastically with repeated runs

I've been performing some maintenance on a server that I have and part of that was cleaning up a script I had for creating mysqldumps on an automatic Windows Schedule. The only change I made to the ...
1
vote
2answers
609 views

MySQL query log

I wonder if there is an alternative for MySQL general query log. I would like to log (mostly) DDL statements, so I could trace what user DROP database/table etc. I know that enabling general query log ...
1
vote
1answer
450 views

MySQLdump on specific db date

I'm new in here and i don't really know where to start but here is my concern. I need to backyp a MySQL DB running under windows once a week. For e.g every friday i need to backup and transfer to ...
-1
votes
1answer
38 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
36 views

Export database in one file with every dataset existing

I've got a unusual question. The human resources needs to export an old DB to a new one. And the guys managing the new DB wants one csv file with every dataset existing. I did a Relational database ...
1
vote
2answers
1k views

Determining what algorithm MYSQL View is using

When creating a MySQL View, the algorithm is set to UNDEFINED. How do I see which algorithm MySQL is choosing for the query ? I tried using "EXPLAIN", but it is not obvious from the results what ...
0
votes
1answer
135 views

Max allowed packet changed still replication not starting

Suddenly I notice my replication stopped and first I got some primary key duplication error when I checked using the show slave status\G. Then I remove those lines and restarted and ending up now with ...
0
votes
2answers
149 views

Should we explicitly lock MyISAM tables or is it implicit…?

Does MyISAM tables automatically lock a table for each select or insert statement .... I mean if I query the database as select * from tablename then does the MySQL engine first lock it for read ...
0
votes
1answer
186 views

mysql start and stop error

I install a mysql 4.1(Ok it's very old version) on debian. the service start and stop correctly but show this error. root@VM03:~# /etc/init.d/mysql start /etc/init.d/mysql: 63: /etc/init.d/mysql: ...
0
votes
3answers
11k views

How to migrate Oracle database to MySQL server?

Currently our application is running using Oracle 11g database. We are developing newer version of the application which runs on MySQL cluster. We need to migrate the data from Oracle database to ...
0
votes
1answer
414 views

InfoBright LOAD DATA INFILE Wrong data or column definition

I'm using BRIGHTHOUSE engine. I have a column defined as varchar(100). When loading data into the table, if the column data exceeds 100 characters, the engine will throw 'Wrong data or column ...
0
votes
1answer
226 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
9k views

node unable to join a galera cluster; it fails during state transfer

It looks like the node is joining the cluster and then it fails… I have tried with both rsync and xtrabackup and it fails during state transfer. I seems to me that I am missing something real simple ...
4
votes
2answers
515 views

Architectural Help Needed - MySQL or NoSQL for a table with 54 million records

We have a table with 54 million records. Here is the table structure. CREATE TABLE `metaplay` ( `track_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) DEFAULT NULL, `completed` int(11) ...
0
votes
1answer
27 views

Change MySQL 4.1 Windows to MySQL 4.1 Linux- Problem with the key Sensitive in query

I need help to resolve this problem. change the server MySQL 4.1 run on Windows to MySQL 4.1 run on Linux(debian). This all working, but same query not return the correct data because key ...
1
vote
0answers
760 views

Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum

Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum. It happens on a specific database but spans multiple ...