Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [mysql-5.5]

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

MySQL 5.5 brought many performance enhancements and expanded the feature set of the popular open-source RDBMS.

http://dev.mysql.com/doc/refman/5.5/en/

1184 questions
7
votes
3 answers

Mysql error "#1030 - Got error -1 from storage engine" when doing insert/update queries

I am starting to learn manipulating some long list of data from datalogs in mysql, around 300k entries, and it is being added by about 1k off entries everyday, it was working fine in a week then suddently I'm not able to write in the db. Here are…
Carl Alberto
  • 175
  • 1
  • 1
  • 7
3
votes
2 answers

Adding a primary key to an existing table in mysql is taking time

22 hours ago I started a script that executes an alter table to add a primary key to a table which has 225 millions of records. MSISDN is the only column. In showproceslist its process status is "copy to tmp table". Can anyone tell me if this is the…
sohan singh
  • 31
  • 2
3
votes
1 answer

where varcharcol = 0 returns all rows

Suppose I have a table like this: create table mytable(cola int primary key, colb varchar(10)); Let's put some data in it: insert into mytable values(1, 'abc'); insert into mytable values(2, 'def'); When I select using this query: select * from…
Endy Tjahjono
  • 381
  • 4
  • 17
3
votes
1 answer

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 | NULL 10 | Pop | MAIN |…
b01
  • 133
  • 1
  • 6
2
votes
1 answer

Unknown column error with an index

I created a simple index associated with a timestamp column CREATE TABLE `data` ( `id` INT(11) UNSIGNED NOT NULL, `ticker` VARCHAR(16) NOT NULL COLLATE 'utf8_unicode_ci', `comment` TEXT NOT NULL COLLATE 'utf8_unicode_ci', `link`…
rodling
  • 145
  • 1
  • 1
  • 8
2
votes
2 answers

need help in Query optimization

I need help in query optimization,I am having table with structure Create Table: CREATE TABLE `ip_country_mapping` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `cron` bigint(20) NOT NULL, `start_ip_number` bigint(20) NOT NULL, `end_ip_number`…
shaik
  • 23
  • 4
2
votes
3 answers

Where future rows don't exist

I have the following table CREATE TABLE TaskJournal ( TaskJournalId INT NOT NULL AUTO_INCREMENT, TaskId INT NOT NULL, TaskStatus TINYINT NOT NULL, TaskStart INT NOT NULL, TaskEnd INT NULL, TaskInfo TEXT, PRIMARY KEY (TaskJournalId) )…
Mark D
  • 1,110
  • 4
  • 15
  • 27
2
votes
1 answer

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 this version should be there. What am I missing…
user214259
  • 21
  • 1
2
votes
2 answers

How to get month name from week number and year

I have a week number and a year (e.g. 34 and 2015). I want to get the name of the month to which the specified week belongs. How can I do that?
Sujeet Kumar
  • 37
  • 4
2
votes
0 answers

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-cert.pem and server-key.pem files. When attempt to…
TheCodeMonkey
  • 21
  • 3
2
votes
1 answer

Mysql can't start?

Mysql can't start, here is the log : 150708 06:28:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 150708 6:28:36 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed…
user14492
  • 21
  • 1
1
vote
1 answer

Indexed varchar column efficiency

On a table with several million rows, with an index on the only column in the where clause (varchar 100, full length indexed), would there be performance gains in making sure that the differences between those rows were early in them? i.e. would it…
cant really find this anywhere
  • 11
  • 1
1
vote
1 answer

mysql database under symlinked directory: ERROR 1018 (HY000): Can't read dir of './/' (errno: 13)

I'm using mysql 5.5 on an ubuntu linux server. I need to move a database from its current location (under /var/lib/mysql) to a disk with more space, so I attempted to move the directory and create a symlink to the new location. When I do this, I…
Gus
  • 133
  • 6
1
vote
1 answer

Simple Query optimization using ORDER BY

The following is a simple query that is taking more than 10 seconds to execute: select * from inventory.asset ass where ass.product_id=83 and ass.expiry_date > now() and ass.status=1 order by ass.expiry_date ASC, ass.serial_number ASC limit 10…
jiten
  • 13
  • 3
1
vote
1 answer

addition in datetime column during insertion in mysql

i have a table with below 5 columns..timestamp is data type for timedate related column : Region event_time start_time mid_time end_time India 2013-11-03 13:00:00 America Holland Switzerland I have source from where…
simplifiedDB
  • 669
  • 6
  • 17
  • 36
1
2 3 4