Questions tagged [mysql-5]
Generic MySQL version 5 tag. Please use a mysql-5.x tag instead. Also tag with mysql for search purposes.
178 questions
1
vote
1
answer
1k
views
MySQL: How do I limit or prevent caching for specific tables?
I'm currently working on a database schema for tables to hold user information on a website with integrated forums.
Right now my idea is to have all the data in two separate tables: one table with "...
- 113
2
votes
1
answer
4k
views
MySQL: trying to create root user
Upgrading MySQL database to 5.5 and it seems that the root user has disappeared.
I'm trying to create it again using this commands:
javier@javier-mbp:~$ sudo pkill mysqld
[sudo] password for javier: ...
- 142
2
votes
1
answer
4k
views
Host Name Resolution in mysql.db and mysql.user tables
We're seeing something peculiar about the way MySQL does name resolution -- or peculiar to us at least (-:
We have two data centers, A and B. A is primary, B is used in case of failover. We have two ...
- 1,367
2
votes
1
answer
347
views
Will mysql_secure_install script block master updates to slave?
I had setup two virtual mysql database servers in two oracle linux 6 vm's, which come with mysql server ver 5.1.47
Master named prod_master & slave named prod_slave1.
I installed both the mysql ...
1
vote
2
answers
3k
views
MySQL Community Edition: Can I replicate my entire server with another server in one go?
I need to migrate all the databases from one server to another. There are about 100 databases, and all databases are used daily and updated/inserted too and read through their respective websites.
...
- 143
2
votes
1
answer
4k
views
MySQL - How do you enter a record with only whitespace " "?
I want to enter the record with white-space as a record in MySQL. I had tried to enter it through shell and phpmyadmin, the record enters but when I try to retrieve the record it returns as null. I ...
- 169
2
votes
2
answers
7k
views
Is there any way to recover a database after dropping from phpmyadmin?
I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin ...
- 391
3
votes
2
answers
167
views
How do I configure MySQL '5.1.49-1ubuntu8' to show multibyte characters?
I am using MySQL version 5.1.49 and I have now enabled UTF8 character encoding. The default character-set for MySQL is latin1. How can I change it show UTF8 characters?
Even when I query a table ...
- 33
1
vote
1
answer
81
views
Is storing values of a unique field shared between many web forms bad practice?
I am curious if it is considered a bad practice to use a unique table to store values asigned to a unique field that is shared between several webforms.
The site with webforms will carry thousands or ...
- 143
111
votes
3
answers
172k
views
What is the default order of records for a SELECT statement in MySQL?
Suppose you have the following table and data:
create table t (
k int,
v int,
index k(k)
) engine=memory;
insert into t (k, v)
values (10, 1),
(10, 2),
(10, 3);
When ...
- 1,338
1
vote
1
answer
552
views
Is it possible to fetch or update table data by table field type?
Is it possible to fetch or update table data by field type? If possible please tell me with a sample code.
- 163
5
votes
4
answers
16k
views
How do you encrypt data while performing a mysqldump?
My OS is windows 7.
How can I encrypt data while performing a mysqldump?
From the command prompt, can I take a mysqldump with encrypted varchar and texts values?
Please help me.
Thanks
- 163
1
vote
3
answers
2k
views
MySQL: Trying to update to 5.5
I've followed this instructions, but after mysqld --skip-grant-tables --user=mysql, I'm getting this:
110913 20:29:18 [Warning] Can't create test file /var/lib/mysql/my-laptop.lower-test
110913 20:29:...
- 142
4
votes
1
answer
2k
views
Determining max database and table size supported and present size
One of my MySQL databases has been running on a single PC from the last four years.
Here is my setup:
MySQL 5.5.14
Windows XP on NTFS partition
All of my tables are using InnoDB engine
Here are two ...
- 1,425
10
votes
3
answers
6k
views
Users complain that system runs slow when mysqldump is in progress
The MYSQL database (ibdata1) is of size 73 GB and is configured to run as a dedicated database server on Windows 2008 O/S for INNODB tables.
We are running the backup using mysqldump
mysqldump --...
- 176
3
votes
1
answer
2k
views
Duplicate UNIQUE KEY error after ROLLBACK in MySQL
I have a table like this
mysql> describe seudonimos;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra ...
- 33
4
votes
2
answers
24k
views
MySQL Event does not run
i am running mysql 5.1.41 that came bundled with xampp on windows. the problem is that the event doesnt run automatically even when the event scheduler is ON. i have a table named ta_table using ...
- 185
4
votes
2
answers
4k
views
How do you copy a table from MySqlServer_A to MySqlServer_B?
I have a daily task that collects data from 3 MySql Servers and then pushes that aggregate data back out to each of the servers deleting the previous days data. All servers are MySql. I would like to ...
- 231
20
votes
3
answers
83k
views
Set "lock wait timeout" in MySQL
Where would I set the maximum time a query will wait for a lock in MySQL 5.0.68 before timing out?
- 11.2k
51
votes
6
answers
46k
views
In MySQL, does the order of the columns in a WHERE clause affect query performance?
I am having performance issues on certain database queries that have large possible result sets.
The query in question, I have three ANDs in the WHERE clause
Does the order of the clauses matter?
...
- 4,299
43
votes
1
answer
147k
views
How long is "too long" for MySQL Connections to sleep?
I logged onto my server to check the status of the database and noticed on the SHOW PROCESSLIST; that there are a large number of connections sleeping that are very old.
What duration should the ...
- 4,299
6
votes
1
answer
5k
views
MySQL INNODB SELECT query hanging on copying to tmp table
I have a query that is hanging (seemingly) randomly on a specific query. Most of my website users do not have a problem when this query runs but a few users are having timeout issues on the website ...
- 4,299
18
votes
3
answers
12k
views
Why does importing a 12 GB .sql file take more than 36 hours?
I've been waiting now for 36 hours for a 12 GB .sql file to be imported with a simple type site.sql | mysql command. I can see the ibdata1 is growing still, currently nearly 40 GB.
Considering the ...
- 365
6
votes
3
answers
16k
views
Resolving issue with mysql.proc after upgrading MySQL from 5.0.* to 5.1.*
Like many others, we upgraded our instance of MySQL from 5.0.* to 5.1.49. Since then, we've been running into an error that repeats itself when we perform certain actions:
Attempting to view or run a ...
- 163
3
votes
3
answers
1k
views
Storing a large number of small size entries in MySQL
I have a database that stores readings from numerous gauges. Depending on the gauge, there may be data for that gauge every 1-5 minutes with multiple readings (i.e.- weather station and it stores 5 ...
- 4,299
8
votes
3
answers
9k
views
Changed max_allowed_packet and still receiving 'Packet Too Large' error
I use mysqldump to create a flat file for backup purposes. I have used this file to recreate the database on an alternate server. I ran the import process through ssh on the command line and I ...
- 4,299
2
votes
1
answer
488
views
MySQL Error 10048 on nested Delphi Queries
I'm having a problem with MySQL (Server 5.1.11) interfacing with a Delphi application
The problem occurs when trying to use the application to do a bulk export to Excel. During the application ...
- 181
15
votes
3
answers
3k
views
Speeding up conversion of MyISAM to InnoDB
I've got a mysql 5.1 server with a database of approximately 450 tables, taking up 4GB . The vast majority of these tables (all but 2) are MyIsam. This has been fine for the most part (don't need ...
- 23.5k