MySQL 5.5 brought many performance enhancements and expanded the feature set of the popular open-source RDBMS.
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
29 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 ...
5
votes
0answers
214 views
Migrating MySQL to new server
We have a MySQL 5.1 instance running on Windows Server 2008 R2 x64 (Server A) replicated to another MySQL 5.1 instance on Windows Server 2003 R2 (Server B).
We have a new MySQL 5.5 instance on ...
1
vote
1answer
50 views
MySQL replication — issue with mysql.proc during replication from 5.0 to 5.5 host
We are replicating from a mysql 5.0.45 host to a 5.5.26 host over WAN. Every once in a while one of our databases does not accept a query and halts the replication.
"'Column count of mysql.proc is ...
0
votes
1answer
41 views
Misunderstanding statement in MySQL documentation
I can't understand this statement in Optimizing Data Size:
Declare columns with identical information in different tables with
identical data types, to speed up joins based on the corresponding
...
0
votes
1answer
81 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
2answers
63 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
23 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
1answer
82 views
Amazon RDS MySQL performance issues
I have published my website on Amazon EC2 (Singapore region) and I have used MySQL RDS instance for the data storage. Everything is working very fine except performance.
It seems that all queries, ...
0
votes
1answer
37 views
Redo Logs Mysql Cluster
The mysql cluster has 4 directories namely D8 D9 D10 D11 for redo logfiles.
But while inserting into table only one redo directory is used.
I ran following command to get redo information "all dump ...
2
votes
3answers
4k views
mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
I am following this solution here http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#comment14041132_4056261 and tried to increase my innodb_buffer_pool_size ...
0
votes
2answers
52 views
Error log - What does this mean and what can I do about it?
I have the following repeated errors in my error.log and I don't know what it means or what I should/can do about it:
Access denied for user 'root'@'[some IP]' (using password: YES)
There are ...
3
votes
1answer
97 views
MySQL Stress testing issues?
I had gone through MySQL High Performance book Chapter 2 for MySQL Bench marking and Profiling,I have some questions about benchmarking
How can we test an existing database and queries against it ...
1
vote
1answer
347 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 ...
1
vote
0answers
23 views
Error in alter table reorganize partition for MySQL Cluster
My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition.
Some parameters of ...
0
votes
1answer
294 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
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 ...
1
vote
1answer
44 views
Changing TEXT to VARCHAR
In a MySQL database (InnoDB) we have a table containing roughly 60.000.000 rows. One of the columns is of type text.
Currently the longest entry has length 360 (found using SELECT MAX(LENGTH(value)) ...
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
2answers
80 views
Should I disable triggers, timestamps in a slave in mysql?
We're using MySQL. We have a master that eventually will have 2 slaves. There are triggers in the db that execute when data changes in certain tables. I am wondering whether to disable the triggers in ...
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
42 views
Limit Access To mysql information_schema
In case of mysql attacks, many times user extracts information from information_schema.
can i do something in mysql that can restricts user to xtracts information from information_schema while all ...
1
vote
1answer
55 views
Data usage increases initially when reorganize partition mysql cluster
In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes.
But before ...
-3
votes
1answer
43 views
How to create Mysql Replication on mysql 5.5 master-slave [duplicate]
Guyz please tell me how to replicate master-slave in mysql 5.5
0
votes
1answer
62 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
2answers
85 views
How do I fix the definer problem The user specified as a definer ('fred'@'192.168.0.%') does not exist
I dumped an existing database from my web site into a new MySQL setup on my laptop. Everything works except pages that use a view, when the error message above appears. There is only one view on the ...
0
votes
1answer
29 views
MySQL not allowing text columns?
I'm using MySQL 5.5.27. I currently have a BLOB column, that I want to convert to text to allow fulltext searching. The ALTER TABLE command to create a text column is successful, but the ALTER TABLE ...
0
votes
1answer
60 views
MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
I am observing this lag in a continuous manner. Investigating in the bin log events, i found
the following information. Slave executing the relay Logs slowly.
1. Changing the Innodb File Format ...
3
votes
1answer
92 views
How this simple Stored Procedure ended up in Deadlock
Thanks for all and this forum is really helpful.
After few minutes of system running we get “Try restarting the transaction.”
And its end up in deadlock.
We use MySQL 5.5.28 and the Java code ...
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 ...
1
vote
1answer
77 views
Unique index on 2 columns in mysql
I have one table in mysql named 'UserFriends' where I am updating my websites user's friends details.
here is the schema of the table (UserFriends)
id int,
Userid int,
friendid int,
createdate ...
1
vote
2answers
62 views
Tinyint structure is confusing
I am confused to see this tinyint(3) structure. If tinyint can store only 1 byte then what is the purpose of giving the size in brackets? Is there something special with this parameter in MySQL?
3
votes
4answers
250 views
Stress Test to Saturate Memory for MySQL InnoDB
I'm investigating windows 32bit memory problems (the 2G limit) and am after a test which will max out MySQL's memory including InnoDB Buffer Pool, per connection memory and/or any other uses of ...
1
vote
2answers
76 views
Database and query optimizacion
I have a database containing three tables: tbl_database (main table is the primary), tbl_cmdatabase and tbl_blacklist. The three tables share the same structure but differ in the number of records ...
0
votes
1answer
149 views
How to get only month from MySQL date/time?
In my MySQL server, I have rows that have the date of my created content. Example: 2013-03-17 02:53:47
For now, I am using:
$date = $fetch[thedaterownamegoeshere];
<?php echo $date; ?>
But ...
0
votes
0answers
27 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 ...
3
votes
2answers
656 views
Is my.cnf for mysql 5.5 is suitable and well tuned for below hardware spec?
My Hardware Spec
Technology: Ivy Bridge
CPU: Intel Xeon E3 1245v2
Intel Smart Cache: 8MB
Cores / Threads: 4 / 8
Frequency: 3.4GHz+ / 3.8GHz Turbo Boost
RAM: 32 GB DDR3
Hard disk: 2x 2TB SATA3
Raid 1 ...
1
vote
5answers
276 views
How to properly kill MySQL?
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
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
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
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
2answers
212 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 ...
1
vote
1answer
82 views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
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
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
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
2answers
419 views
What is the difference between optimize table and analyze table in mysql
What is the difference between optimize table and analyze table in mysql? I have read the online docs, but not sure what the difference is.
