Gleb,
thanks for your response, but that doesn't help me much because I'm using
ADO components to connect to MySQL and not MySQL API functions.
Regards,
Dusan Pavlica
- Original Message -
From: Gleb Paharenko [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, February 23, 2005
Greg,
- Original Message -
From: Greg Whalin [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 24, 2005 12:04 AM
Subject: Innodb - raw partition vs filesystem store?
What are pros/cons as far as performance, reliability, and ease of
backup/restore?
Anyone
Hi,
I have the following problem, I'm converting from version 3.23.53 to
4.1.9
The following query was used
SELECT * FROM news WHERE languages_id = 'english' AND expiry_ts =
CURDATE() AND FCode = '999' AND DCode = 'Z999' ORDER by id DESC LIMIT 0,
3
it work perfectly on the version 3.23.53 (the
Hi Mark,
Thank you for your help.
I have the same problem when I execute the query with the MySQL client on my
AIX server :
mysql select sum(AMFTPF) from DWH_AMF;
+-+
| sum(AMFTPF) |
+-+
|12000,00 |
+-+
1 row in set (0,03 sec)
The problem occurs only
Hi,
I'm looking for an older version of the ODBC connector, the 3.51.06
version for windows, but I could not get a hand on it.
I'v been there :
http://downloads.mysql.com/archives.php?p=myodbc-3.51
but no luck at all.
Any chance someone could point me in the right direction ?
Thanks,
--
Philippe
Hi,
Have you try google ?
http://www.google.fr/search?hl=frq=storing+image+in+mysqlbtnG=Recherche+Googlemeta=
I see pretty much a lot of stuff there ;)
btw, storing image in a table in considering a bad practice, let the
filesystem handle it it does it more efficiently. I would suggesdt to
write
Hi list,
I'm trying to figure out how to use the exact phrase search in
fulltext boolean mode when the phease to search includes double
quotes.
For instance, what if I want to search this exact phrase :
I like football on TV
I think I've tried all the solution I'm aware of without any results.
Hiya,
I've been trying to find out about this for a few days, but can't seam
to find much information about it on the web.
At the moment I've got a few tables, one of this looks like:
CREATE TABLE `news` (
`section` TINYINT UNSIGNED ZEROFILL NOT NULL,
`article` SMALLINT(4) NOT NULL
Hello,
Full-Text in MySQL 4.1 allows you to calculate a row score using
full-text search and calculation from the same table as the full-text.
For example:
SELECT A.field1,B.field2,B.field3,
MATCH(B.name,B.description) AGAINST('Hello World' IN BOOLEAN
MODE)+10*B.field2-5*B.field3 AS
Hi,
How to read a text type field from the data base. By simple
select I am not able to see the whole data at a time. Please advise me
here.
Thanks,
Narasimha
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 23, 2005 9:06 PM
To:
Hi
this is the error message you get when trying to access mysql from php
using a userid which has been created under mysql 4.1 whithout taking
the precaution to apply the old_password function to create the password:
Client does not support authentication protocol requested
by server; consider
I finally found the solution.
It's possible to set everything in MySQL ODBC/Connector on tab Connect
options. I had to write to the field Initial Statement statement SET NAMES
'wanted_character_set' and that solved the problem.
Dusan
- Original Message -
From: Duan Pavlica [EMAIL
Many data centers do not allow customers to install their own UPS
inside the rack.
The questions is not whether they have (wish to have, can afford etc ) UPS or
not,
or if the OS is buggy ( fsync() function or others ),
the problem is the database management system failed to ensure
data
Hi,
which privileges i have to grant such a user, except grant option and the
privileges such new users created by this user will have? Are there any side
effects, for example, that this new user creating user also can delete other
users? Thanx.
--
MySQL General Mailing List
For list
Hi,
is there a possibillity in mysql to send periodically queries to a database,
for example all 5 minutes? Or, a liitle bit off topic, is there a
possibility to this via php? Or, is it normally possible to set up such a
query via cron tab (unix based web servers only)? Thanx.
--
MySQL
- Original Message -
From: Peter PeterDresden [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 24, 2005 8:05 AM
Subject: How to send queries to a database periodically
Hi,
is there a possibillity in mysql to send periodically queries to a
database,
for example
[snip]
is there a possibillity in mysql to send periodically queries to a
database,
for example all 5 minutes? Or, a liitle bit off topic, is there a
possibility to this via php? Or, is it normally possible to set up such
a
query via cron tab (unix based web servers only)? Thanx.
[/snip]
Yes,
Where can I find cron for Windows? That will make my life a whole lot better!
On Thu, 24 Feb 2005 08:14:13 -0500, Rhino [EMAIL PROTECTED] wrote:
- Original Message -
From: Peter PeterDresden [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, February 24, 2005 8:05 AM
[snip]
Where can I find cron for Windows? That will make my life a whole lot
better!
[/snip]
It is called Task Scheduler
http://www.iopus.com/guides/winscheduler.htm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
SQLyog (www.webyog.com) has an option called SQLyog
Notification Services. It can execute a set of queries
and even send you the report over email.
Using this you can schedule it to run a set of queries
anytime you want.
Karam
--- Peter PeterDresden [EMAIL PROTECTED]
wrote:
Hi,
is there a
On Thu, Feb 24, 2005 at 02:38:46PM +0200, DebugasRu [EMAIL PROTECTED] wrote:
Probably fsync() had failed to flush some part of a 16 kB page to
disk.
so what ? one of trade-offs would be to re-read the data from the disk
and compare it with what it should be (another copy on the disk) and
5.0.2 has a huge bug, you cant use most gui's with it
so all command line
5.0.3 fixes, but I cant get it to compile on vc++ 6.0 always errors out :(
most say use 5.0.1, but that's got a ton of bugs that 5.0.2 fixed
we are patiently waiting for 5.0.3 so we can test out stored procedures
--
MySQL
Rich Lafferty wrote:
On Thu, Feb 24, 2005 at 02:38:46PM +0200, DebugasRu [EMAIL PROTECTED] wrote:
Probably fsync() had failed to flush some part of a 16 kB page to
disk.
so what ? one of trade-offs would be to re-read the data from the disk
and compare it with what it should be (another copy on
Hi,
I just fresh install mysql4.1 in Redhat9.0.
I have another MySQL5.0 installed in FreeBSD5.3, and just tried to copy
all data in /var/db/mysql/ from FreeBSD5.3 to /var/db/mysql/data/ in
Redhat9.0.
After finished copied the data over to Redhat, MySQL4.1 can't start. The
DB data in MySQL5.0 in
On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin [EMAIL PROTECTED] wrote:
Exactly. No ACID database can ensure integerity in such a situation.
Postgres, Oracle, or any other transactional DB would have suffered the
same fate in these two cases (LiveJournal, Wiki).
FWIW, my
sam wun wrote:
Hi,
I just fresh install mysql4.1 in Redhat9.0.
I have another MySQL5.0 installed in FreeBSD5.3, and just tried to
copy all data in /var/db/mysql/ from FreeBSD5.3 to /var/db/mysql/data/
in Redhat9.0.
After finished copied the data over to Redhat, MySQL4.1 can't start.
The DB data
Heikki Tuuri wrote:
A journaling file system like ReiserFS does not help if fsync does not
work. A journaling file system itself is actually a bit like a
transactional database. A broken fsync might cause bad damage there.
I would be happy if users tested the 'pull-the-plug' performance of
Rich Lafferty wrote:
On Thu, Feb 24, 2005 at 09:10:32AM -0500, Greg Whalin [EMAIL PROTECTED] wrote:
Exactly. No ACID database can ensure integerity in such a situation.
Postgres, Oracle, or any other transactional DB would have suffered the
same fate in these two cases (LiveJournal, Wiki).
I asked for help with a version of this query a few months
ago, and subsequently made some improvements to it, and also
fooled around with other parts of my app that were in need of
tuning. I've since done some more extensive benchmarking and
realized that this query really is somewhat slow. Even
On 24 Feb 2005 at 12:50, schlubediwup wrote:
Hi
this is the error message you get when trying to access mysql from php
using a userid which has been created under mysql 4.1 whithout taking
the precaution to apply the old_password function to create the password:
Client does not support
Hello list,
We are currently tuning our queries speed and we found out that the
ones using subqueries are quite slower than the 'usual' ones. Here is
an example of a wierd behavior.
We have a city list associated with zipcode, and user can search a
database of people living in a given city. The
It appears you can't combine an insert-select with an on-duplicate-key-update.
I would find it very useful if you *could* do this. I know it would be
complicate how you would handle the syntax for what to do when you hit
a duplicate key, could do this: update all the columns that are *not*
At least this mailing list has progressed beyond Why didn't they have
a UPS?, I suppose. :-)
Yes that was my primary intend :)
I'd really like people to care more about their data safety and more
awareness about the problems involved.
That didn't get rid of the race condition, it just moved
Hello All,
Here is a problem I have been trying to debug for a few days. I had a mysql
server running for about a month. I did a mysql dump of all the tables on the
master and setup a second machine to be the slave, loading all the tables. I
set the replication stuff up in the slave my.cnf.
Tom Cunningham [EMAIL PROTECTED] wrote on 02/24/2005 11:31:31 AM:
It appears you can't combine an insert-select with an
on-duplicate-key-update.
I would find it very useful if you *could* do this. I know it would be
complicate how you would handle the syntax for what to do when you hit
a
On Thu, 24 Feb 2005, Chris Aitken (The Web Hub) wrote:
Hi all,
I have just created a databased website that is working with a fairly large
number of records (well, 10 million records is the biggest database ive
ever worked on so far) but also have a large number of searches of these
Thanks guys! I did follow the procedure, but somewhere during the first
and second attempt I mucked it up. Followed the directions slowly and
carefully a third time and we are up and running. Thanks for your help!
Kelly
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
Hello,
I have downloaded Toad for MySQL to give it a test run. MySQL 4.1.10 is
on Redhat AS 2.1 and Toad for MySQL is on Win XP. Everytime I attempt to
connect via Toad, I get the following error:
Unable to connect to the database.
Host 'XX.XX.XX.XX' is not allowed to connect to this MySQL
Someone sent me the following comments on one of my
webpages:
Global Statistics
Total HTTP Requests: 51
Total Size: 133537 bytes
Object Size Totals
Object type Size (bytes)
HTML: 26538
Images: 69020
Javascript: 12863
CSS: 25116
Multimedia: 0
[snip]
Total Size: 133537 bytes
HTML: 26538
Images: 69020
Javascript: 12863
CSS: 25116
Multimedia: 0
Other: 0
[/snip]
It's all right there and has nothing to do with your database.
--
MySQL General Mailing List
For list archives:
Good good.
On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker [EMAIL PROTECTED]
What version of MySQL are you using? 4.1.1 uses an enhanced password
hashing system that isn't compatible with clients built for older
versions.
This page on
At 05:59 AM 25/02/2005, Atle Veka wrote:
packs it in? Do you mean like you say that sendmail actually crashes
when load goes above 5? I would guess sendmail is rather throttling itself
and that you are seeing log messages about sendmail refusing connections.
Is this a correct assumption? Sendmail
Oops, I guess I added wrong.
Nevertheless, unrestricted linking to database tables
with no keys would increase loading time, right? Is
there some way to gauge the effect, other than
tweaking all my scripts and tables and checking the
load time again?
Thanks.
--- Jay Blanchard
[EMAIL PROTECTED]
On Fri, 25 Feb 2005, Chris Aitken (The Web Hub) wrote:
Its highly possible as this is the first database ive had to use with a
large number of records. I shall look into indexing part of databasing now.
Any suggested places to start that explains it helpfully ?
One way to do it, would be to
Hi,
You may put indexes on the following fields:
1. cityname (in tblcity)
2. zip (in tblpeople)
I assume it will speed up your queries. If you already do have those
indexes, then try to look at the 'EXPLAIN' of the first query (with
sub-query), and see the column 'type' that describes you how
Say a row is inserted into a table with an auto_increment column and then
deleted before another record is inserted. When a new row is inserted,
will the value of the auto_increment column be the same as the deleted
record's, or will it be one greater?
--
MySQL General Mailing List
For list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
LAFONTAINE Julien - LYO wrote:
Hi Mark,
Thank you for your help.
I have the same problem when I execute the query with the MySQL client on my
AIX server :
mysql select sum(AMFTPF) from DWH_AMF;
+-+
| sum(AMFTPF) |
Jim McAtee wrote:
Say a row is inserted into a table with an auto_increment column and
then deleted before another record is inserted. When a new row is
inserted, will the value of the auto_increment column be the same as
the deleted record's, or will it be one greater?
Greater.
--
Daniel
David Blomstrom [EMAIL PROTECTED] wrote on 02/24/2005 04:10:17
PM:
Oops, I guess I added wrong.
Nevertheless, unrestricted linking to database tables
with no keys would increase loading time, right? Is
there some way to gauge the effect, other than
tweaking all my scripts and tables and
Jim McAtee [EMAIL PROTECTED] wrote on 02/24/2005 04:50:11 PM:
Say a row is inserted into a table with an auto_increment column and
then
deleted before another record is inserted. When a new row is inserted,
will the value of the auto_increment column be the same as the deleted
record's,
The reason I asked about auto_increment behavior is that I'm looking at
the output from mysqldump --opt and there are no commands to preserve/set
the auto_increment value. Is there a mysqldump option to do this? Or
will restoring from a dump always leave the auto_increment value one
greater
I am new to MySql. I have a query with a subselect that is running
very slow (28 seconds).
SELECT *,MATCH(title, descr_part) AGAINST (Project Manager IN
BOOLEAN MODE) AS score
FROM listings
WHERE MATCH(title, descr_part) AGAINST (Project Manager IN BOOLEAN MODE )
and zip in
(SELECT
hi,
just want to know the main benefits of mysql over postgresql.
thanks,
Payam Shabanian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what is the latest GPL licensed version of mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I just wanted to know if there is a special reason for the
mathematically incorrect implementation of the modulo-operation in mysql.
Using a correct modulo operation on a negative number would still result
in a positive number:
-1 % 2 == 1 (mysql: -1)
-5 % 3 == 1 (mysql: -2)
-1 % 4 == 3
I have an IN() list of 107 IDs (PK) out of about 6000 possible.
I do this query and I get 105 rows back.
I want to know which two [107 - 105 = 2] of the IDs in the IN() list are
absent?
# 105 rows
SELECT count(*)
FROM mytable
WHERE id IN (11704, 10144, 11842, 11299, 11192, 11563, 11378,
My bad. As it turns out, there are duplicates in the IN() listing. It must
be that mysql 'uniques' the list before operating on it.
-Original Message-
From: Daevid Vincent [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 24, 2005 5:14 PM
To: mysql@lists.mysql.com
Subject: Is
Now I'm really confused. I decided to just brute force this while I waited
for a real answer. I threw in a couple test numbers I knew would fail
555 and 6. How come none of the values aside from the two I threw in
for good measure are failing?! Is there something broken with IN() on
58 matches
Mail list logo
