Re: MySQL give up on a query after a certain length of time

Check if problem remains with official binaries. I will. My schedule won't allow it right now, but I will get to it soon. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL give up on a query after a certain length of time

Variables are net_read_timeout and net_write_timeout : I don't think I can use net_read_timeout to timeout a query. Net Read Timeout: The time required in seconds to wait for more data from a connection before aborting the read. Jacob -- MySQL General Mailing List For list archives:

Re: MySQL give up on a query after a certain length of time

Normally such different behavior for same queries is weird. Do you use an official binaries or from Debian? I use those from Debian: http://packages.debian.org/testing/misc/mysql-server-4.1 Thanks, Jacob Jacob Friis Larsen [EMAIL PROTECTED] wrote: Check with SHOW PROCESSLIST in what

Re: MySQL give up on a query after a certain length of time

On 5/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: There is a variable called --network-timeout ! You can set it to 300 (5 minutes, etc.). SET SESSION network-timeout=120; ERROR 1193 (HY000): Unknown system variable 'network' How should I use network-timeout? Thanks, Jacob -- MySQL

Re: MySQL give up on a query after a certain length of time

On 5/20/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: There is a variable called --network-timeout ! You can set it to 300 (5 minutes, etc.). Don't you mean net_read_timeout? http://dev.mysql.com/doc/mysql/en/dynamic-system-variables.html SET SESSION net_read_timeout = 300; Thanks, Jacob

MySQL give up on a query after a certain length of time

Hello. Is there a way to have MySQL give up on a query after a certain length of time? I use Debian Linux Sarge, MySQL 4.1 and Php 5. Sometimes I have queries that take forever although the same query returns fast at other times. Thanks, Jacob -- MySQL General Mailing List For list archives:

Re: MySQL give up on a query after a certain length of time

Check with SHOW PROCESSLIST in what state your query hangs. It hangs while sending data. I only ask for 7 rows, and normally this goes very fast. Have a nice weekend. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Upgrade MySQL and replication dies

I use Debian Sarge as my Linux distribution on two servers who replicate MySQL. Every time I upgrade the MySQL package my replication dies. Any ideas why? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Upgrade MySQL and replication dies

check next time. Thanks, Jacob Jacob Friis Larsen [EMAIL PROTECTED] wrote: I use Debian Sarge as my Linux distribution on two servers who replicate MySQL. Every time I upgrade the MySQL package my replication dies. Any ideas why? Thanks, Jacob -- For technical

Query caused different errors on master and slave.

Anyone know what to do when SHOW SLAVE STATUS says: Query caused different errors on master and slave. Master: MySQL 4.1.9-Debian_2-log Slave: MySQL 4.1.5-gamma-log Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Data in different tables or is one big table just as fast?

We have a table that grow by 200MB each day. Should we put data in different tables or is one big table just as fast? The table contains data from RSS and Atom feeds. Most users only need to see the newest items. A select could look like this: SELECT title, desc FROM items WHERE feedid

Re: Data in different tables or is one big table just as fast?

how about purging rows older than a month? Do you need to keep them? Yes. Archive them them to another database? We are currently archiving them to another table, where we compress the text. Actually, I got a better idea. Have your master db which is huge and holds everything. Then on a

Query: Get 100 itemid's for each id.

This is my table: CREATE TABLE items ( id int(10) UNSIGNED NOT NULL default '0', itemid int(10) UNSIGNED NOT NULL auto_increment, PRIMARY KEY (`id`) ); I'd like to get 100 itemid's for each id. Is that possible. If so, please show me how. Thanks, Jacob -- MySQL General Mailing List For

Re: Query: Get 100 itemid's for each id.

This is my table: CREATE TABLE items ( id int(10) UNSIGNED NOT NULL default '0', itemid int(10) UNSIGNED NOT NULL auto_increment, PRIMARY KEY (`itemid`) ); I'd like to get 100 itemid's for each id. Is that possible. If so, please show me how. - you have id set as the primary

Re: Query: Get 100 itemid's for each id.

This is my table: CREATE TABLE items ( id int(10) UNSIGNED NOT NULL default '0', itemid int(10) UNSIGNED NOT NULL auto_increment, PRIMARY KEY (`itemid`) ); I'd like to get 100 itemid's for each id. I guess I could solve my problem with a subselect. Thanks, Jacob --

Data in different tables or is one big table just as fast?

We have a table that grow by 200MB each day. Should we put data in different tables or is one big table just as fast? We will for new data do select, update and insert and for old data only select. Any help would be great. Thanks, Jacob -- MySQL General Mailing List For list archives:

Re: Data in different tables or is one big table just as fast?

