run query second time

Hello Today I run large query. It took more than 1 minute to start printing the results. The output was about 5 rows. However, when I run the query second time it took a couple of seconds before printing the results. Why is that? Because data still in the RAM? Thanks

order by: more that one field

Have some questions about Order By: Can a mysql query be order by more than one field? If this two queries will give different result or not? #1 select * from t1 Order by id, username; #2 select * from t2 Order by id _ Choose now

maximum number of mysql connections and process

I have some general questions: #1 How many simultaneoulsy connection can mysql server handle? #2 Is there a limitation in how many processes can mysql handle? Thanks _ Keep up with high-tech trends here at Hook'd on Technology.

RE: Error creating database

Make sure that you have persmission to create database. Check MySQL manual: http://www.mysql.com/doc/en/index.html From: mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Error creating database Date: Sat, 7 Feb 2004 19:00:54 -0500 HI everyone: I am using a dual 800 MHz power mac G4 in

RE: Just simple question...

You can install MYSQL on your Windows machine and use this user interface for managing the database http://www.mysql.com/downloads/mysqlcc.html From: Dusan Spisak [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Just simple question... Date: Fri, 06 Feb 2004 16:03:23 +0100 Hello everybody! I

ERROR 1205: Lock wait timeout exceeded; Try restarting transaction

I did similar insert minutes ago with no problems. Now I try to do the same insert just with differnet parameters and got such error message. insert into users(first_name, last_name) values('john', 'smith'); ERROR 1205: Lock wait timeout exceeded; Try restarting transaction Any ideas how to fix

Create users : with password

I spend some time to figure how to add users with passwords, but have problem with following: Adding user with password: PROBLEM When I insert users to database: insert into user

Slave crashed: error 'The table 'users' is full' on query..

I have more than enough space on the box. At the beginnig I check table status and got no error messages. Any ideas what can cause such error. I use mysql 4-0.13. The documentation http://www.mysql.com/doc/en/Full_table.html refer to older version of mysql. Any ideas how to fix the problem?

Error: 1062 Duplicate Entry '252' for key 1

Hello The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? As I understand ,

Re: Error: 1062 Duplicate Entry '252' for key 1

Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252

Re: Error: 1062 Duplicate Entry '252' for key 1

