MySQL 5.5 brought many performance enhancements and expanded the feature set of the popular open-source RDBMS.
0
votes
1answer
1k views
MySql 5.5 in ubuntu repository
Sorry for duplicate question.
I am looking for the best way to install mysql 5.5 on ubuntu.
So far, there are few options:
Installing from tar.gz
Installing from PPA.
Alien on RPM.
All of them ...
1
vote
1answer
346 views
when will Innodb support activation of triggers on cascade foreign key? [closed]
The Manual says: http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html
Currently, cascaded foreign key actions do not activate triggers.
Any Idea when will this be implemented.
Is ...
2
votes
2answers
902 views
mysql 5.5 corrupt - missing temporary table
One of our mysql instances crashed and failed to start:
120422 10:04:13 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './databasename/#sql-29f6_45.ibd'!
...
1
vote
2answers
670 views
MySQL Table level Replication
I have 3 servers, say A,B &C. All have the equivalent data(same data). Now what I want is to make A as the master and B,C the slaves.
But the scenario is that I only want to replicate some of the ...
1
vote
1answer
873 views
MySQL Workbench ERROR 1064
I have a problem with my database. I have created the model and now I want to sync it with my database on my WAMP Server (local) but it keeps giving me an error. I searched for the cause of the ...
4
votes
2answers
5k views
How do you remove fragmentation from InnoDB tables?
I have a Database having number of tables.
I want to delete some records from the tables say the no of records are more than 20K or 50K.
The All the Tables are InnoDB. And file_per_table is off.
...
3
votes
2answers
3k views
What to use, CASCADE DELETE rule or ON DELETE trigger for one to many constraint?
I would like to ask about how to handle this relationship. For better view I've tried to simplify and convert my situation into how I think StackOverflow question voting has (sorry if not :-)
I ...
2
votes
3answers
591 views
InnoDB UPDATE slow need a better option
I'm using MySQL 5.5 with a table in InnoDB running:
deleteme tinyint NOT NULL DEFAULT 0;`
UPDATE `import` SET `deleteme` = 1; -- Set the delete field
LOAD DATA LOW_PRIORITY LOCAL INFILE ...
2
votes
1answer
1k views
How to grant access for multiple tables to a user in MySQL DB?
I have mysql db named "greats" with four tables as below
+---------------------+
| Tables_in_greatstat |
+---------------------+
| log |
| sitedet1 |
| siteindex ...
1
vote
1answer
235 views
InnoDB - How to get top locked tables and rows which are locked
I was searching for a tool OR query which can give me top locked tables and which particular row is locked, Is it possible to get ?
6
votes
1answer
204 views
Why does Oracle keep working on MySQL 5.1
2 years ago the first version of Mysql 5.5 was released. What is the reason to continue working on MySQL 5.1 - the current release is Mysql 5.1.62
It looks like there are should be fundamental ...
2
votes
1answer
750 views
What is the optimal way to select the parent and child rows on a table with a self-relationship?
Sample data from the genres table:
id | genre_name | genre | parent_id
---------------------------------------------
2 | Blues | MAIN | NULL
6 | Folk | MAIN ...
9
votes
3answers
11k views
Why does InnoDB store all databases in one file?
It was convenient that MyISAM used to store each table in a corresponding file. InnoDB has made advancements in many aspects, but I wonder why InnoDB stores all databases in one file (ibdata1 by ...
1
vote
3answers
172 views
getting error while starting memecached service with ndb engine
i am installed memcached library by following the steps in the internet.
now there is a binary file created in bin folder of mysql
now i exicuting the command memcached i am getting error like this ...
5
votes
2answers
174 views
Is there a reason/benefit I am not aware of for this kind setup?
I now manage a MySQL database that was designed and created by another.
I am confused about a certain setup that the original developer created..
He did not use auto increments for table IDs. ...
2
votes
4answers
1k views
Creating Archiving database for old data in MySQL
I Have a Master and Various Slave Servers.
There is a huge amount of the data on all the servers and I wish to create an Archiving system for our Data.
Scenario is :
I want that only Last one year ...
3
votes
1answer
424 views
Keeping MySQL staging database on same server updated from production
I just migrated my MySQL 5.5.20 to Amazon RDS from MySQL on EC2. The one thing I'm having difficulty with is how to keep my staging database updated from production. Before, I just ran a nightly ...
1
vote
1answer
137 views
Referring to super parent or as a separate entity?
I have this person table as super parent,
id
firstname
lastname
email
telephone
...
...
and user table as a child
id
person_id (FK)
password
username
screenname
...
...
They must be 1:1 ...
5
votes
2answers
738 views
how to enable temporal database capability in mysql.?
How to enable the temporal database compatibility in mysql database?
Is there any library or a plug-in to enable the temporal upward compatibility? I want to keep the past records whenever a current ...
2
votes
1answer
1k views
Ubuntu Multiple MySQL instances and Apparmor
I am trying to set up multiple instances of MySQL on an Ubuntu dev machine and running into AppArmor problems.
I get this error in the syslogs:
kernel: [227631.776360] type=1400 ...
3
votes
2answers
699 views
MySQL replication to slave having VPN connection to Master
I am setting up an environment in which the Master and Slave are on different networks at different physical locations (both run on MySQL 5.5.20). I have set up a VPN connection from slave's network ...
1
vote
1answer
235 views
Does replication with SSL encryption work on MySQL 5.5?
I am trying to set up replication with slave on Amazon EC2 and master in our local environment. The setup went fine without SSL encryption. But when I set up the replication to be SSL encrypted, it is ...
0
votes
1answer
150 views
Which is the best tool to monitor replication on MySQL 5.5.20?
I have just installed and setup replication for 3 MySQL 5.5.20 server( 1 Master/ 2 slaves). I intend to add more slaves to the equation.
Which is the best software tool to monitor the replication ...
4
votes
1answer
346 views
will replication from 5.5.20 to 5.0.XX server work?
I gave two machines which run on two entire different versions of MySQL server. I want to do the replication from 5.5.20 to 5.0 server. Will that be possible?
Because I remember when I transferred ...
2
votes
1answer
179 views
Innodb mutex locking ?!? Inserts start stacking after 18-24hours, restart required
We have a fairly high end box running mysqld 5.5.20.
The cpu configuration is dual quad core xeons.
It has 32 gb ram.
It has a quad intel ssd configuration running raid 0+1.
On a fairly busy ...
3
votes
1answer
3k views
How to setup replication(Master/slave) in MySQL 5.5.20?
I have two servers both running on MySQL 5.5.20 and I want to setup replication, so every update/insert on Master would reflect immediately on Slave machine.
I tried following this tutorial (I used ...
1
vote
3answers
475 views
“Too many connections” when running MySQLDump
MySQL 5.5.x on Windows, 4GB RAM.
I have a Wordpress Multi-Site install. The WPMU db contains over 6k tables (I know, horrendous... WPMU is not my favorite app right now)
I am running mysqldump ...
1
vote
1answer
168 views
mysql event running at wrong time
I created an event to run every 24 hours and be run at 14h. Its selects some data from tabels and writes it as to a file (csv format)
The query and writing to file goes ok. The event is triggered.
...
1
vote
1answer
598 views
I am getting an error while trying to download binary for mysql 5.5.11
I am trying to upgrade MySQL 5.1 to 5.5.11 on Ubuntu 10.10. Everytime I try the wget command I get this error:
wget ...
1
vote
1answer
357 views
mysql error log issue
I have mysql server running successfully.
The error log location is as..
mysql> show variables like '%log_erro%';
+---------------+------------------------+
| Variable_name | Value ...
4
votes
2answers
8k views
Grant table privileges to a user connecting from any host
I have a user account - let's call it 'wordpress' - that I need to allow to access a few catalog tables in another e-commerce database on the same server. I've configured the user with three host ...
5
votes
2answers
1k views
Insert-heavy InnoDB table won't use all my CPU
I have a packet log database, which is almost never queried. It just needs to be fast on inserts. I'm using InnoDB because I'd like to maintain ACID compliance, since even losing a single packet could ...
0
votes
1answer
65 views
Practices to keep SQL Server databases easy to port to MySQL?
We've developing an ASP.NET Web application that is to be designed for MS SQL Server 2008. I'd like to minimize my future dB admin's headaches should there be a need to migrating over to MySQL.
With ...
1
vote
1answer
59 views
How we can enable index_condition_pushdown in MySQL..?
I have optimizer_switch variable as
mysql> show variables like 'optimizer_switch';
+------------------+-------------------------------------------------------------------------------------------+
...
1
vote
2answers
433 views
String comparison with integer is not working sometimes in MySQL 5.5
I have upgraded MySQL to version 5.5. Before upgrading when we used string comparison with integer, it was working.
Code is "value = 1", here 'value' is declared as varchar(45) and its value can be ...
2
votes
1answer
179 views
mysql emits BINLOG rows even though binlog_format=STATEMENT
We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)
According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
2
votes
2answers
2k views
“Could NOT find Curses” error when installing MySQL from source
I am installing MySQL Server from the source distribution which I downloaded from:
http://dev.mysql.com/downloads/mysql/#downloads.
I have downloaded the file (mysql-5.5.19.tar.gz).
I am using ...
3
votes
1answer
679 views
What does the base64 BINLOG statements in mysqlbinlog output mean?
I have looked over the mysqlbinlog command as a candidate for rollback method from MySQL 5.5 to MySQL 5.0.
When I ran the command on one of the bin-log files in the MySQL 5.5 server, I've noticed ...
1
vote
1answer
3k views
Is there a PPA for MySQL 5.5 for ubuntu 10.10 and 11.10?
I want to install MySQL server 5.5 on ubuntu 10.10 and 11.10 servers but have not yet found a problem free PPA or installation method as of yet. Has anyone managed to do this with the said versions of ...
2
votes
1answer
860 views
How to upgrade MySQL to a New version..?
I have installed mysql using the package management system.I am using ubuntu machine.
After that i have very well configured the server for InnoDB and other server related parameters.
I am using the ...
1
vote
2answers
299 views
Any problem will all InnoDB and one MyISAM table?
I have a MySQL 5.5 DB with all InnoDB tables. For some reason, one of the developers decided to create a MyISAM table. It is a log table for user sessions. I don't see why we should mix in a MyISAM ...
3
votes
3answers
3k views
How to Add Federated engine after installing Mysql
I have Mysql 5.5.18
and upon show engines:
show engines;
+--------------------+---------+------------------------------------------------------------+--------------+------+------------+
| Engine ...
1
vote
1answer
1k views
Sudden MySQL error: Unable to connect to any of the MySQL Hosts
I am using MySQL Community Server 5.5.18 on Windows 7. My application was running absolutely fine without any troubles but since morning it is giving strange messages while opening reports. Reports ...
3
votes
1answer
679 views
MySQL 5.5 InnoDB = OFF?
We run a server with MySQL 5.5. 95% of the tables are set to the InnoDB engine.
However whenever I look at the my.ini file (using the MySQL Workbench) under mysqld section innodb is unchecked and OFF ...
0
votes
0answers
204 views
Making chain of Master-Slave servers in mysql
I have three servers, Server X, Y (Version 5.1.54-1ubuntu4-log), and Z (version 5.5.18-2build1~ppa1~oneiric-log).
I have the main mysql DB on X (innodb DB).
now I have created Master-Slave from X to ...
1
vote
1answer
2k views
Function returning “No data - zero rows fetched, selected, or processed” in MySQL 5.5
I have upgraded MySQL version to 5.5.16
After upgrading, some of the functions are giving warning as No data - zero rows fetched, selected, or processed.
In those functions, cursors are there, but ...
1
vote
1answer
155 views
Appropriate Windows version for Mysql
I have a HP ProLiant DL380 G5 server and I would like to install mysql on it .
My questions are:
Which MySQL version should I install from this link for better performance, 32 bit or 64 bit?
Which ...
1
vote
1answer
2k views
Fixing MySQL errors recorded in error logs
Below is the extract of the most common lines of error being recorded in error logs on my PC:
110905 16:16:54 [Note] Plugin 'FEDERATED' is disabled.
110905 16:16:54 InnoDB: The InnoDB memory heap is ...
1
vote
3answers
1k views
MySQL: Trying to update to 5.5
I've followed this instructions, but after mysqld --skip-grant-tables --user=mysql, I'm getting this:
110913 20:29:18 [Warning] Can't create test file /var/lib/mysql/my-laptop.lower-test
110913 ...
1
vote
2answers
711 views
Why a copy of my.ini of other MySQL installation not working on my PC
I have two MySQL installations on two different PCs not connected to each other. I made some changes in the my.ini file of PC 1 and tried using this file on PC 2, but MySQL service fails to start. Why ...
