Questions tagged [mysql-5.5]

MySQL version 5.5 - please also tag with mysql for search purposes.

227 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
0answers
2k views

MySQL: Is the read committed isolation level safe with mixed binary log format?

When using the MIXED format with the READ COMMITTED isolation level, am I safe? The docs state (http://dev.mysql.com/doc/refman/5.5/en/set-transaction.html#isolevel_read-committed) If you use READ ...
4
votes
0answers
2k views

Why is loading data into MySQL cluster taking so long?

I have a mysql-5.5.22 ndb-7.2.6 cluster 64bit running on Centos 6 with each node installed on the same Citrix Xen Server communicating via a virtual private network. Each node has 4GB of RAM, 4 vCPUs ...
3
votes
2answers
68 views

At my wits end trying to create my very 1st MySQL stored procedure

I am trying to create a stored procedure in MySQL 5.5.8. using connector 8.0.13. Once this procedure is debugged, it will have to be embedded into a c#.net application, to be created on the fly every ...
3
votes
1answer
3k views

load_file() producing null

I'm trying to read the content of /etc/passwd from mysql using the following query: select load_file("/etc/passwd"); However, I always seem to get NULL as the output. mysql> select load_file("/etc/...
3
votes
3answers
559 views

Is it normal for disk activity to disturb MySQL performance?

I'm running MySQL 5.5 on a server with two SSDs in software RAID-1 configuration. The filesystem is ext4. When any process (external to MySQL) produces a large amount of disk IO on the server, I find ...
3
votes
1answer
3k views

User variable in nested subquery not getting picked up - in complex sort of 2 tables with gaps

I have just recently learned about user variables (ie, @myvar) and am trying to create a complex sorting query that takes 2 tables where the second is missing a column which then gets filled in by a ...
3
votes
0answers
202 views

Identifying table causing runaway rollback in MySQL 5.5 (InnoDB / Windows)

I have a large database (180 GB), running under Windows, with a runaway rollback that starts running as soon as the database is started up. I have started the database with innodb_force_recovery=3 ...
3
votes
0answers
20k views

MySQL - Truncated incorrect datetime value on update statement

I have an application which produces log files. These log files include a Timestamp field in the format 2015-08-25T09:35:01 UTC. (there will be approximately 60 logs produced at 0.25 GB per day). I ...
3
votes
0answers
2k views

How do I recover from MySQL InnoDB table/index corruption?

While trying to upgrade a database (in place) I got the following error. The server starts up and everything seems to be fine, except that the table mentioned in the message is no longer accessible. ...
3
votes
0answers
1k views

Upgrading from MySQL 5.5 to 5.6 - timestamp issue?

I'm looking at upgrading my Percona Server setup from 5.5 to 5.6. Reading the upgrade docs from MySQL sounds mostly straightforward except for anything involving time/date columns. As far as I can ...
3
votes
0answers
127 views

Understanding Indexes and using them better

I've been spending some time trying to optimise our MySQL queries that we use which essentially joins one table with 2 million rows onto another which has 1-2 million. I know MySQL is able to easily ...
2
votes
0answers
44 views

Migrate Mysql to Azure Sqlserver db

I read some articles and also tried SSMA, linked server and other things, but not help. I have one client's mysql Db (later we need other too) in my local pc and have Azure DB which used for SAAS-...
2
votes
1answer
234 views

What is the cause for the error 1610

This morning, I had the following event: 200310 9:54:57 [ERROR] Slave SQL: Could not execute Update_rows event on table Call_Center_Infinit.queue_member_table; Corrupted replication event was ...
2
votes
0answers
144 views

ranking using find_in_set

Trying to use this method to get the rank position of $associateID. Everything works except FIND_IN_SET. It's not reading alias1 or alias2. Does FIND_IN_SET work with alias's? How can I get this to ...
2
votes
0answers
69 views

Redesign query/database because of high load

Need help with query or redesigning the db. Please bear with me the query will be changed to pdo ASAP. I'm not a DB admin, nor am I some MySQL wiz. I have the following tables: CREATE TABLE IF NOT ...
2
votes
0answers
670 views

"Table Data Import Wizard" option missing from drop-down menu

I have a schema with a few tables, each containing three or four columns. I'd like to import some CSV data but can't seem to find the right option. I've right-clicked on the tables expecting there to ...
2
votes
1answer
104 views

MySQL 5.5 Innodb_buffer_pool_bytes_data status variable missing

We're running a MySQL 5.5.29 server in Production. If I do: SHOW GLOBAL STATUS; I'm not getting the status variable 'Innodb_buffer_pool_bytes_data' which according to the official documentation for ...
2
votes
0answers
94 views

Signal handler on mysql connection break

I want to know if there is any signal that I can catch by which I can know that my mysql connection with the server has broken in c programming? I know I can check at query time whether my connection ...
2
votes
0answers
4k views

Speed up query with multiple EXISTS

I've split a monolithic table with hundreds of strings into a set of generic table + strings table, split by language. Here are the creates: CREATE TABLE `items` ( `item_id` int(11) unsigned NOT ...
2
votes
0answers
3k views

Location of MySQL configuration file (ie: my.cnf) not specified

Location of MySQL configuration file (ie: my.cnf) not specified How can I fixed this thing? I been trying to reinstall mysqlserver 5.5 / 5.7 and workbench countless of time. But I still not able to ...
2
votes
0answers
57 views

Find the correct entry in myqlbinlog (using Row Based Replication)

I've just started testing Row Based Replication on my MySQL 5.5. databases. I have now got the following error: Could not execute Update_rows event on table dbname.tablename; Can't find record in '...
2
votes
0answers
2k views

Using SSL produces error "protocol version mismatch"

Using MySQL Server (5.5.46-0) on Ubuntu 14.04.2 with protocol version 10. Configuring SSL and defining SSL cert files locations in My.cnf file. Have defined absolute paths for CA-cert.pem, server-...
2
votes
0answers
62 views

Database Architecture & Design

I am building a web application for project management which will be hosted on my servers. My application design is like this 1 - user register 2 - domain name will be created i.e abc.domain-...
2
votes
0answers
316 views

Update queries randomly slow on INNODB Mysql

I have been struggling with a slow update query. Have already tried using indexes and other query optimization techniques. I have been using MYSQL database with INNODB engine. The issue is that, ...
2
votes
1answer
151 views

Why does coalescing make this query quicker?

I have the following query SELECT SQL_NO_CACHE `table1`.* FROM `table1` LEFT JOIN `table2` ON table2.id = table1.table2_id WHERE (`table2`.`date_assigned` >= '2015-06-21') AND ( ...
2
votes
1answer
78 views

Tuning MySQL query from explain

I am working on a search query in MySQL. I am getting this from explain: Original screenshot These are my indexes: Table definition: Original screenshot Query: SELECT `t`.`id` AS `t0_c0`, ...
2
votes
0answers
110 views

Delete using join or using sub-query?

I need to delete rows from a table based on what is present in a temporary table. For me, both of these statements work : DELETE from main_table where `id` in (select `deletable_id` from ...
2
votes
0answers
400 views

Unsafe statement written to the binary log using statement format

In MySQL error log I am getting this warning message: [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it ...
2
votes
0answers
3k views

Server version (5.5.40-MariaDB) does not match with the version of the server (10.0.15-MariaDB) with which this program was built/distributed

I just upgrade MariaDB (Mysql) 5.5.40 to MariaDB 10.0.15 by following this step by step. I have failed to enable the mysql and also mysql_upgrade with the following errors mysql_upgrade -u root -p --...
2
votes
0answers
2k views

Lost Connection to mysql server at 'reading authorization packet', system error 0"

OK, this has been bugging me all afternoon now, I have a new MySQL Database '5.5.40-0+wheezy1-log' running on Debian Linux. It is to all extents and purposes a clean install. I have created two ...
2
votes
0answers
1k views

mysql doesnt have write access in data dir?

I am running a MySQL on my Windows 7 64 bit development machine at work and I can't seem to get around a database corruption issue. In my unit tests it is telling me that the storage engine (which is ...
2
votes
0answers
2k views

Incorrect information in .frm file after a power outage?

CentOS release 6.3 (Final) x86_64 mysql Ver 14.14 Distrib 5.5.31, for Linux (x86_64) using readline 5.1 SHOW SLAVE STATUS\G: Slave_IO_Running: Yes Slave_SQL_Running: No ...
2
votes
0answers
559 views

innobackupex: What causes Slave_open_temp_tables did not become zero after waiting 15 minutes?

As you might know, in order to assure a consistent replication state, the slave should be backup only when there are no open temporary tables: http://dev.mysql.com/doc/refman/5.5/en/replication-...
2
votes
0answers
286 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 config....
2
votes
0answers
1k views

MySQL cluster stuck in start phase 4, how to proceed?

Over the weekend our cluster we set up for evaluation had one of its data nodes lose network connectivity briefly. This was while another data node was in the middle of a restart (which had been going ...
2
votes
1answer
145 views

MySQL replication backup

How to take MySQL Master-Master and Master-Slave replication backup?. I have setup Master-Master replication with a separate slave for each master on Ubuntu. What happens if, I issue or schedule ...
2
votes
2answers
116 views

Get rows in a range of time

I have a table with two columns that stores TIME type values. This is the CREATE statement: CREATE TABLE `sdriving_turno` ( `idturno` bigint(20) NOT NULL AUTO_INCREMENT, `idempresa` int(10) ...
1
vote
0answers
16 views

Query optimalization - how create proper composite index

I have mysql 5.5 and table item have around 1-3 milions rows. CREATE TABLE `item` ( `Id_item` int(11) NOT NULL DEFAULT '0', `item_Kod` varchar(15) DEFAULT NULL, `Date1` datetime DEFAULT NULL, `...
1
vote
0answers
28 views

Pair records by grouping on foreign key

I am stuck on a question I got in a coding challenge. Essentially I have 3 tables; ratings, reviewers, and books. The ratings contain a list of book reviews from reviewers. I need to output a query ...
1
vote
2answers
195 views

GRANT permission ON database TO user not working on AWS

I'm having trouble granting a user permission on AWS. mysql> GRANT CREATE ON *.* TO 'hmrex_db'@'%'; Query OK, 0 rows affected (0.01 sec) mysql> SHOW GRANTS FOR 'hmrex_db'@'%'; +----------------...
1
vote
0answers
527 views

Multiple join with self join in MySQL and split column in row

I have four tables "Commission" , "Vendors", "Accounts" and "comsplitconfig" like commission Table commissionid vendorid accountid sales commission 1 V1 A2 ...
1
vote
1answer
1k views

Unable to downgrade MySQL from version 8 to 5.6 nor start MySQL (MySQL Error Log Included)

I run a Plesk VPS (OS: Centos 6/Linux (Final)), whereby I recently tried to upgrade the MySQL from version 5.5.55 to version 5.6. Being relatively new to this area, I strictly followed this Plesk ...
1
vote
1answer
30 views

executing single query in loop increase time every time

Am executing one query which is the same as below. Now here the problem is as limit increasing its increasing execution of time. I am adding limit using a PHP script. So anyone likes to suggest to ...
1
vote
0answers
33 views

Allocate each value, considering what would be inserted

I'm stuck in a challenge where maybe you can help me. This is what my data sets for the tables look like: entities Object Payment Invoice InvoiceItem Payoff Object has N payments Invoice has N ...
1
vote
0answers
1k views

How to transposing rows into columns in MySQL?

I have three table (student's_info,subject and marks): this is table student's_info: ---------------- |s_id | s_name | ---------------- | 1 | Ali | | 2 | Jon | --------------- This is ...
1
vote
0answers
267 views

How to design databse for storing object states in mysql?

I have multiple objects with multiple states. I want to build a timeline for each object. For example: an object might have a created, submitted, processing and success state. I would like to store ...
1
vote
0answers
2k views

MySQL: query to extract text from HTML tags of a column

I have HTML tags in a column, which are used to define multi-language content on a webserver. I need to do a query to extract several data from the database (MySQL v5.5) directly. Using stored ...
1
vote
0answers
403 views

LEFT JOIN statement is optimized on Mysql 5.5 but not 5.7, is this a bug?

The following query: EXPLAIN SELECT usr.*,act.*,cht.* FROM users AS usr LEFT JOIN active_u AS act USING (uid) LEFT JOIN chat AS cht USING(uid) ORDER BY usr.updated DESC LIMIT 0,10 shows this on ...
1
vote
0answers
62 views

MySQL won't start after 5.5 security upgrade

I have the MySQL data directory running in a non-standard location on an Ubuntu 14.04 server. Last night it received a security upgrade and now will not start. The error message is Can't find file: '...
1
vote
0answers
764 views

Detecting & Preventing Data Loss in MySQL Database (InnoDB)

Around April 2017 I noticed that my database lost records in a few columns of 2 tables, this happened inside 5 of databases my website is using. They are clones just with different data records. This ...

1
2 3 4 5