On Fri, 28 Jan 2005 11:47:47 +, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jacob Friis Larsen [EMAIL PROTECTED] wrote on 28/01/2005 11:23:46: We have a table that grow by 200MB each day. Should we put data in different tables or is one big table just as fast? We will for new data do

Error 1034: Incorrect key file for table; try to repair it

Is there a workaround for bug 5686? http://bugs.mysql.com/bug.php?id=5686 We use Debian Linux testing and MySQL 4.1.8 Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [PHP] building php5.0 as an apache module, with mysqli functionality

Curt Zirzow wrote: i'm trying to use the following configure ./configure --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc --with -mysql=/usr/include/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config - -with-ldap --with-pgsql If you read the installation at http://php.net/mysqli, you

Re: fastest filesystem for MySQL

I'd go with Reiser on SuSE. What about Reiser on Debian? Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Restore 20 gigabytes of binary logfiles

I need to restore 20 gigabytes of binary logfiles. What should I do in order to get the job done as quickly as possible? There is a faster way, but it is rather tricky. 4.0 slave can be tricked into thinking that those binary logs are in fact the relay logs that it gathered from the master. So

MySQL 4.0 crashed; Please help

Can someone help me find out what caused this crash? My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz with 2.5G ram. 3 disks in raid 5. The MySQL database is 4.0.17 040212 19:27:36 read_const: Got error 126 when reading table ./exp4/sql_cache Number of processes running

Re: MySQL 4.0 crashed; Please help

[EMAIL PROTECTED] wrote: Did you perform a stack trace? No, how do I do that? /Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.0 - 4.1.1 = Unknown character set: 'latin1_swedish_ci'

I have upgraded from MySQL (rpm) 4.1.0 to 4.1.1 and now I see lots of lines in the error log with: Unknown character set: 'latin1_swedish_ci' How can I fix this? Regards Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

HANDLER table READ locked ?

How can a query like HANDLER table READ on a MyISAM table be locked? I thought the idea of HANDLER table READ was that it couldn't be locked. Kill 1696313 xxx localhost xxx Query 3 Locked HANDLER questions READ FIRST WHERE qid = 290184 LIMIT 1

Fw: Client API version is wrong or am I?

I have installed the MySQL database 4.0.4 client, but when I look at phpinfo() I see that it says: Client API version: 4.0.2-alpha Why? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the

thread_concurrency (Try number of CPU's*2 for thread_concurrency)

set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 If I have 2 CPU's, does the above mean that I should set thread_concurrency=16 ? I am using a MySQL database 4.0.4 Regards, Jacob

SV: UPDATE LOW_PRIORITY database

Venlig hilsen Jacob Friis Larsen [ JFL WebCom | www.webcom.dk | +45 7027 0767 ] -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sendt: 25. november 2002 11:02 Til: Jacob Friis Larsen Emne: Re: UPDATE LOW_PRIORITY database Your message cannot

tmpdir

I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the database path being on raid disks and /tmp/ on a non raid disk. Should the tmpdir be on a raid disk? If so they will be at the same disk as the database. Is that the best option? Regards, Jacob

UPDATE LOW_PRIORITY

If I use UPDATE LOW_PRIORITY, will the client then have to wait for the update query to finish or not? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Disable InnoDB

Can i get more speed by disabling InnoDB tables, if I'm only using MyISAM and HEAP tables? Any warnings about this? Regards, Jacob http://www.sharksforum.com sql - Before posting, please check:

Optimal use of HANDLER

To optimize speed I would like to use a HANDLER sql query to get data from my database. HANDLER questions OPEN; HANDLER questions READ FIRST WHERE qid = 1 LIMIT 1; [Php code collects data] HANDLER questions CLOSE; Is that the best way to use HANDLER? Can I make it even faster? If any of you

max_connections=?

What is the maximum for max_connections when I have: MySQL database server 4.0.3-beta HP NetServer LC2000 running RedHat Linux 7.3 Dual Pentium III 800mhz 1GB Ram Raid5 Regards, Jacob - Before posting, please check:

MySQL 4.0.2 doesn't unlock certain tables

or how I can fix this? Regards Jacob Friis Larsen [ JFL WebCom | www.sharksforum.com | www.eksperten.dk | +45 7027 0767 ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

UPDATE LOW_PRIORITY

MySQL question: If I use UPDATE LOW_PRIORITY will the client then have to wait for the update to finish or is UPDATE LOW_PRIORITY the same as INSERT DELAYED ? - Before posting, please check: http://www.mysql.com/manual.php

Cannot find header files

When I try to install Php like this: ./configure --with-mysql=/usr/local/lib/mysql I get: configure: error: Cannot find header files under /usr/local/lib/mysql I have installed: http://www.mysql.com/Downloads/MySQL-4.0/MySQL-4.0.1-2.i386.rpm

client server

If I install MySQL on the same server as Apache Php and only use MySQL in Php, do I then have to install the MySQL client? Regards Jacob [ www.sharksforum.com ] - Before posting, please check:

RE: client server

If I install MySQL on the same server as Apache Php and only use MySQL in Php, do I then have to install the MySQL client? Technically, you don't need it. But when I am debugging PHP, I often turn to mysql client just for a sanity check on a query. If your database stuff fails,

HOSTNAME-bin.001 ???

I found files whith names like localhost-bin.001, localhost-bin.002 in /tmp/ What are they ? Also, what does it mean that my MySQL database version is 3.23.47-log. What does -log mean ? Regards Jacob [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]

hostname.pid

How do I correct this database problem ? Please also reply to my E-Mail address. /usr/local/libexec/mysqld: Can't create/write to file '/usr/loc al/var/hostname.pid' (Errcode: 13) - Before posting, please check:

RE: hostname.pid

23, 2001 4:18 PM To: Mysql maillist Cc: Jacob Friis Larsen Subject: RE: hostname.pid Hi, Check your autorisations for this file for the user mysql runs under. It does not have permissions to access the specified directory. Regards, Almar van Pel -Oorspronkelijk bericht- Van

select 10 of each

How do I select 10 rows with lang = 1 and 10 rows with lang = 2 from a MySQL database ? Please also reply to my E-Mail address. :) Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: select 10 of each

Can't I put an IF / CASE in the query to make it work ? [ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ] -Original Message- From: Brett Error [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:01 PM To: 'Jacob Friis Larsen'; Mysql maillist Subject: RE

keys

Which keys should I have for a database query like : SELECT qid, catid, point, flag_status, timestamp FROM questions WHERE (flag_status = 1 OR flag_status = 2) ORDER BY qid DESC LIMIT 0, 10 - Before posting, please check:

privileges for SHOW PROCESSLIST

What privileges should I give my user so that I can do the SHOW PROCESSLIST on all databases ? Please also reply to my E-mail address. :) Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