| Thanks From: Jigal van Hemert [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Error: 1062 Duplicate Entry '252' for key 1 Date: Thu, 29 Jan 2004 14:32:51 +0100 From: Mike Mapsnac [EMAIL PROTECTED] The slave server stop working today and I looked to the error

Re: updates on slave server??

Is there a way to check that data on slave server is the same as data on master ? Thanks From: Paul DuBois [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: updates on slave server?? Date: Mon, 26 Jan 2004 21:58:42 -0600 At 0:49 + 1/27/04, Mike Mapsnac

updates on slave server??

Hello I found today that some data on slave server were different than on master server. I don’t know how that can happen. Slave server was running, show slave status show no errors If I make some updates on slave server. Does this updates will be reflected on master server? Or slave cannot

How to write such query?

I want to get distinct title from table titles. But there are two differnt titles (new and used).So I need somehow join all three tables where user_tiles status='true' and titles are distinctive. Thanks titles

temporary tables

Which of these three joins are using temporary table? # 1 Inner Join # 2 Left Join #3 Outer Join Thanks

Select help

Hello I want to select from the table sum of logins for each day. For example: Date Logins 2004-01-22 10 2004-01-23 12 Any ideas if such select is possible? +--+--+ | Field| Type |

Left Outer Join?

What is the difference between Left Join and Left Outer Join? Thanks

Kill alter table process?

I run alter today on table with 380,000 records. 'Alter' was adding column to the table. It took 10 minutes and server load went up to 15. alter table info add column interactive_email enum('on','off') NOT NULL default 'on'; Here comes my questions: #1 If I kill the process after it was running

Re: Kill alter table process?

Thanks for good explnation. Some more questions: #1Does 'update' also create temporary table? #2What happend with old table after alter? From: mos [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Kill alter table process? Date: Wed, 21 Jan 2004 19:12:07

Increment value

In the table value login_count is int(4). For example if value login_count equal to 3 and each time user login I want to increment by one. update customer set login_count='how? where id=12121212; What function I should use in order to icrement the value?

Re: Increment value

I know that. I'm lookign for mysql function that will increment the value. From: Tobias Asplund [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Increment value Date: Tue, 20 Jan 2004 23:36:22 +0100 (CET) On Tue, 20 Jan 2004

Re: table info

: Mon, 19 Jan 2004 14:10:37 +0200 Mike Mapsnac [EMAIL PROTECTED] wrote: Is it possible to find out when the table was created? How to get information about the table? SHOW TABLE STATUS command provides info about table: http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html -- For technical

Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server

Weird. I cannot find the my.cnf (configuration file).. How that's possible? Thanks From: Victor Medina [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Mysql Installation on Linux: ERROR 2002: Can't connect tolocal MySQL server th Date: Sun, 18 Jan 2004

table info

Is it possible to find out when the table was created? How to get information about the table? Thanks

Mysql Installation on Linux: ERROR 2002: Can't connect to local MySQL server th

I just install MYSQL on Linux (Red Hat 9) using this manual:http://www.mysql.com/doc/en/Installing_binary.html Have no idea what's wrong. I looked on the mysql.log file and the file is empty. ERROR MESSAGE: [EMAIL PROTECTED] bin]# ./mysql ERROR 2002: Can't connect to local MySQL server through

mysql.sock

What is the purpose of mysql.sock file in mysql? A lot of problems are assosiate with this file.

insert: auto increment field

I have table with 7 fields. First field is id (auto increment). As I understand the value should start from 0 and next value will auto increment. And I shouldn't add insert the value. So the insert statemens below gives me an error. ERROR 1136:Column count doesn't match value count at row 1

Re: insert: auto increment field

PROTECTED] Subject: Re: insert: auto increment field Date: Sun, 04 Jan 2004 08:44:56 -0700 On Sun, 2004-01-04 at 08:09, Mike Mapsnac wrote: I have table with 7 fields. First field is id (auto increment). As I understand the value should start from 0 and next value will auto increment. And I shouldn't

RE: insert: auto increment field

I delete all records from the table and cannot insert second element to the table. Auto increment starts with higher number .. ERROR 1062: Duplicate entry '2147483647' for key 1 From: Larry Brown [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED],MySQL List [EMAIL PROTECTED] Subject: RE

Re: insert: auto increment field

It solved the problem. But what truncate does? Just deletes the rows? From: Daniel Kasak [EMAIL PROTECTED] To: Larry Brown [EMAIL PROTECTED],Mike Mapsnac [EMAIL PROTECTED], MySQL List [EMAIL PROTECTED] Subject: Re: insert: auto increment field Date: Mon, 05 Jan 2004 11:18:08 +1100

Re: insert: auto increment field

Thanks. Just for curiosity. Why truncate was necessary in my case? I just create a table and try to insert some values. From: Daniel Kasak [EMAIL PROTECTED] To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: insert: auto increment field Date: Mon, 05

Table: NULL (yes or no)

I create two tables. And when I do desc table_name; NULL value can be 'Yes' or 'No'. What the difference when NULL value is 'Yes' or 'No Thanks _ Worried about inbox overload? Get MSN Extra Storage now!

Delete logs: not enough space on /var/lib/mysql

I don't have enough space on /var/lib/mysql partition. What logs can be deleted from the partition? Is it possible don't delete last logs? Thanks _ Worried about inbox overload? Get MSN Extra Storage now!

Alter table and setup Default value

I use MYSQL 4. I can modify or alter a column with no problems. But how I can alter table and setup Default value. The column below has default value NULL, but I want to setup default value used. How that's can be done? type | enum('new',used') | YES | | NULL||

mysql.sock permission srwxrwxrwx

I'm trying to open mysql.sock file as a ROOT and receive the error message permission denied. Why mysql.sock has such permission? _ Tired of slow downloads? Compare online deals from your local high-speed providers now.

Replication Problems: Ignore table

The replication between two servers works. But I tried to disable replication on one table. According to the MYSQL Documentation. I did the following: #1 stop Slave #2 Modified my.cnf on slave [mysqld] server-id=3 master-host=192.168.1.129 master-user=aert12 master-password=password