mysql-5 : Version of MySQL Starting with MySQL 5.0
0
votes
1answer
293 views
Is there a way to skip errors in procedures and resuming procedure
When there is a unique key in a table (not PRIMARY KEY) and procedure is running, on duplicate key error the whole process will be halted. I want to resume on error and call the procedure again.
...
3
votes
1answer
233 views
why is mysql still writing data two hours after all transactions have stopped
I have a mysql server used mostly as data warehouse. It loads about 4-5GB of data per day (actual database size, not the size of the source data).
Lately, I noticed something peculiar. After I ...
2
votes
3answers
135 views
How to get all non deleted messages from one user
I have two tables one for messages called default_messages and the other for recipients called default_recipient. This is how SQL for those table looks like:
CREATE TABLE IF NOT EXISTS ...
1
vote
1answer
926 views
What does COUNT(1) actually count? [duplicate]
Possible Duplicate:
What is the difference between select count(*) and select count(any_non_null_column)?
I have heard it commonly stated that when counting the number of rows in a query, ...
3
votes
1answer
2k views
What is the use of ibdata1 file in mysql?
I have application which has the backend db as Mysql(InnoDb engine), and currently my client wants to decrease the size of the ibdata file to some fixed size. I found the three below solutions.
...
2
votes
1answer
81 views
MySQL : Does 'bytes_sent' and 'bytes_received' include mysqldump data?
I'm trying to estimate my db traffic not including backups (mysql 5.1.41).
I use show global status; to get the parameters bytes_sent and bytes_received.
Questions
Do these numbers include ...
2
votes
1answer
110 views
How does MySQL coerce types during joins?
Why do these two queries behave differently:
mysql> explain select FOOBAAR_hhs.relationship_group from FOOBAAR_hhs left join FOOBAAR on FOOBAAR_hhs.relationship_group = FOOBAAR.relationship_group ...
1
vote
0answers
724 views
My SQL 5.6.4 DATETIME column milliseconds is not getting stored
Beginning from MySQL 5.6.4, milliseconds support is provided for date columns like DATETIME etc.
I just created a table to check if its working:
create table testdata(startime DATETIME(5));
...
2
votes
1answer
239 views
Correcting the imported latin1 data to be utf8
I restored my drupal site database from a backup but after i finished i discovered that the Imported data was symbols like this قوانين كرة because the backup was taken using latin1 charset ...
1
vote
2answers
254 views
why can I only install MySQL 5.1 on cent OS 6.2?
I had Ubuntu 10.10 on my server and MySQL 5.1 version. But since i wanted to update the system, I installed a fresh version of Cent OS 6 only so I could install the latest version of MySQL. But after ...
2
votes
1answer
3k views
MySQL case sensitive table names on Linux
Moving a MySQL database from Windows to Linux I have the problem that on Linux the names of the tables are case sensitive. This is a problem, because the Java application that I am developing can't ...
1
vote
0answers
312 views
mysql pre-start process (23901) terminated with status 1
I installed a new Mysql server version 5.1 on machine which was running on 5.0. Now when I try to start the mysql server using command service mysql start it gives me an error start: Job failed to ...
2
votes
1answer
1k views
How to grant access for multiple tables to a user in MySQL DB?
I have mysql db named "greats" with four tables as below
+---------------------+
| Tables_in_greatstat |
+---------------------+
| log |
| sitedet1 |
| siteindex ...
1
vote
0answers
196 views
why is MySQL 5.1 on ubuntu 10.10 not starting? [closed]
I just installed a MySQL 5.1 server on Ubuntu machine. after installation the server should automatically start but it does not start and gives me an error start: Job failed to start
. Even when I ...
-4
votes
2answers
279 views
SQL Server equivalent to MySQL UNIQUE index?
In MySQL (5.1) I am able to create a Index on a field that is type UNIQUE. This ensures that the field contains only unique items.
Is there something equivalent to that feature in SQL Server 2008?
...
2
votes
1answer
413 views
Are many NULL columns harmful in mysql InnoDB?
As I explored the clustered B-tree index system of InnoDB, I think that the presence of many NULL (or small) columns has no significant effect on InnoDB performance.
Does the presence of excess ...
1
vote
3answers
172 views
getting error while starting memecached service with ndb engine
i am installed memcached library by following the steps in the internet.
now there is a binary file created in bin folder of mysql
now i exicuting the command memcached i am getting error like this ...
2
votes
1answer
418 views
PostgreSQL versus MySQL for EAV structures storage
Is there any practical difference or what are the advantages of using Postgres 9.x versus MySQL 5.x for storing EAV (Entity-Attribute-Value) structures, especially in terms of read performance?
1
vote
1answer
520 views
MySQL UPDATE to replace text in LONGTEXT field
I have a WordPress table wp_posts and I'd like to run an UPDATE that will replace a url from my old domain to my new domain.
For example, let's say that one record in the field post_content has the ...
3
votes
2answers
331 views
Read mysql config (my.cnf) using mysql console
I have a mysql server that is not under my control (I don't have ssh on that machine). I only have access to one database using mysql client.
How can I have access to config options that are declared ...
3
votes
2answers
1k views
Performance settings for MyISAM tables - keep everything in memory
I have a 8-core MySQL server with 32 GB of RAM, holding 40 MyISAM tables (total: ~4GB of data).
Since the databases size is several times smaller than the available memory, how can I make full usage ...
3
votes
1answer
424 views
Keeping MySQL staging database on same server updated from production
I just migrated my MySQL 5.5.20 to Amazon RDS from MySQL on EC2. The one thing I'm having difficulty with is how to keep my staging database updated from production. Before, I just ran a nightly ...
2
votes
1answer
122 views
how do I limit the characters in selected row and con-cat with '…'
I have a query which return a column named comment. I want to limit the number of characters returned by select statement to 50 and if the comment row contain more than 50 characters, I want to append ...
1
vote
1answer
203 views
Installing Sphinx on Mac OS with XAMPP
We have:
Sphinx 2.0.3
Mac OS 10.6.8
XAMPP 1.7.3 (with MySQL 5.1.44)
Here is PATH:
user:sphinx-2.0.3-release user$ echo $PATH
...
3
votes
1answer
502 views
how to import mysql database structure?
I have a database on Machine A. What I want is to dump my database in such a way that when I import it on another machine (Machine B) only the structure of the tables and Database are created.
I want ...
1
vote
2answers
2k views
How do you install MySQL 5.1.34 on CentOS 5.5?
I am trying to install Mysql 5.1 on cent OS. I researched a lot but could not find any link which gives step by step procedure. Everywhere, there are vague answers. Can someone please give me steps ...
1
vote
1answer
168 views
Can I use the “import” tool on PHPMyAdmin multiple times?
I am moving databases between a couple of shared hosting accounts, and both of them only give access to the MySQL databases through phpmyadmin.
The importing account's upload limit is 50MB. I would ...
3
votes
2answers
694 views
MySQL replication to slave having VPN connection to Master
I am setting up an environment in which the Master and Slave are on different networks at different physical locations (both run on MySQL 5.5.20). I have set up a VPN connection from slave's network ...
1
vote
1answer
775 views
How to update mysql my.cnf without getting error?
I updated the MySQL my.conf file and and restarted my server without a problem.
As soon as I tried to access a table I received the error
mysql #1033 - Incorrect information in file:
I reverted ...
4
votes
1answer
341 views
will replication from 5.5.20 to 5.0.XX server work?
I gave two machines which run on two entire different versions of MySQL server. I want to do the replication from 5.5.20 to 5.0 server. Will that be possible?
Because I remember when I transferred ...
2
votes
1answer
2k views
MySQL Workbench 5.2 edition - Unable to establish the connection
I have installed MySQL (mysql-workbench-gpl-5.2.37-win32.msi ) which is a Windows Installation Workbench.
Couple of times, I have done re-installation on my computer. Now, I am not able to establish ...
2
votes
1answer
878 views
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I tried restarting the Mysql server but its not working for me. I am sure the server is running and the permissions on the folder /var/lib/mysql/ are correct (777).
When i tried to open the file ...
0
votes
0answers
84 views
mySql stopped working [closed]
I am developing an application in python and using mySql for storing data. It was running fine last time I used it. Now, I didnt make any change in code. When I am running application, an error is ...
1
vote
1answer
59 views
How we can enable index_condition_pushdown in MySQL..?
I have optimizer_switch variable as
mysql> show variables like 'optimizer_switch';
+------------------+-------------------------------------------------------------------------------------------+
...
2
votes
1answer
725 views
Why is mysql logging to syslog?
I have installed Multiple MySQL instances and i have two configuration files one for each one is using default location of /etc/mysql/my.cnf.
other server i have started like
...
4
votes
1answer
535 views
Is there a way to find my.cnf in shared hosting?
I'm curious is there a way to find my.cnf in shared hosting or is this file can be configured just by DBAs and no one can set his/her own settings?
7
votes
4answers
466 views
Is splitting a 'users' table for authentication purposes a good idea?
Suppose I have a user table in my site in which there are around 2-3 Million users (records) in the table.
For speeding up my login process, is it a good approach to split my user table, one for ...
1
vote
1answer
664 views
Duplicate entry in mysql
I have a mysql master-slave replication setup. when I checked "show slave status", I got the result as "Slave_Sql_running:No" and Last error as "Duplicate entry 'x' on query."
But when I tried to ...
3
votes
1answer
36 views
Is time to deliver data included in time measured for a Slow Query
I'm looking at some horrible numbers in a SLOW_QUERY_LOG (one example)
Count: 2563 Time=23.21s (59498s) Lock=0.00s (1s) Rows=21.4 (54857)
This is for a simple SELECT statement that runs for less ...
3
votes
1answer
105 views
count(id) on Char(0) column does not work! [duplicate]
Possible Duplicate:
What is the difference between select count(*) and select count(any_non_null_column)?
I have a column with the type of char(0).
some of the rows are NULL and some of ...
2
votes
1answer
360 views
Do I have duplicate key indexes?
CREATE TABLE relations (
object_id BIGINT(20) NOT NULL PRIMARY KEY,
object_term BIGINT(20) NOT NULL,
UNIQUE KEY link(object_id, object_term),
CONSTRAINT fk_term FOREIGN KEY(object_term)
...
1
vote
1answer
79 views
mysql server password change while restoring
I restored all database backup from another server's dumpfile to my machine. At the end my mysql server's password changed to that mysql server's password. Why it got overwritten? What i need to do to ...
3
votes
1answer
578 views
Master and Slave having same id's
I am working as a remote DBA for some of the production servers.
There was replication from Master to Slave.
There is something changed in the scenario they have made one of the Slaves as master ...
3
votes
3answers
4k views
Restore mysql database with different name
Hello Experts,
How can we restore mysql database with different name from mysqldump file.
I dont't want to open dump file and edit it. Any other better methods.?
regards,
Praveen
1
vote
2answers
152 views
Two master databases for two separate apps
We have two different websites one is hosted in asia datacenter called it asiadata.com and other site is hosted in europe datacenter called it europedata.com. Currently we have only one master ...
5
votes
2answers
6k views
What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
I am very new to Database Administration.
I face a lot of problems while setting up mysql master-slave replication.
I also face regular mysql replication troubleshooting issues.
Can anybody helps ...
1
vote
1answer
782 views
mysql db backup excluding specific tables
Are there any mysql scripts for taking a database backup, while excluding specified tables?
Also, what is the best way to take backup of a running mysql system?
Regards,
Praveen
1
vote
1answer
1k views
ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
There is a SAN mounted 1TB partition for Mysql backups in our server with version 5.0.45-log. From two days, im seeing the log entries ERROR 1114 (HY000) at line 6308 in file & The table ...
3
votes
1answer
156 views
How can I get MySQL to use the value returned by a function as a default?
I have a pre-existing table that has a column to that can hold a UUID.
I'd like to be able to define a default such that new rows coming in (from legacy systems) will still get a UUID defined, via ...
2
votes
1answer
286 views
Can I choose which CPUs / Cores to be used by MySQL?
I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example).
With ASP.NET, in such situation, I usually set the app ...