SV: privileges for SHOW PROCESSLIST

What privileges should I give my user so that I can do the SHOW PROCESSLIST on all databases ? Process_priv Should I then do : GRANT PROCESS ON mysql.* to shark@'123.123.123.123' identified by 'sharkpassword'; - Before

FULLTEXT : HANDLER

Is it possible to use a FULLTEXT index with HANDLER to search in the database. The advantage should be to avoid table locking. http://www.mysql.com/doc/H/A/HANDLER.html Please also reply to my E-mail address. Thanks! Jacob [ www.sharksforum.com ]

What does the max_connect_errors do ?

What does the max_connect_errors do ? Is it : if I have that many connect errors, MySQL will stop ? [database] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

FULLTEXT

We have a database where users search for text very often, which give us the problem that the tables are locked for some seconds. Is it possible to take a copy of the FULLTEXT index, and search in that so the table we search in does not get locked ? Or do you have any other ideas to solve this.

HEAP tables

Does anyone have comments about using HEAP tables to cache a real table from a database ? My HEAP tables has max 10 rows. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

which db server

We are currently running a website witch both takes care of the database and the application. We will buy a HP server, which will only be used as a db server. It will probably be a dual PIII 800mhz with 512mb ram and 3 physical disks. We have the option of changing this a bit. What would give

--with-raid

What does --with-raid mean ? I am running MySQL on a RedHat Linux with raid disks. Should I then use --with-raid when installing ? Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

How can I optimize RAND()

SELECT something FROM users WHERE statement_ok = 1 ORDER BY RAND() LIMIT 0, 1 When I use the above SQL I mostly get the same result. How can I prevent that ? :) Jacob -- [ www.eksperten.dk ] Scandinavias biggest IT forum. -

which is fastest connect or pconnect ?

We often get a message from MySQL that there are too many connections. What can we do ? Should we use connect rather than pconnect ? We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32 Regards Jacob - Before posting,

FULLTEXT

I have a query that works : $sql = "SELECT questions.qid, questions.title, MATCH questions.title, questions.question AGAINST ('support') as relavance FROM questions ORDER BY relavance DESC LIMIT 0, 50"; I would like this query to also match results from the field respons in the table respons. I

PRIMARY KEY (userid), UNIQUE (userid)

Is there an idea in having a PRIMARY KEY and UNIQUE key for the same table column ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

INDEX() / UNIQUE()

Is there any idea in using both a INDEX() and UNIQUE() index on the same table field ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)