On Jan 30, 2004, at 10:25 AM, Bruce Dembecki wrote:
On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful
stuff:
So.. My tips for you:
1) Consider a switch to InnoDB, the performance hit was dramatic,
and it's
about SO much more than transactions (which we still don't do)!
Consider
At 17:14 -0500 1/30/04, Millaway, John wrote:
If the master is InnoDB, must slaves also be InnoDB, or could they be
MyISAM? (Assuming no foreign keys are set to CASCADE.) -John
The slaves can be MyISAM.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL
In the last episode (Jan 30), [EMAIL PROTECTED] said:
> >Description:
> Instead of ordering rows, ORDER BY may remove rows
...
> mysql> SELECT Id3 FROM T WHERE Id2=2 AND Val BETWEEN -30 AND 20 ORDER BY Id3;
> +-+
> | Id3 |
> +-+
> | 3 |
> +-+
> 1 row in set (0.01 sec)
>
> Note: both
Jasper Bryant-Greene wrote:
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word
--- [EMAIL PROTECTED] wrote ---
> In this case it might be easier for you to just modify the MySQL
> source to disable looking for the socket, and treat localhost as
> 127.0.0.1.
>
> --Pete
Pete,
I've considered that (and I'm going to try it on a development box).
Unfortunately the target of thi
I am wary of something so 'do it yourself'. Have you looked at ReHat's
clustering solution?
http://www.redhat.com/software/rha/cluster/
http://www.redhat.com/software/rha/cluster/manager/
I don't think it has any issue with InnoDB, key buffers, etc.
I believe this solution works best for failove
At 01:20 PM 1/30/2004, you wrote:
I routinely see people requesting information on how to efficiently
handle *large* tables in mysql. Hopefully, the following will be helpful
to those individuals.
I have several tables that are 500M to 4B rows in size and
require me to drop and re-cre
Does replication in 5.0 support stored procedure?
When I create a procedure on the master, it isn't
replicated to the slaves. I then manually create
the same procedure on the slaves. Then when I
call the procedure on the master, all the slaves
crashes. Is this not supported or am I doing somethi
If the master is InnoDB, must slaves also be InnoDB, or could they be
MyISAM? (Assuming no foreign keys are set to CASCADE.) -John
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greetings!
Is anyone familiar with/can recommend any software capable of helping design
complex (well for me anyway) queries/updates/inserts with joins?
Thanks for any info!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
Hi
I'm running a small search engine that indexes the web, but have been having
trouble with optimising it to handle the load.
There are two tables involved in searching - `pages`, which stores the ID,
URL, title and crawl date, and `words` which has two rows - `word` and
`page` where `word` i
At 02:33 PM 1/30/2004, you wrote:
Hi,
I´m having a serious performance problem with my MySQL.
The CPU is most of time with a load of 60%-95%.
I´m using MySQL-4.0.14 on a FreeBSD-5.1 box.
It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk.
I think the main problem the queries struct wrongly b
try
SELECT id,(TO_DAYS(firstdate)- TO_DAYS(postdate)) AS diff FROM calendar
well you have to put the bigger date on the lhs.
Kenneth Letendre wrote:
Hello,
I'm trying to get the difference (in days) between dates stored in two
date fields.
My query:
SELECT id,(firstdate- postdate) AS diff
It will more easier if you post the sample.c.
you can try compiling with -ggdb to debug
Leif Johnston wrote:
Any thoughts on what might be causing this error? I am runing both on cygwin under windows 2000 with 4.0.16 and using gcc to compile, linking using
gcc sample.c -o sample.exe -I/usr/in
The Hot backup/dump tools use the mysql server to create a live backup
while the server is running. On MyIsam tables, I think they are locked
during the entire process.. innodb may be different.
You can backup the DB files directly, but, the mysql server MUST be
shut down to do so.. which is li
In this case it might be easier for you to just modify the MySQL
source to disable looking for the socket, and treat localhost as
127.0.0.1.
--Pete
On Fri, Jan 30, 2004 at 06:33:22AM -0800, [EMAIL PROTECTED] wrote:
> --- [EMAIL PROTECTED] wrote ---
> > i've never set up tunnels and such, but are
Steve,
Thank you for the information, I checked but found they are all for Linux
and none is for Solaris.
I will try to download the source file package and compile the whole thing
to see if it works.
C.C. Liu
-Original Message-
From: Steve Sills [mailto:[EMAIL PROTECTED]
Sent:
Do a search on RPMFind.net and download libmysqlclient for the version of
your mysql. I had the same problem installing MYSQL support in
Qmail/Vpopmail
Steve Sills
Platnum Computers, President
http://www.platnum.com
[EMAIL PROTECTED]
- Original Message -
From: "Liu, C.C" <[EMAIL PROTECTE
Hi,
I´m having a serious performance problem with my MySQL.
The CPU is most of time with a load of 60%-95%.
I´m using MySQL-4.0.14 on a FreeBSD-5.1 box.
It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk.
I think the main problem the queries struct wrongly build,
but at this time I need to
MySql exporters:
I downloaded mysql-4.0.17 binary package for Solaris 8, uncompressed,
un-tared and have it running
by the command "bin/mysqld_safe --user=mysql &".
Now I'm trying to install another application, RIPE Whois Server, which
requires mysql/lib/libmysqlclient_r.so
during the installatio
Hi, all. I notice this is not recommended in the manual. But I wonder if not
considering performance, when using dbd as the table type, are there any problems in
these two cases?
1) running multiple mysqld processes on the same machine with the same datadir.
2) running multiple mysqld on differe
Any thoughts on what might be causing this error? I am runing both on cygwin under
windows 2000 with 4.0.16 and using gcc to compile, linking using
gcc sample.c -o sample.exe -I/usr/include/mysql -L/lib/mysql/opt/ -lmysqlclient
-lmySQL -lz -lm
I assume that something in the libraries may not
I routinely see people requesting information on how to efficiently
handle *large* tables in mysql. Hopefully, the following will be
helpful to those individuals.
I have several tables that are 500M to 4B rows in size and
require me to drop and re-create indices at regular interval
Does anyone know this?
In the 4.0.17 and later build, the target table of an INSERT...SELECT can be
the same as the SELECT table (insert into table1...select ...from table1).
Does the process essentially happen in a natural lock? In other words,
could the table change between the data retrieved
Hello All;
I am in the process of examining a High Availability
(HA) configuration. The motivation is to not use
database replication (at least at this stage) because
of the need to work on the complete data set at any
given point in time. Here is the configuration choice
being considered
CONFIGU
you need to install this file, findable on the ftp servers from redhat
php-mysql-4.2.2-17.i386.rpm
ftp> pwd
257 "/pub/redhat/linux/9/en/os/i386/RedHat/RPMS"
(ftp.redhat.com/pub/redhat/linux/9/en/os/i386/RedHat/RPMS/)
how that further works i dont know since i dont use redhat at all.
goodluck
Remko,
is any parameters value do you want me change in php.ini file?
which package do you want to install from redhat pl?
Remko Lodder <[EMAIL PROTECTED]> wrote:
That would be good,
But installing php does not mean that mysql features are also added.
Please checkout your php configuration if
Ware Adams said:
> Paul Stearns wrote:
>
>>As reported under the subject "Random Database Slowdowns..." on the
>> win32 list, our database still hangs on an average of 1-2 times per
>> day.
>>
>>I can find no error messages or logs associated to the problem. It
>> affects both IIS ADO connections a
Paul Stearns wrote:
>As reported under the subject "Random Database Slowdowns..." on the
>win32 list, our database still hangs on an average of 1-2 times per
>day.
>
>I can find no error messages or logs associated to the problem. It
>affects both IIS ADO connections as well as local connections f
To configure PHP for MYSQL from (http://www.php.net/manual/en/ref.mysql.php):
Requirements
In order to have these functions available, you must compile PHP with MySQL support.
Installation
By using the --with-mysql[=DIR] configuration option you enable PHP to access MySQL
databases.
In PHP 4
Hallo,
I'm totally new to MySQL or any other data bases...
I installed MySQL 4.0.15a as supplied with the SlackWare 9.1 Linux
distribution. The only documentation supplied are the Reference Manual en
the man pages. But the Reference Manual is a little bit too touch for me. I
managed to get m
That would be good,
But installing php does not mean that mysql features are also added.
Please checkout your php configuration if it is included, otherwise install
the appropiate packages from redhat
--
Kind regards,
Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl Dutch community
By open file tool I mean software that works concurrently with a backup
suite such as veritas that would backup any open files (such as MySQL
binaries) that would normally be skipped.
What do you mean by inconsistent? What does InnoDB Hot backup do
differently than an open file agent?
So the onl
I installed php.
what is linux9? =RED HAT 9
aCTUALLY i WANT TO develop smal webbased application.I was thinking PHP,MYSQL,APACHE
AND LINUX WOULD BE good,but any other combination would be great if you guyes suggest.
Remko Lodder <[EMAIL PROTECTED]> wrote:
your php is not configured to use
Here are some tables:
Create Table FN (
FNunid varchar(32) not null,
...,
PRIMARY KEY (FNunid)
);
Create Table Dependent (
DEPunid varchar(32) not null,
FNunid varchar(32) not null,
...,
PRIMARY KEY (DEPunid),
CONSTRAINT `0_69` FOREIG
your php is not configured to use mysql? perhaps?
and just what is linux9?
please install php with mysql support.
--
Kind regards,
Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl Dutch community for helping newcomers on the
hackerscene
-Oorspronkelijk bericht-
Van:
Hi all,
I have been noticing following error message with PHP.
Fatal error: Call to undefined function: mysql_connect()
Let me know how to fix that.I have installed linux9,apache 2.0, php.
thx -seena
-
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building t
I have developed a website on my PC and I am testing there too. I keep
getting script time out errors, can I stop this from happening? I am
basically having to build an identical site and test it using access.
Double the work!!
I can't believe that access is responding tens if not hundreds of t
Hi MySQLians,
For the last 2 months I have tried to establish connection
between COBOL and MySQL. Hope I have succeeded a stage in
this regard.
I have used
Remote server: MySQL Server 4.0.17-max in Suse Linux
Client: Windows 2000
Microsoft VC++ 6.0
CA-Realia COBOL Compile
At 08:14 AM 1/30/2004, you wrote:
Hello ,
I must create a temp table with 5 or more million records.
I need it for creating some reports, so I need to create indexes too.
My question is:
When total time for work will be smaller? :
1-st case: I create table and create indexes immediately before
fil
> On Jan 28, 2004, at 12:01 PM, Bruce Dembecki wrote this wonderful stuff:
>>
>> So.. My tips for you:
>>
>> 1) Consider a switch to InnoDB, the performance hit was dramatic, and it's
>> about SO much more than transactions (which we still don't do)!
>>
> Consider it switched! as soon as I find
Is there any way to assign Privileges to databases/tables/fields via
Groups rather than user by user?
Hi,
actually it depends on table type.
Since you said that it will be temp table then I guess it will be MyISAM
table.
In this case it is better to use 2 way:
> 2-nd case: I create table, filling data and then create indexes?
But if you will create InnoDB temp table that (according to Heikki Tuu
On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was in
"Dan Muey" <[EMAIL PROTECTED]> wrote:
> What is the difference between 'Mac OS X downloads' and
> 'Mac OS X Package Installer downloads' listed at:
> http://www.mysql.com/downloads/mysql-4.0.html
>
> I know I want 'standard' and not 'max' or 'debug' but do I want=20
> 'Mac OS X downloads' or 'Mac
One more consideration, if your 5mil of records contains duplicates you
won't get the opportunity to load the table using "REPLACE" or "INSERT
IGNORE" without the UNIQUE index already in place. You would have to
distinct the rows first or manually remove the duplicates before
creating the index aft
Thanx a lot Tom :)
I guess you forgot 'group by NoPeople' at the end of the first query.
right ?
fab
Tom Cunningham wrote:
Try this:
CREATE TEMPORARY TABLE max_entry
SELECT NoPeople, Max(Date_entry) AS Date_entry FROM table;
SELECT NoPeople FROM table NATURAL JOIN max_entry
WHERE Departure
Hi,
I am not sure, but may be you had Key_read_requests overflow.
Best regards,
Mikhail.
- Original Message -
From: "John David Duncan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 29, 2004 11:40 PM
Subject: key_reads > key_read_requests
> Hi,
>
> key_reads is
Heh..
I wasn't going by the docs when I responded... I had to reindex a 50+mil
row table... Not a good time :) Then I started preparing the structure a
bit before taking in the data. Seemed to work better in my circumstance.
P
-"Dan Greene" <[EMAIL PROTECTED]> wrote: -
To: "Peter J
Inside of cygwin I ran
gcc sample.c -o
sample.exe -I/usr/include/mysql/ -L/lib/mysql -lmysqlclient -lmySQL -lz -lm
I confirmed libmysql.dll is in mysql/bin with "everyone" access full control
against these files, also that username and password to db are right, but I
am guessing there is another
--- [EMAIL PROTECTED] wrote ---
> i've never set up tunnels and such, but are you sure that your ssh
> tunnel is also listening on localhost (i.e. 127.0.0.1)? i once had a
> problem like that with my apache, and it turned out that it only
> listened on 'real' IPs
Yeah, the tunnels work perf
>From what I've read ( I think in the MySQL docs, might have been here in the list),
>technically it will take less time to add the indexes after the table creation, than
>the overhead of index updating per-insert.
Either way, it's gonna take a loong time.
> -Original Message-
> F
> When total time for work will be smaller? :
> 1-st case: I create table and create indexes immediately before
> filling data.
> 2-nd case: I create table, filling data and then create indexes?
Filling the data data first and creating indexes after is faster, so you
should definitly go with nr 2.
I'd start with the indexes in place. 5+mil records will take quite some
time to index after the fact.
P
-Krasimir_Slaveykov <[EMAIL PROTECTED]> wrote: -
To: [EMAIL PROTECTED]
From: Krasimir_Slaveykov <[EMAIL PROTECTED]>
Date: 01/30/2004 09:14AM
Subject: SQL and productivity
Hello ,
I
There was some discussion in December of converting MS Access databases to
Mysql and the DBManager program was recommended. I have DBManager running
and select "Tools=>Data Management=>Import/Export Wizards," but the
command is greyed out and won't activate. I am using Office 2000 and I
have m
Hello ,
I must create a temp table with 5 or more million records.
I need it for creating some reports, so I need to create indexes too.
My question is:
When total time for work will be smaller? :
1-st case: I create table and create indexes immediately before
filling data.
2-nd case: I create tab
i've never set up tunnels and such, but are you sure that your ssh
tunnel is also listening on localhost (i.e. 127.0.0.1)? i once had a
problem like that with my apache, and it turned out that it only
listened on 'real' IPs
cheers and good luck,
M.
[EMAIL PROTECTED] wrote:
Greetings,
Th
I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part
of the distribution. After I set up my users I was able to use
mysqldump and pipe it into mysql on my windows machine running 4.0.16 to
dump a database to the suse box. However, now when I try to login to
the linux box fr
OK lesson learned, why .a vs .lib? Strange and scary notion.
I am still ending up with a segmentation fault once I use them as is. Same
is happening in windows side with code:
#include
#include
int main()
{
/* declasre structures and variables.*/
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW row;
Hi!
It depends on the isolation level whether locking reads set next-key locks
(= lock the record AND the gap before it), or only lock the record itself.
http://www.innodb.com/ibman.php#Set.transaction:
"
READ UNCOMMITTED
This is also called dirty read: non-locking SELECTs are performed so that
>Description:
Instead of ordering rows, ORDER BY may remove rows
>How-To-Repeat:
CREATE TABLE T (
Id INTEGER NOT NULL,
Id2 INTEGER NOT NULL,
Val FLOAT NOT NULL,
Id3 INTEGER NOT NULL,
KEY Key2 (Id2, Val),
KEY Key3 (Id3)
);
INSERT INTO T VALUES(1,3,-12,4);
INSERT INTO T VALUES(2,2,-27.5,
Greetings,
This is a complicated one (at least to explain), but it never hurts to
ask, right?
While the problem lies mostly in PHP scripts, this also happens with the
standalone MySQL client (v4.0.15 I believe).
Normally the client (PHP and command-line) tries to use the local socket
if the mysq
did you notice that you are using MSSQL instead of MySQL.
You are appearing to miss drivers or something however,
perl has some possibilities to connect to MSSQL hosts,
checkout www.cpan.org for that.
Cheers
--
Kind regards,
Remko Lodder
Elvandar.org/DSINet.org
www.mostly-harmless.nl Dutch com
Hello
I need to know how to get data base connectivity to a windows SQL2000
server from linux based app.
Are there any tools that I need.
When I try to connect I get this error
"DBMS MSS Microsoft SQL Server 6.x is not supported in your current
installation"
I am sure that it is just client conne
Hi, got a problem with the key locks, using InnoDB:
The mysql.com Manual reads:
SELECT ... FROM ... LOCK IN SHARE MODE: sets shared next-key locks on all
index records the read encounters.
SELECT ... FROM ... FOR UPDATE: sets exclusive next-key locks on all
index records the read encounters
Try this:
CREATE TEMPORARY TABLE max_entry
SELECT NoPeople, Max(Date_entry) AS Date_entry FROM table;
SELECT NoPeople FROM table NATURAL JOIN max_entry
WHERE Departure IS NULL;
> Hi all :)
>
> I have 1 relation A.
>
> Structure of A:
> NoPeople
> Date_entry
> Date_departure
>
> and key is (
Hi all :)
I have 1 relation A.
Structure of A:
NoPeople
Date_entry
Date_departure
and key is (NoPeople + Date_entry)
exemple of records:
NoPeople Entry Departure
P1 E1 D1
P1 E2 D2
P1 E3 NULL
P2 E1 NULL
P3 E1 D1
P4 E1 NULL
P4 E2 NULL
P4 E3 D2
E3>E2>E1 and D2>D1. P1,P2,P3 and P4 are different p
On a Windows Server (Win2000 or WinXP) that is running a database instance
(or many database). If I run the antivirus from Trend Micro (Trend
ServerProtect) all my database instance service are stopped.
Do you have any idea ? already talk with TrendMicro?
Thx, Stéphane
--
MySQL General Maili
re: MYSQL and PHP
I just noticed that my spam/virus filter is trapping and discarding
"Cc:"'s. If an email address is not in the "To:" line, you could also be
missing
some list traffic.
Just a comment!
thanks
dander
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
I have built a web site and I am testing it locally on my PC. Testing
through Internet Explorer is awfully slow and most of the time I am
getting error 'ASP 0113' script timed out. The table I am calling
records from is quite text heavy (a few hundred to a 1,000+ words per
field in some places)
Mauro,
- Original Message -
From: "Mauro Marcellino" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, January 29, 2004 10:44 PM
Subject: InnoDB Backups
> --=_NextPart_000_00CE_01C3E67E.9D867B90
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Trans
"Cummings, Shawn (GNAPs)" <[EMAIL PROTECTED]> wrote:
>
> I'd like to kill 2 birds with one stone...
>
> I'd like to SELECT a set of records (for viewing) and in the same motion
> DELETE any that show up.
>
> Can it be done?
You can't do it with one query.
--
For technical support contracts
Lawrence,
if you use MySQL-4.1.1, and specify
innodb_file_per_table
in my.cnf, then InnoDB places each table into its own .ibd file. That is a
way to free the disk space to the OS if you drop a table.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and
On Fri, 30 Jan 2004 [EMAIL PROTECTED] wrote:
> >Description:
> When creating a table, mysql 5.0.0-alpha (binary package)
> does not accept column name 'Found'.
>
> >How-To-Repeat:
> create table log (Found INT UNSIGNED NOT NULL);
>
FOUND is a reserved word. Use within backticks, ie `Found`
http
Hi,
Is there any sample code available for MYSQL thread safe client using C
API?
Thanks in advance,
Ram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>Description:
When creating a table, mysql 5.0.0-alpha (binary package)
does not accept column name 'Found'.
>How-To-Repeat:
create table log (Found INT UNSIGNED NOT NULL);
>Fix:
Other names of column work.
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization:
>MySQL support:
but can I set multiple "default character set" options to
multiple character sets (EUC-JP, EUC-KR, and ISO-8859-1) rather then just
one.
No, just one in 4.0.x. You have to use 4.1.x for multiple character sets.
_
Let the new MSN Prem
77 matches
Mail list logo
