MySQL 5.5 brought many performance enhancements and expanded the feature set of the popular open-source RDBMS.
0
votes
0answers
18 views
Should store procedures be cached?
Should store procedures be cached in MySQL? If so, How long it is stay in cache?
In my case, When I call one stored procedure first time, it is giving me results in 1 second, after that it gives me ...
0
votes
0answers
34 views
Select query very slow [duplicate]
I have a query which is take less then 0.15ms to execute on mysql on local box. Same query takes 0.348 to 0.468ms to execute on RDS medium instance. Both has same table schema, indexes. Infect on my ...
0
votes
0answers
30 views
MM Replication and Zabbix in slave, Error code 1032
I have multi-master replication and using Zabbix for server monitoring. Since the replication is row based, I get this error in slave everytime which also breaks my replication. The error I get is:
...
0
votes
2answers
45 views
Unable to drop the table since its showing waiting for meta data lock
We are trying to drop one table but it's getting hanged, and when we see the 'SHOW PROCESSLIST' command it's showing as 'waiting for meta data lock'. Even we are unable to perform any operation on ...
0
votes
0answers
28 views
MySQL replication is not happening when piping sql into mysql client
Today I noticed a very strange issue where if I cat a SQL file and then pipe it to MySQL client, replication doesn't happen. These MySQL statements aren't also written to the binlog. But replication ...
0
votes
1answer
43 views
Database migration, how to
I have two databases DB1 and DB2. In both databases exists this two tables mo_sms and mt_sms. This is the structure of those tables:
CREATE TABLE IF NOT EXISTS `mo_sms` (
`id_MO` int(11) unsigned ...
0
votes
0answers
21 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
0
votes
2answers
61 views
Steps to upgrade MySQL from version 5.0 to version 5.5
I have been developing under MySQL v5.0 for a while now and need to upgrade to v5.5 to be in step with the hosted production server.
After having searched for precise steps to do this migration, I am ...
0
votes
0answers
24 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
18 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
20 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
0
votes
0answers
46 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
1answer
28 views
Reinsert data in new table with new IDs
I have the following two tables:
buynsell
CREATE TABLE `buynsell` (
`id` VARCHAR(20) NULL DEFAULT NULL,
`msg` VARCHAR(255) NULL DEFAULT NULL,
`date` VARCHAR(25) NULL DEFAULT NULL,
...
0
votes
1answer
61 views
MySQL inserts/deletes slowing down after a while after Start/Reboot
The Setup here is:
OS: Ubuntu 12.04 (1 Core and 1.75 GB of RAMO)
MySQL Version: 5.5
There are about 8 to 9 tables in the database. On initially starting mysql the queries are fast at around 0.05 - ...
0
votes
1answer
37 views
Strange characters in mysqlbinlog output
Has anyone experienced this? Data replicates fine but when output in mysqlbinlog there are hidden characters that break the input?
mysqlbinlog Ver 3.3 for Linux at x86_64
mysql 5.5.28 server
...
0
votes
0answers
26 views
mysqlbinlog (mysql5.5) output errors out (char length)
wondering why an invalid insert (exceeds char length varchar(100)) breaks when piping mysqlbinlog output to RDS-- when pasted into a client and run separately-- it inserts, truncates, and warns ...
0
votes
0answers
422 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
1answer
59 views
Breaking Semisynchronous Replication in MySQL 5.5
I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7.
My application is running and updating the database of the master server and same is being updated in the ...
0
votes
1answer
16 views
Why isn't my includeThreadNamesAsStatementComment JDBC parameter working?
The JDBC API lists a includeThreadNamesAsStatementComment parameter that seems to indicate it will prefix all queries with the Java thread ID. I thought this would be useful in tying back DB activity ...
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
54 views
How to properly kill MySQL? [duplicate]
I have CentOS 64bit with CPanel installed and I use
service mysql stop
However, it keeps doing ..... for minutes and it never stops. It used to be instant. Any idea why it does that and how to fix? ...
0
votes
1answer
149 views
Error 1044 Access denied to user
This is driving me crazy.
When I try to create a few tables from my Workbench model I get this error 1044.
I've been trying to find a solution but nothing works for me.
Curiously when I run ...
0
votes
2answers
207 views
How to restore mysql dump file? [closed]
We have created a dump file (.sql) using the command mysqldump in mysql5.5.
Now we want to restore the same. We are using the command :-
-u[username] -p[pwd] [dbname] < [.sql file]
But we are not ...
0
votes
0answers
65 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
17 views
How to get details of changes in point in time recovery using mysqlbinlog
I have written a shell script for point in time recovery using binary logs( Point-in-Time Recovery Using Event Times). I'm using the start time as the previous full-backup start time and end time will ...
0
votes
0answers
47 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
1answer
78 views
MySQL General log not working on Mac OS X [duplicate]
I want to log all queries to the database running on my MacBook Pro (Mac OS X 10.8.1). I created a file /etc/my.cnf with the following content:
[mysqld]
general_log=1
...
0
votes
1answer
1k views
MySQL Installation error: Unable to update security settings
I tried to configure MySQL server 5.5 on Windows and this is what I get
mysql-server-5.5-winx64:56 - Attempting to update security settings.
mysql-server-5.5-winx64:100 - Unable to update security ...
0
votes
1answer
132 views
consequences of using “innodb_flush_method = O_DIRECT” without having a battery backed write cache? or on a KVM guest?
Mysql 5.5.29 Innodb- 128GB Ram - 32 cores - Raid 10 SSD.
Our server which is a dedicated KVM guest on a 'baremetal' is hosting our heavy read-write DB server.
Everything is file-per-table. ...
0
votes
0answers
181 views
What to do to reduce first byte time after removing slow queries?
I've set long_query_time to 1 sec and found only 2 query which took 1 sec to execute at 2 different points of time since yesterday. So I don't suppose such 2 queries cause my first byte time to be 3 ...
0
votes
1answer
162 views
Unable to take backup of mysql database using Xtrabackup
I am trying to take mysql backup without any downtime but unable to take the backup using Xtrabackup .
Actual Database is almost about 40+ GB in size. I am trying to first satisfy myself. Hence, I ...
0
votes
0answers
80 views
Please help configure my Mysql for 12GB 4cores server
I use a dedicated server with 12GB memory and 4 core CPU with Ubuntu 12.04 LTS (x64). This not just a database server. MySQL appears to be restarting frequently, I think I can tune the config to ...
0
votes
0answers
108 views
how to improve performance of my query it was taking more than one hour in my environment
How can I improve performance of below query? It was running more than one hour to execute in my production environment. Query plan:
mysql> explain
SELECT transaction_detail.trans_id,
...
0
votes
1answer
66 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
0answers
141 views
Optimizing MySQL for a shared hosting setup
This is my current setup:
[mysqld]
default-storage-engine=MyISAM
local-infile=0
symbolic-links=0
max_connections = 500
max_user_connections = 25
key_buffer = 64M
myisam_sort_buffer_size = 32M
...
0
votes
0answers
157 views
Error connecting to DB
In regards to:
http://serverfault.com/questions/442218/remounting-mysql-under-a-new-mount-point
Everything is running. MySQL started but for websites they can not connect to the mysql database at ...
0
votes
0answers
138 views
MySQL import file with no column delimiter
Is there a way to use the mysqlimport command on a file that has no column delimiters?
I would like to import the ctl file used with the sqlloader for Oracle
0
votes
0answers
104 views
MySql server answer #2002 [closed]
Since this morning, phpmyadmin is giving me the error message #2002 the server doesn't answer (or the connection to local Mysql is not well configured) and a message about control-use.
I'm ...
0
votes
0answers
53 views
memc_delete called from a MySQL trigger loop fails randomly
I'm calling memc_delete from a MySQL trigger's code. The call is inside a loop. Logging the results, I see that memc_delete sometimes returns 1 (ok, memcached entry deleted) and sometimes returns 0 ...
0
votes
0answers
58 views
How to perform several operations at DB level
I need to insert 25 000 or 50 000 test rows for make some performance tests in several tables in my DB. I'm using PHP but the script takes to long to run so in shared hosting is a pain! I'm asking if ...
0
votes
0answers
256 views
Potential cause for memory leak
I have a replication setup where one of those nodes started experiences a slow but steady memory leak.
The setup is kind of like this
M---->S
|
\/
FilteringSlave
| | | |
R1 R2 R3 ...
0
votes
0answers
51 views
Partition manager utility/script?
Does anyone know of any Utilities or scripts out there for partition management. Most of our partitioning is range based and I have a set of home grown scripts to expand as needed as well as maintain ...
0
votes
0answers
137 views
I need a good mySQL 5.5 Enterprise Administration Book [closed]
Beside the one online from oracle
Anyone know any good book about this subject
I have found many of mySQL 5.5
But i need it for Enterprise Administration
Thanks for the help
0
votes
0answers
40 views
How can I make MySQL rework its foreign keys?
I somehow tricked MySQL into believing I have a foreign key that does not exist.
I had a table with both an Id column and a Number column. I wanted to merge the two, so I cleared the few tables ...
0
votes
0answers
98 views
slow response from MySql server
We just moved our database from an old server to a new one with more processing power and 4G RAM. However, for some unknown reason, the execution of our store procedures became even slower. An ...
0
votes
0answers
108 views
Does full text search allow partial world
Say I want all restaurants that contain sushi
My user search for sus, ush, and shi
Now I want mysql to efficiently find rows whose title or description (or whatever) contain sus, ush, and shi, ...
0
votes
0answers
139 views
Nearest neighbor search for 1.6 million points in myisam mysql
Say I want to find 20 closest business near me. Latter I want to see the next 20 closest, etc. Yes I have myisam. I have spatial indexes on the point. I am looking for actual command.
Note:
I am ...
0
votes
0answers
184 views
Mysql 5.5 hangs from time to time with ubuntu 12.04
I am using Mysql 5.5 from ubuntu 12.04 64 Bits with both MyIsam and Innodb engines : From time to time, when I do some 'big' requests like dropping a database, altering a table, adding an index on a ...
0
votes
0answers
153 views
Are there any caveats to install mysql 5.5 in CentOS 5?
I need to install mysql 5.5 in cent OS 5. As Cent OS 5 is a little bit old is there any odd behavior when you want to install mysql 5.5 on Cent OS 5?
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 ...
