> 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]
> 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
> 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
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
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
> 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
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
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
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
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
> 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
> >>>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
> > >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
> >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
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
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
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
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]
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
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
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]
[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]
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
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
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
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
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/
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
-
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
>
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
-
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
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
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
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)
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
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
> > 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
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
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 ]
--
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)
; 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
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
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
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
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
>> 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
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)
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 ?
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/
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.
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
--
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
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
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
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
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,
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
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
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
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
60 matches
Mail list logo