MYSQL :: MySQL Takes FOREVER To Start Back Up

ORDER BY Takes Forever
I'm having problems with ORDER BY.
When I run a select targeting just one of my tables, it runs quickly and nicely.

When doing the following:

select * from rubbet, kommun where ortnamn like '%Johannes%' and rubbet.harad=kommun.harad and rubbet.socken=kommun.socken order by rubbet.ortnamn;

it screws up bad. The query takes about 2 minutes to run before showing the result: "74 rows fetched in 0.0032s (112.5129s)"

obviously the query takes no longer than 0.0032s but the ORDER BY clause makes it take forever to bring back the result.

without the order by the whole thing runs very smoothly.

View Replies !

Subquery Takes Forever
I have two problems where I'm trying to retrieve data using a query.

Part 1:

I am doing a simple sub query which is on a two data sets with no more than 3000 rows in total. The query is taking 28 seconds to execute? Why I don't have a clue?

Quote:

'Select Title FROM products
WHERE Product_ID IN
(SELECT Product_ID FROM order_items WHERE Order_ID="'.$id.'")'

Part 2:

When I have solved the above I'm looking to do a join, but don't know how to approach it ? Basically I'm trying to get a complete data set for a product/order like the following:

SELECT * (which includes product_id) from items
AND SELECT Title from products where product_id =(the product_id is retrieved from items); // using a join

View Replies !

Delete All Records In A Table Takes Forever -- Anyone Know Why?
I have a table called table_a that has 1 record in it. I delete that record, which because of foreign keys (the tables are type InnoDB) will cause the records in 8 other tables to be deleted.

The 8 other tables have a maximum of 200,000 records in them. 2 of them have that many while the remaining have < 5,000 records.

Currently, deleting that 1 record has taken hours upon hours with no end in site. Does anyone know why in the world this would take so long? Is there any way to speed it up (maybe a config setting I am missing or something)?

View Replies !

Can I Start AUTO_INCREMENT Back To Fill In Unused Numbers?
I've got an InnoDB table of people who are identified by a PersonID (primary key), and it's passing 50,000 and growing quickly. My users have deleted thousands of records in the past, so there are thousands of unused PersonID number's that can be used that are less than 50,000, where it is now.

Can I set the AUTO_INCREMENT back to, say, 1 and have it fill in the empty numbers? Is that even possible? Will it just look for the next available, unique number and use it?

View Replies !

UNIONS Take Forever To Run
I have a union query that takes an age to run: .....

View Replies !

MYSQL Database Alteration, Repair And Restore Takes Huge Time
I am trying to run alteration queries on one of my mysql tables which has more then 22,00,0000 lakh records. Its been 23 hours and the process is still running (I have to close all the sites running on server due to same).

My server specifications:
Red Hat 9.0
Pentium 4 3.0 GHz
2 GB Ram, Burst RAM 5 GB
Running webserver, mail server as well.

Is there a way I can view the minute process details, as what table record is being updated ?

View Replies !

Lost Connection To MySQL Server During Query After Script Takes 60 Secs
I get the error "Lost connection to MySQL server during query" at the mysql_select_db when reaching this part of the code after 60 seconds of script execuation has already passed. Works fine if the script execution time when reaching this is under 60. Tested with Sleep() and I'm 100% sure that the 60 second barrier is causing it. I just don't know what the barrier is.////

View Replies !

