Stack Overflow
Stack Overflow

Questions tagged [mysql-5.5]

For MySQL questions specific to version 5.5.

MySQL 5.5 was released at the end of December 2009, and changed default storage to and brought various performance improvements.

While the generic tag should be used with all MySQL related questions, this tag should be used if a question is about a problem seen while running version 5.5 or if it is about features specific to this version.

244 questions
121
votes
16 answers

MySQL my.ini location

I have already seen http://dev.mysql.com/doc/refman/4.1/en/mysql-config-wizard-file-location.html how to know mysql my.cnf location and http://dev.mysql.com/doc/refman/5.1/en/option-files.html But I am still stuck with the ages old…
Sap
  • 5,197
  • 8
  • 59
  • 101
22
votes
2 answers

Any way to check if innodb_file_per_table is set in MYSQL 5.5 per table?

I want to check if innodb_file_per_table is set (i.e .ibd is created) for each database tables using MYSQL-5.5 query. Any way to do it?
Deepak Ingole
  • 14,912
  • 10
  • 47
  • 79
22
votes
11 answers

Can't start MySQL5.5 on Ubuntu 12.04 - "dpkg: dependency problems"

This appears to be a common problem on 12.04. I've tried everthing in this thread including: sudo apt-get clean sudo apt-get autoclean sudo apt-get remove --purge mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server mysql-server-5.5…
Archonic
  • 5,207
  • 5
  • 39
  • 55
17
votes
3 answers

How to bulk SELECT rows with multiple pairs in WHERE clause

Let's say I have a table, email_phone_notes that looks like this: +-----------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra…
Newtang
  • 6,414
  • 10
  • 49
  • 70
11
votes
3 answers

Is it possible to check that a particular query opens how many files in MySQL?

I have large number of open files limit in MySQL. I have set open_files_limit to 150000 but still MySQL uses almost 80% of it. Also I have low traffic and max concurrent connections around 30 and no query has more than 4 joins.
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
11
votes
2 answers

subquery returns more than 1 row

select disease_name from disease where disease_id= (select disease_id from disease_symptom where disease.disease_id=disease_symptom.disease_id AND symptom_id= (select symptom_id from symptom where…
user2066199
  • 131
  • 1
  • 1
  • 3
9
votes
4 answers

Two foreign keys, one of them not NULL: How to solve this in SQL?

I have got a table time. A time entry (1:n relationship) either belongs to a project entry or to a special_work entry. Either the project id or the special_work id must be set, neither both (exclusive or). CREATE TABLE `time` ( `id` int(20) NOT…
Blackbam
  • 17,496
  • 26
  • 97
  • 150
8
votes
1 answer

MySQL - What's utf8_general_mysql500_ci?

I just saw that MySQL 5.5 offers utf8_general_mysql500_ci as collation. What is the difference to other collations like utf8_general_ci? Should I better use utf8_general_mysql500_ci?
Aley
  • 8,540
  • 7
  • 43
  • 56
6
votes
1 answer

mysql running but cannot connect to 127.0.0.1

I have installed mysql55-server using macports. I can start the server successfully via: $ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql55-server.plist And confirm I am running the correct mysql: $ which mysql…
Carey Estes
  • 1,534
  • 2
  • 31
  • 59
5
votes
2 answers

Insert data and fill columns with rank

original data: orginal_table MID STATE CALL_TIME RECORD_RANK a 1 2020-12-18 09:00:00 1 a 2 2020-12-19 09:00:00 2 b 1 2020-12-18 09:00:02 1 c 1 2020-12-18 09:00:03 1 c 1 2020-12-19 09:00:03…
Jack
  • 1,724
  • 4
  • 18
  • 33
5
votes
2 answers

@NotNull annotation does not translate to not null constraint in schema generation

According to hibernate validator reference documentation - Section 11.1.1. Database schema-level validation (https://docs.jboss.org/hibernate/stable/validator/reference/en-US/html_single/#validator-checkconstraints-db), Out of the box, Hibernate…
Praveen Fernando
  • 319
  • 3
  • 13
5
votes
2 answers

How to automatically call a query for every new connection in MySQL?

Is it possible to set or initialize a query in MySQL for every new connection ? Whenever a connection is created, it will call a procedure or a select query automatically ? Any script or config option for this?
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
5
votes
3 answers

How do I do a bulk mysql insert without incrementing the auto_increment column for duplicates?

Here's my database schema +------------------+------------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra …
Newtang
  • 6,414
  • 10
  • 49
  • 70
4
votes
1 answer

MySQL high lock_time on UPDATE query leads to server freeze

This is killing me. Please help me. My production server freeze once a week. There were queries that lock rows, and block other queries, consuming 100% CPU all the time. I need to manually kill those frozen queries before the server coming back…
Jessica
  • 81
  • 5
4
votes
1 answer

Restoring schema backup from MySQL 5.6 to 5.5

I have been developing an application using MySQL 5.6, now I have to install it on a production server which uses MySQL 5.5. The problem is the backup generated via mysqldump seems to not be backwards compatible. As I cannot change the MySQL version…
DenJohX
  • 306
  • 1
  • 13
1
2 3
…
16 17