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

2005-05-24 Thread Jacob Friis Larsen
> 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

2005-05-23 Thread Jacob Friis Larsen
> 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: > > >> Che

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

2005-05-23 Thread Jacob Friis Larsen
> 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: http://l

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

2005-05-22 Thread Jacob Friis Larsen
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 G

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

2005-05-21 Thread Jacob Friis Larsen
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

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

2005-05-20 Thread Jacob Friis Larsen
> 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:http://lists.my

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

2005-05-20 Thread Jacob Friis Larsen
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: ht

Re: Upgrade MySQL and replication dies

2005-04-06 Thread Jacob Friis Larsen
that it is running ok, but I'll 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 repl

Upgrade MySQL and replication dies

2005-04-05 Thread Jacob Friis Larsen
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

Query caused different errors on master and slave.

2005-02-19 Thread Jacob Friis Larsen
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:http://lists.mysq

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

2005-02-15 Thread Jacob Friis Larsen
> 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

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

2005-02-15 Thread Jacob Friis Larsen
> >>>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 item

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

2005-02-14 Thread Jacob Friis Larsen
> > >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 subsele

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

2005-02-14 Thread Jacob Friis Larsen
> >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 i

Query: Get 100 itemid's for each id.

2005-02-14 Thread Jacob Friis Larsen
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: Data in different tables or is one big table just as fast?

2005-01-28 Thread Jacob Friis Larsen
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

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

2005-01-28 Thread Jacob Friis Larsen
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: http://li

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

2005-01-19 Thread Jacob Friis Larsen
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

2004-07-19 Thread Jacob Friis Larsen
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: Restore 20 gigabytes of binary logfiles

2004-05-13 Thread Jacob Friis Larsen
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 we

Re: fastest filesystem for MySQL

2004-05-13 Thread Jacob Friis Larsen
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: MySQL 4.0 crashed; Please help

2004-02-13 Thread Jacob Friis Larsen (Eksperten admin)
[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]

MySQL 4.0 crashed; Please help

2004-02-13 Thread Jacob Friis Larsen [Eksperten admin]
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 n

4.1.0 -> 4.1.1 = Unknown character set: 'latin1_swedish_ci'

2003-12-05 Thread Jacob Friis Larsen
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:http://lists.mysql.co

HANDLER table READ locked ?

2002-12-04 Thread Jacob Friis Larsen
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

Disable InnoDB

2002-11-25 Thread Jacob Friis Larsen
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: http://www.mysql.com/manual.ph

UPDATE LOW_PRIORITY

2002-11-25 Thread Jacob Friis Larsen
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/

tmpdir

2002-11-25 Thread Jacob Friis Larsen
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 -

SV: UPDATE LOW_PRIORITY database

2002-11-25 Thread Jacob Friis Larsen
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 >

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

2002-11-25 Thread Jacob Friis Larsen
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 -

Fw: Client API version is wrong or am I?

2002-11-25 Thread Jacob Friis Larsen
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

Optimal use of HANDLER

2002-11-20 Thread Jacob Friis Larsen
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 spe

max_connections=?

2002-10-02 Thread Jacob Friis Larsen
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: ht

MySQL 4.0.2 doesn't unlock certain tables

2002-08-21 Thread Jacob Friis Larsen
w why 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)

UPDATE LOW_PRIORITY

2002-07-29 Thread Jacob Friis Larsen
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

2002-05-27 Thread Jacob Friis Larsen
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 http://www.mysql.com/Downloads/MySQL-4.0/MySQL-clie

RE: client & server

2002-05-22 Thread Jacob Friis Larsen
> > 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

client & server

2002-05-22 Thread Jacob Friis Larsen
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: http://www.mysql.com/manua

HOSTNAME-bin.001 ???

2002-01-24 Thread Jacob Friis Larsen
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 ] --

fastest way to add FULLTEXT

2002-01-08 Thread Jacob Friis Larsen
Which is the fastest way to add FULLTEXT index to a database table with 1.500.000 rows ? Please also reply to my E-Mail address. Regards Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: hostname.pid

2001-12-23 Thread Jacob Friis Larsen
; Sent: Sunday, December 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

hostname.pid

2001-12-23 Thread Jacob Friis Larsen
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: http://www.m

RE: select 10 of each

2001-12-19 Thread Jacob Friis Larsen
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'; M

select 10 of each

2001-12-19 Thread Jacob Friis Larsen
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) http

keys

2001-12-18 Thread Jacob Friis Larsen
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: ht

SV: privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
>> 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'; - Befor

privileges for SHOW PROCESSLIST

2001-10-05 Thread Jacob Friis Larsen
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)

FULLTEXT : HANDLER

2001-09-26 Thread Jacob Friis Larsen
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 ?

2001-06-25 Thread Jacob Friis Larsen
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

2001-05-30 Thread Jacob Friis Larsen
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.

myisampack

2001-05-22 Thread Jacob Friis Larsen
If I have a lot of rows with text that never changes. Only more rows are added. Should/Can I then use myisampack ? Will it make my FULLTEXT search faster ? Will other database SELECTs become faster ? For now I do not care about disk space. Best regards Jacob --

which db server

2001-05-21 Thread Jacob Friis Larsen
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 u

HEAP tables

2001-05-21 Thread Jacob Friis Larsen
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) http://lists.mysql.c

--with-raid

2001-05-17 Thread Jacob Friis Larsen
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) ht

How can I optimize RAND()

2001-05-09 Thread Jacob Friis Larsen
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. - Be

which is fastest connect or pconnect ?

2001-04-19 Thread Jacob Friis Larsen
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

2001-02-09 Thread Jacob Friis Larsen
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

scale

2001-02-08 Thread Jacob Friis Larsen
Is it possible to run one MySQL server on more than one Linux box ? and is this good, or should we put it on Unix machines ? We prefer Linux as it is free :) - Before posting, please check: http://www.mysql.com/manual.php

PRIMARY KEY (userid), UNIQUE (userid)

2001-02-07 Thread Jacob Friis Larsen
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 re

INDEX() / UNIQUE()

2001-02-06 Thread Jacob Friis Larsen
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) To