Mysql Back-up
We have an online catalogue running off a mysql database, which we can back
up. When we back it up, it creates a file online called "database.sql"
which, when opened in Notepad starts...
DROP TABLE IF EXISTS store_category;
CREATE TABLE store_category (
category text NOT NULL,....etc

View Replies !

MySQL Back End
I have an Access application which uses an Access database.
I want to replace the Access back end with a MySQL one.
Can I link the new database?
Can I do it in any other way?
I reckon I should be able to, since MySQL has an ODBC driver but just not sure how

View Replies !

Getting MySQL Back
I am getting relay-bin logs on my master server. They are all empty except
for one line that reads:

þbin

I have no slave settings in my my.cnf file. Any idea where these are coming
from and how to turn them off?

View Replies !

Mysql, Get Back Your Youth

<div align="center">
 
<a
href="http://www.herbal-medical.biz/projectx/hgh.html"><img
src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0">
</a> 
 
 
 
<A HREF="http://www.herbal-medical.biz/projectx/hgh.html">Click Here If Image Doesnt Load</A>
 
 
</div>
<CENTER>WdXfuRttYR, yJJZQwQUqY
 
 
<A HREF="http://www.herbal-medical.biz/optout.html">No More Emails Please</A> </CENTER>


View Replies !

Back Up MySQL In A PHP File
I need a script that will find all tables and all rows and all data it makes a file called back.sql with all the info in it. How do you do that. My Web host dont got PHpmyadmin or nothing.

View Replies !

Auto Back Up Of MySQL
I want to Automaticly dackup my MySQL DB, and then upload it to a FTP site so I have a off site back up.

Anyone know of any programs (open source is preffered) that would allow me to do this. I was think batch file my self in scedualed tasks but I am no too sure of what commands to use. This is on a windows 200 server too.

View Replies !

Back Up MySQL Database
Plese tell me how do i back up a perticuler mysql database? can i do it from mysql command line? can i manually copy and past? if what folder?

View Replies !

Upgrade Mysql :: Get Back Old Data
I uninstalled older version of mysql 4.025 or some ancient thing. Now I didn't back up the database, but thought i could move the data folder over. Is there any way to get back into the old data? its the password access.

View Replies !

My MySQL Back-end Works Very Slow
I have installed my MySQL Server in a Window XP platform running in a Pentium4 machine. When I access the database on the machine, it is working in a normal speed. But when I access the database from a client machine (still running in windows platform), it runs very slow.

View Replies !

Slow Performance After Falling Back To MySQL 3
Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and
reinstalled everything (it was a sinle Xeon 700). The default RH9
installation comes with MySQL 3.23.54. After the reinstallation I
found the machine was not as responsive as before. (It's not very
slow, but some lagging is noticed)

I was running Mysql-max 4.0.11 and the performance was ok, except the
slowness during the peak hours, which was regarded as normal. I would
like to know the differences between Mysql 3 and 4. Is the new version
making a significant jump in performance?

I also noticed the system eats up memory faster than before. With the
old setting the system never used up 60% of physical memory, even at
extremely high loading (30+). Now it easily used up 70% of memory.

Code:

View Replies !

Optimizing MS Access Front End -> MyODBC <- MySQL Back End
I am using an MS Access front end -> MyODBC <- MySQL back end database configuration where the data is replaced every month. After emptying the old data, I would like to optimize the MySQL tables using VBA code, prior to importing the new data. Would anyone know how to implement this in VBA code, using ADO and ODBC

View Replies !

Easiest Way To Back Up MYSQL Database To Move Over To Another Computer
I've been working through Sitepoint's Build Your Own Database Driven Website and I've decided to change which of my computer's I use as my test server. I installed Apache, PHP and MySql on the new "server" and tried to copy over my database folder, but I can't seem to get it to work in the MySql client. I looked through the documentation for information about maybe making a backup and then restoring it to the new server, but I was a little overwhelmed. Anyone have an easy suggestion to accomplish this. I'm sure it's much easier than I'm making it.

View Replies !

INSERT INTO SELECT Taking Forever But SELECT Part Is Fast?
I have the following mysql code to insert about a million rows. This takes quite a long time (over 50 min). However, when I just run the query alone without the INSERT command, the query itself only takes under 5 minutes. Is there a way I could speed up the inserting??

insert into tblc
select tbla.*
from tblb
inner join tbla
on tbla.issuer_id = tblb.issuer_id;

View Replies !

SELECT Takes 20 Seconds
I am having trouble speeding up a SELECT statement from a table with 1,764 records.
I tried myisamchk --sort-index --sort-records=1 but this did not help (is a Primary key enough?).

Things were fine at around 1200 records but went downhill after 1700. I am using MySQL 3.23.42 on HP/UX 11.11 and PHP 4.3.4. Any tips on how to speed things up?

View Replies !

Update Takes Too Long, I Need Help
here is my update SQL string:
update prices, legend set prices.legend_id=legend.id where ( (prices.id between 1 and 10006) ) and prices.a_legend=legend.description
running time: 63.97960
as you see prices has 10006 records and legend table arround 349 records
please advice how to speed up this?

View Replies !

Create Index Takes More Than 5 Hours
I'm running MYSQL on a windows xp laptop with an intel centrino 1.60 GHz Processor and 512MB RAM. I've created a table and imported 27 million rows of data.

I wanted to create an index on one char(55) field, as this field is a key against which many selects will be made.

The information in the field is not conducive to having an integer key as any queries would require an extra join to the look-up (reference) table.

Creating the index ran for more than 5 hours and finally gave up when there was no more space on the drive (creating the index apparently consumed more space (11GB) than the actual table (8GB).

I'm wondering if this is normal time and space consumption for 27 million rows.

Finally, doing an un-indexed query on this table :

SELECT * from historical where reference = 'abcd';

Takes more than 1/2 hour. Is this also a normal amount of time?

I understand that people are using MYSQL for data warehousing and major transactional applications.

View Replies !

Query Takes A Long Time
On my site I have a query that searches through 1,7 million. The php-file with the query takes a bit of time to load. Is it possible to show some sort of progress-bar during this time?

View Replies !

Results In Multiple Pages, Takes Too Much Time
I have a table of a million records and wrote a CGI-PERL script to
display the results based on the user input. The results might be
anywhere from 100 to 1000 per query and presently I am displaying them
as 25 results per page.

Problem: Each query is taking about 20-30 seconds.

My solution: I have tried to optimize the table and also index the
table. I have actually converted a MS access database to SQL database,
so it wasn't previously indexed. Both optimization and indexing doesn't
give any good results. I always get a timeout. ie. it takes longer
after indexing and optimizing.

1. I was wondering if someone has a creative solution for this. ie.
reduce the time from 20-30 seconds to atleast 10 seconds.

2. I have links of pages of results beneath the first page result. When
each of these links are clicked it takes 20-30 seconds again. Is there
a way I can reduce the time taken for the subsequent pages are reduced?
I cannot use the LIMIT option in mysql, since I have a where clause
which has to search through the whole table. I tried using views and
using limits, but it takes as much time.

View Replies !

JDBC Result Closing Takes Time
i am reading 1000 Elements from a database (500.000 all together).
The problem is reading the data takes only a few miliseconds but
closing the ResultSet takes another 22 seconds. My Hard Disk tells me
that the ResultSet is probably running to the end of my table row by
row. Is there a way to tell mysql not to do this ?

Statement tempStmnt = aConnection.createStatement();
tempStmnt = aConnection.createStatement(
java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);

tempStmnt.setFetchSize(Integer.MIN_VALUE);

Date tempStart = new Date();
ResultSet tempRs = tempStmnt.executeQuery("SELECT * FROM
ARTIKELSTAMMDATEN");
int tempXx = 0;
while (tempRs.next() && tempXx++ < aCount) {
tempRs.getString("artikelBezeichnung");
}

View Replies !

Easy SELECT With OR Takes A Very Long Time
We've got a database with about 1000000 books. A query in the table
BOOKS for the TITLE 'java' is very fast. We have a fulltext index on
the column TITLE.

However, if we want to do a exact same query and include the rule that
the book with ISBN '0131016210' always should be included - then the
query take several seconds to finish:

SELECT * FROM C_BOOK WHERE MATCH(NAME) AGAINST ('java') AND (ISBN LIKE
'0%' OR ISBN LIKE '1%') OR ISBN = '0131016210'

ISBN is the PRIMARY KEY.

Is there anything I can do about this?

View Replies !

Backup With Mysqldump Takes Hours, Database Is Not That Big
Hello, I've been having some problems making database backups. I've searched all around and I notice that to most people it only takes a few minutes to backup huge databases (1+ gb).

My database is around 350mb and it can take up to 4-5 hours to backup, which I guess it not normal at all.

My server has a dual Xenon with 4gb ram, using mysql 5.0.27-1.fc6 and php 5.1.6-3.6.fc6. I am using Fedora Core6 with Plesk.

The database is around 350mb, with around 1.1 million rows. To backup I use

mysqldump -uroot -p database > backup.sql

As I said, the above takes hours. I guess it should take minutes?

View Replies !

JDBC Result Closing Takes Ists Time
i am reading 1000 Elements from a database (500.000 all together).
The problem is reading the data takes only a few miliseconds but
closing the ResultSet takes another 22 seconds. My Hard Disk tells me
that the ResultSet is probably running to the end of my table row by
row. Is there a way to tell mysql not to do this ?

Statement tempStmnt = aConnection.createStatement();
tempStmnt = aConnection.createStatement(
java.sql.ResultSet.TYPE_FORWARD_ONLY,
java.sql.ResultSet.CONCUR_READ_ONLY);

tempStmnt.setFetchSize(Integer.MIN_VALUE);

Date tempStart = new Date();
ResultSet tempRs = tempStmnt.executeQuery("SELECT * FROM
ARTIKELSTAMMDATEN");
int tempXx = 0;
while (tempRs.next() && tempXx++ < aCount) {
tempRs.getString("artikelBezeichnung");
}

View Replies !

Can't Start MySQL, Need Help!
Im using mysql-5.0.27 for windows (i have windows xp professional). After installation i follow all the deffault setup processes.

At the checking final process it always prompts this:
· Prepare configuration (ok)
· Write configuration file (ok)
· Start service (X)
· Apply security settings (pending)

After i enter the password at: MySQL Command Line Client, the DOS window automatically closes.

View Replies !

Start MySQL 4.1.13a
When I reach the portion where I am to start the server using #/usr/local/mysql/bin/mysqld_safe –user=mysql & I get the following:
Code:

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysqld/mysqld.pid
050809 15:10:39 mysqld ended

As you can see it doesn't stay started. when I checked to see if the process was running it shows that it is not.Code:

root 8885 0.0 0.0 3676 660 pts/6 S 15:14 0:00 grep mysqld

View Replies !

Can't Start MySQL
I had it working with PHP and Apache, I could edit databases. Then I turned off my computer and now it doesn't work. I think it might have been because I deleted the file "C:Program FilesMySQLMySQL Server 5.0datamysql" and its contents accidentally. Where can I get this file back without having to re-install MySQL?

View Replies !

Start With MySQL
I am a web designer that has used Access databases for my sites for many years. I understand the issues involved with this and would like to upgrade my sites (and skills!) and start using MySQL databases instead. I have looked around for help on how to get started but can't find anything that answers the questions I have.
Do I need to install MySQL Server to have an SQL database to use? For instance, MS Access exists without a server, is there a SQL database that does the same? I am not looking to develop applications for the database itself (the website is the application), it is really only to hold information. Is there a simple (or cutdown?) SQL style database that allows concurrent connections and enhanced security that Access doesn't and doesn't necessarily have all the "bells and whistles"?

View Replies !

How To Start Mysql
is this the tool to start the mysql server? Why does the light go from green to red when I try to start it? which of those files are for starting the mysql?

http://bildr.no/view/357249

View Replies !

Cannot Start Up MySql
I have just installed mySql 5.0 on my Windows 2000 laptop. I used the installation wizard for essential installation with the detailed configuration and developer machine with the multifunctional database, decision support options, and TCP/IP networking enabled.

I then selected the standard character set and for the window options checked the included bin directory path with the service name in the window as "MySQL". So far so good. In the password section I selected no password, then in the next dialog box clicked the "Execute" button and apparently the service started.

From the console prompt I tested mySql, and apparently it had started, but when I tried to do something, it asked form my password, and I typed just RETURN, i.e. no password, and it failed.

I then stopped MySQL, but never managed to restart it again, either from the console, or from Windows, even after rebooting. When using the reconfiguration wizard, it asks me for my old password, and no matter what I type, it fails when I attempt to restart it with the message "The service could not be started. Error: 0". When I type "net start mysql", it comes back with the following messages:

The MySQL service is starting
The MySQL service could not be started.

A system error has occurred.

System error 1067 has occurred.

The process terminated unexpectedly.

Could someone please explain why I keep getting these errors.

View Replies !

MYSQL Start
I'm in the directory after I installed it on my RedHat Linux box, but when I type:
mysql -h host -u user -p I get "command not found". I substuted the machine IP for host (wrong?) and "mysql" for user.

View Replies !

CANNOT Start Mysql 5
I'm using mysql 5. When I start mysql using command prompt, I got
"ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO"

Besides having mysql, I have also installed Oracle Express Edition in my laptop. Does mysql get some conflict with orcale. How can I solve this problem?

View Replies !

Cannot Start MySQL
I have configure Apache and PHP successfully. Then I try to configure MySQL. I have install it as Windows service and run it. But when I type 'mysql' it says 'Access denied for user ODBC@localhost'.
Where exactly should I fix it?

View Replies !

Getting MySQL To Start
I installed MySQL 4.1.8 yesterday, and everything worked great. Then, when I booted up today, I tried to connect to MySQL, and it wouldn't hook up. So, when I looked around for a minute, I saw that the MySql service hadn't started yet, though it was set to automatic startup. When I tried to start it, it gav the following error:

Could not start the MySQL service on local computer
Error 1067: The process terminated unexpectedly

View Replies !

MySQL Wont Start
I've just installed MySQL on my computer yesterday and it was running good at the time. Today I boot my computer and It won't load the MySQL service. I've added the MySQL path to the environment variables but that didn't solve the problem. I've attached the .err file below.

My system is:
PHP 5,
MySQL 4.1
Apache 2
I'm conencting to my network with a wireless card if that has anything to do with it. Probaly not since its a local service?

View Replies !

MySQL Wont Start Up
Last night I was attempting to activate MySQL for one of my domains using the Ensim control panel. It gave me an error while activating, and shortly after i noticed all MySQL activity on my server was no longer working.
Using ensim to activate the MySQL service I get the following error:

Quote: Result : start for service mysql failed.
Action start for MySQL failed with error.
Failed to start service: mysql. The following error occured:

Logged in using ssh i get similar messages. When I try to login to my MySQL powered blog system I get the following error:

Quote: Got an error: Bad ObjectDriver config: Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View Replies !

Start MySQL On Server
I am having problems getting MySQl to run on my local server.
I am running an Apache server on a Windows XP computer, for development purposes only.
The server is working and I can run PHP scripts on it, but I am unable to run MySQL on it.I have downloaded version 5 with the installer. During the installation, I get an error message about being unable to open port 3306, although I have been told it should not be necessary to open the port when using MySQL on the localhost.

I have tried starting MySQL from services in the control panel, but it immediately switches itself off again.

When typing “MySQL” at the command prompt, I get the message:
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

View Replies !

Unable To Start MySQL
I'm loosing my mind here.I'm new to Linux and I'm trying to get MySQL to start on the machine. I installed MySQL by using YAST and the following is what I get:

linux-dell-8200:/home/rob.hazle # service mysql status
Checking for service MySQL: unused
linux-dell-8200:/home/rob.hazle # service mysql start
Starting service MySQL failed

View Replies !