Indexing in MySQL.
If while indexing a table I retrieve data from same table the indexing
process seems to get stuck. Mytop keeps saying something about
repairing keycache for days when the indexing shouldn't take more than
a couple of hours.
Can someone please explain!
--
to whom it may concern,
I need some help regarding transactions using innodb tables.
I am running MySQL 3.23.51-Max as database server and developing a web
front-end using ASP. Many of the tables used are of innodb format since it
is imperative for me to use transactions in most of my scripts.
Hi Alec-
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
The example is actually given in the MySQL manual itself (section 1.7.4.1).
[EMAIL PROTECTED] wrote:
I am trying to check a table to see if a value doesnt exist,
There is one particular program that can dump an SQL Server database as
SQL statements much like mysqldump--its called SqlDump and it is
available from http://sqldump.sourceforge.net.
Ask your client to use it to give you the SQL file.
NOTE: the SQL stmts may be very much SQL Server specific
Hi,
I need to set a variable limit on the MySQL file size (Average row
length * no of rows )
When we insert data in to the table using JDBC .i should get a
unique JDBC exception (so that i trigger an archive).
Is this posible in MySQL?
I notice that during creation of table i can give such
Hi!
On Mar 12, Mathias Berchtold wrote:
MATCH / AGAINST fatal bug
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
RAM: 1GB Apacer
Free Disk Space: 32GB
HD Write Back Cache: Disabled
Under some circumstances the following query does never terminate. The
* Peter D Bethke
Ok, in regards to my previous dilemma, I've gotten it to:
SELECT
golf_pick_periods.id,
golf_pick_periods.period_name,
golf_pick_periods.period_start_date,
golf_pick_periods.period_end_date,
COUNT(DISTINCT golf_events.id) AS num_events,
Yba
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 2:14 PM
To: Yaron Ben-Arieh
Subject: Re: When is MySQL 4.1 going to have its binary download available?
Your message cannot be posted because it appears to be either spam or
I have a query that populates a dropdwon select which then posts to another
form with a selected query
I don't want to diplay the dropdwon in the next form but want to keep the query.
Is it possible to justcombine the two queries . The reson for this is that the
2nd dropdown is populated by the
Hi,
I've installed MySQL 3.23.55 on Windows 2000 and I am trying to run the mysqld service
as a user account rather than the local system account. This worked fine in 3.23.43
but has stopped working since the upgrade.
The error I get is 2186, which seems to be service failing to respond to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Carlsson wrote:
Thanks, that solved the problem. I thought that I could have my own
fetch-size but I has now understood that Integer.MIN_VALUE is the only size
that is accepted.
Regards
Roland Carlsson
The fetch-size setting makes sense for
Hi,
What is the minimum hardware requirements of MySQL Database. Apart from the
size of the database. I am looking for limitations like
- RAM,
-Installation Space (per instance).
etc.
Please do let me know at the earliest.
Thanks Regards,
Prashant Kumar Gupta,
HP-High Availability Team,
'Back in the day', I've run MySQL on an Intel 386 with as little as 4MB of
RAM under Linux. Base disk space can be extremely minimal as well.
Cheers,
-Dana
-Original Message-
From: Prashant [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 7:19 AM
To: MySQL (E-mail)
Cc:
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the time correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only appear
to be able to handle datetime objects, not date
Hi List,
I'm a newby at MySql. I've setup a server for use with Bugzilla but I am
also trying to connect to an other database on that server. Each time as I
try to connect I get
ERROR 2013: Lost connection to MySQL server during query.
Is there a setting I must change to be allowed to logon
Gopalarathnam V. wrote:
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
Too restrictive -- the original poster, Phil Dowson, wanted to find all
t1 rows except those that have t2.t2gid = 194 (or some other t2gid value).
The
Hi.
On Wed 2003-03-12 at 14:39:26 +0200, [EMAIL PROTECTED] wrote:
Hi,
I do not know how to compile, but I sure want to try the new features of
4.1.
There is no date yet for the first binary release of 4.1. They will
publish such an alpha release when they consider it mature enough for
general
Description:
MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
when formatting error messages: the code just assumes that no message
will ever be larger than SC_MAXWIDTH (256), ERRMSGSIZE (SC_MAXWIDTH)
or MYSQL_ERRMSG_SIZE (200). This has been observed to lead to memory
Hi,
I just tried the below:
create table virus (
n int auto_increment not null,
name char(128) not null,
primary key(n),
unique(name(100))
);
with a data file that has 122,111 sql commands like:
replace into virus values(NULL,VBS/LoveLet-E);
replace into virus
Just saw the following code in the MySQL 2.23.55 source code.
The semi-colon after the if renders the if statement useless. Could someone explain if
it is intentional. The comment indicates that it is.
Simon
/*
the following 'if', thought conceptually wrong,
is a useful
Hi,
Update: I just did a grep:
grep 375707 Query c01*.log
of the log file and did a grep of VBS/LoveLet-G on the out put file
and got 123 entries, what I expected. But, the dump shows 111,009
in the 'n' field. This is starting to look like a bug in mysql 3.23.49?
Any ideas?
Thanks,
Cheers,
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT NULL default '0',
`CourseNo` float NOT
Bob Ramsey schrieb:
At 04:10 PM 3/11/2003, [EMAIL PROTECTED] wrote:
m$office (office 2000 - win xp) can not handle the time correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
I believe that's a known problem with Microsoft products. They only
appear to be able to handle
extra_configs=$extra_configs --with-innodb --with-berkeley-db \
--with-embedded-server --enable-thread-safe-client \
--with-bencgh --prefix=/usr --enable-maintainer-mode \
--with-docs --with-unix-socket=/var/run/mysqld/mysqld.sock \
--with-lo-memory --with-openssl --with-vio
It
If I understand correctly, you are trying to grep the SQL data file. This
is emphatically not a valid thing to do. The data file is *not* a
representation of the table displayed when you SELECT * from it. For a
start, if you have deleted records and not overwritten them, the blank
space will
Hi,
I might not have worded things the best. I did not grep the sql db,
but the output from mysqldump. I only grep'ed on plain text files:
1) mysqldump output
2) grep the input sql file that has 'replace into...' (see below)
3) the log file for mysql, which is plain text (see my follow-up email)
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do it, they are mysql \s, mysql status.
Could you (or someone)
[filter fodder = sql,query,queries,smallint]
mysql select database();
David
**
Jonathan said:
**
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any
At 9:21 -0500 3/12/03, Luc Foisy wrote:
Perhaps one day UNION will be added to UPDATE
You'd still have to name every column to be updated explicitly.
There is no update whatever column happens to contain this value
syntax.
At 11:01 -0800 3/11/03, Keith Roberts wrote:
I need to look in several
select database();
Regards,
Joseph Bueno
Jonathan Li wrote:
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do
Hi,
I understood replace to only increment n when it matches the
name value. There are 122,111 statements, but when you add
up the numbers in the n column, they exceed 122,111. They should
sum up (when you add all them up including the ones I did not
show) to 122,111. If you add up the ones I
At 11:29 -0500 3/12/03, Tamayo, Nelson wrote:
Is there a way to convert an Access database into MySQL easily?
I am running into problems trying to convert it through VB code using a
recordset. I'm rather new at this stuff. I'm also tried generating an insert
statement through VB code and then
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
[filter fodder = sql,query,queries,smallint ]
you haven't indicated what the column attributes are,
but you might try putting quotes around the TRUE and FALSE
values ( assuming they are being inserted into char or varchar
columns).
David
Hi!
thanks for your response.
I found my mistake, you pointed me to the right direction.
Although I provide different pcbLength buffers for the parameters, I did not
initialize the second one.
ODBC documentation says, that it will be ignored on integer columns if its
not SQL_NULL_DATA.
But I
On 12 Mar 2003, at 10:22, Douglas B. Jones wrote:
INSERT INTO virus VALUES (91207,'VBS/Kakworm');
INSERT INTO virus VALUES (117623,'VBS/Redlof-A');
As you can see, the numbers (n field) are way to high? Is this a bug
in mysql or n the sql?
It's far more likely to be a bug in your
On Tuesday 11 March 2003 19:06, Luc Bui (PAC) wrote:
when can I get the binariesfor 4.1?
Probably in 2-3 weeks ..
do 4.0.11a support views?
Nope.
important for my choice for my community.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
On Tuesday 11 March 2003 16:23, zby at post dot cz wrote:
/usr/sbin/mysqld-max --version
/usr/sbin/mysqld-max Ver 4.0.11-gamma-Max for pc-linux on i686
Downloaded and installed:
MySQL-client-4.0.11-0
MySQL-shared-4.0.11-0
MySQL-Max-4.0.11-0
MySQL-devel-4.0.11-0
MySQL-server-4.0.11-0
On Wednesday 12 March 2003 02:30, Heo Jungsu wrote:
What do you mean could not execute a query on those tables?
Could you be more detailed?
Ok. let me explain.
When I was using MySQL 4.0.10,
After I add columns with ALTER TABLE on foreign key referencing table so
many times,
when I
On Wednesday 12 March 2003 18:25, Jonathan Li wrote:
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do
On Tuesday 11 March 2003 18:57, vlady wrote:
I am trying to set up a replication ignoring a given database, but
unfortunatly it doesn't works (for me).
In my.cnf of my master I have at the end :
log-bin
server-id= 1
binlog-ignore-db=access
The line: binlog-ignore-db=access is
Hi,
No questions that my understanding of sql is limited. I am
not an expert. I think I have misunderstood the replace statement.
Thanks,
Cheers,
Douglas
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:46 AM
To: [EMAIL PROTECTED]
Cc:
Hi,
I need to get the time/date (ie. 1 day 12 hours 11 min 4sec) between 2 time
dates.
Can't seem to find any of these functions in the Mysql manual. The nearest
was Period_diff() which is calculating months elapsed.
Thanks
Nyon
---
Outgoing mail is certified Virus Free.
Checked by AVG
Tamayo, Nelson wrote:
Is there a way to convert an Access database into MySQL easily?
I am running into problems trying to convert it through VB code using a
recordset. I'm rather new at this stuff. I'm also tried generating an insert
statement through VB code and then executing it, I get
I currently have a table that contains a timestamp(6) column. I need to
copy the data in that column to a new table with the column structure as
timestamp(14), what is the best way to do it (now that the timestamp
structure is changed)?
Thanks
Jonathan
--- ignore below
query
sql
---
At 11:41 -0500 3/12/03, Douglas B. Jones wrote:
Hi,
I understood replace to only increment n when it matches the
name value. There are 122,111 statements, but when you add
up the numbers in the n column, they exceed 122,111. They should
I don't know what you're trying to say here. If you *add
Hi,
If you want to get 3,1,1 instead of 3,4,5, you should declare
your table this way:
create table virus (
n int auto_increment not null,
name char(128) not null,
primary key(name,n),
unique(name(100))
);
You can find a very good example in the manual:
At 11:45 -0500 3/12/03, Keith C. Ivey wrote:
On 12 Mar 2003, at 10:22, Douglas B. Jones wrote:
INSERT INTO virus VALUES (91207,'VBS/Kakworm');
INSERT INTO virus VALUES (117623,'VBS/Redlof-A');
As you can see, the numbers (n field) are way to high? Is this a bug
in mysql or n the sql?
It's far
I could not start ./safte_mysql.
Error message:
touch: /usr/local/mysql/var/gemini.err cannot create
chown: /usr/local/mysql/var/gemini.err: No such file or directory
Starting mysqld daemon with databases from /usr/local/mysql/var
./safe_mysqld: /usr/local/mysql/var/gemini.err: cannot create
So I
On 12 Mar 2003, at 11:41, Douglas B. Jones wrote:
INSERT INTO virus VALUES (3,'VBS/LoveLet-E');
INSERT INTO virus VALUES (4,'VBS/LoveLet-G');
INSERT INTO virus VALUES (5,'WM97/Myna-C');
I would have expected 3,4,5 to be 3,1,1. I was expecting it to start
from zero each time it got a new
Hi!
On Mar 12, Simont Tyler wrote:
Just saw the following code in the MySQL 2.23.55 source code.
The semi-colon after the if renders the if statement useless. Could
someone explain if it is intentional. The comment indicates that it
is.
Simon
/*
the following 'if', thought
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS on SLAVE return SLAVE:running
SHOW PROCESSLIST on SLAVE return reconnecting after
At 12:07 -0500 3/12/03, Jonathan Li wrote:
I currently have a table that contains a timestamp(6) column. I need to
copy the data in that column to a new table with the column structure as
timestamp(14), what is the best way to do it (now that the timestamp
structure is changed)?
That doesn't
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 11:33 AM
To: Luc Foisy; MYSQL-List (E-mail)
Subject: RE: Is there any way to search a whole database for a value?
At 9:21 -0500 3/12/03, Luc Foisy wrote:
Perhaps one day UNION will
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I found a great article by Joe O'Donnell called Building A Dynamic MySql
Paging Class with PHP ... I created his example and it worked fine.
Then I
On Wed 2003-03-12 at 11:16:09 -0600, [EMAIL PROTECTED] wrote:
At 11:41 -0500 3/12/03, Douglas B. Jones wrote:
Hi,
I understood replace to only increment n when it matches the
name value.
In that case, you want a primary key on (name,n) with n being
auto_increment.
There are 122,111
You have to show us.
Steve Holt wrote:
I am sure I am missing something very simple but I cant see it
I am using MS Access 97 as a front end to MYSQL
I have a table with the following desc
CREATE TABLE `tblcoursesoffered` (
`DateCourseCreated` datetime default NULL,
`Specialty` int(25) NOT
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
Hi! I'm trying to install mysql on a RISC-6000 box running AIX 4.3. When
I type './mysql' I get the following error:
# ./mysql
Could not load program ./mysql:
Dependent module libz.a(shr.o) could not be loaded.
Could not load module libz.a(shr.o).
Error was: No such file or directory
Does
Hi all,
I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL
as a JDBC Provider for Entity Beans (EJBs). The configuration is not
anything like servlet config where you throw the MM driver in the
WEB-INF/lib directory.
I haven't been able to find any indication that anyone
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Garth Dahlstrom wrote:
Hi all,
I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL
as a JDBC Provider for Entity Beans (EJBs). The configuration is not
anything like servlet config where you throw the MM driver in the
WEB-INF/lib
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
hi dude yeh u have to append the page query to the current query ,
here is an example of my db class
http://electroteque.dyndns.org:1023/benchmark/DB.phps
down the page is the pagination u want in particular the url function
-Original Message-
From: Stitchin' [mailto:[EMAIL PROTECTED]
I've recently upgraded to 4.0.11 (4.0.11-0 rpm) on RedHat 8.0. I've had
replication running before, and now it's giving me trouble.
slave start fails with the following error
Could not initialize master info structure, check permisions on
master.info
I've checked the file permissions, and they
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Adam Dzieciatko
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
HELP! I'm getting the following error:
--
Error (SQL):
SELECT date, subject, location, private, id, duration, dategroup_id,
COUNT(DISTINCT subject) AS appointment_count, inituserid FROM mgw_calendar
WHERE userid=1 AND SUBSTRING(date,1,8) = '20030312' GROUP BY date, subject,
location
) = '20030312' GROUP BY date, subject,
location, private, id, duration, dategroup_id, inituserid ORDER BY date
Error (MSG):
You have an error in your SQL syntax near 'DISTINCT subject) AS
appointment_count, inituserid FROM mgw_calendar WHERE useri' at line 1
---
I'm using MySQL 3.22.32
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-1.22.10-1
perl-5-5.0050
and binary
At 17:04 -0500 3/12/03, Slawomir Orlowski wrote:
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/mysql.sock
and rpm packages:
perl-DBI-1.13-1,
Hi,
I jusr downloaded the latest release of mySQL server
in RPM for Linux and when i've installed it i found
that some tools such as mysqladmin are mising...Any
suggestions?
Thank you,Andrey
__
Do you Yahoo!?
Yahoo! Web Hosting - establish your
Hi all, I am having a little UPDATE syntax issue. According to the manual
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATION_ID = IMPORT_USERS.REP_LOCATION_ID,
EBA_USERS.REP_FIRST_NAME = IMPORT_USERS.REP_FIRST_NAME,
EBA_USERS.REP_LAST_NAME =
At 14:29 -0800 3/12/03, Andrey wrote:
Hi,
I jusr downloaded the latest release of mySQL server
in RPM for Linux and when i've installed it i found
that some tools such as mysqladmin are mising...Any
suggestions?
The server RPM doesn't include them. You need to install
the client RPM as well.
At 8:33 +1000 3/13/03, MySQL wrote:
Hi all, I am having a little UPDATE syntax issue. According to the manual
According to the manual, this won't work until MySQL 4.x
UPDATE EBA_USERS, IMPORT_USERS
SET EBA_USERS.HUB_ID = IMPORT_USERS.HUB_ID,
EBA_USERS.REP_LOCATION_ID =
http://mindforums.com/forums/showthread.php?threadid=82
Per this thread I started to set up the two way replication as stated and
reached a point where I had/have a question about binary logging. How and
what does binary logging keep track of. I know that it keeps track of
changes made to
That explains it then D'OH
Is there a workaround?
Thanks :-)
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 9:02 AM
Subject: Re: UPDATE syntax help
At 8:33 +1000 3/13/03, MySQL wrote:
Hi
At 9:45 +1000 3/13/03, JJ wrote:
That explains it then D'OH
Is there a workaround?
Thanks :-)
One way is to use a script that issues a join to figure out which
records to update, then constructs the appropriate UPDATE statements.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
Paul,
You have to use the results of one select to generate lots of update
statements. If you execute all these from your program, make sure you use a
different database connection for the updates, if you're keeping a results
set open.
Alternatively, if it's a one off, generate a script file
Thanks...
Currently I am doing exactly that. One data set open creating another. I
was trying to speed the process up, although I am only dealing with 20,000
records so shouldn't complain. Thanks all for the suggestions... I look
forward to 4.x
JJ
- Original Message -
From: Andy
Hello,
I've been running mysqld-nt on W2K and WinXP for awhile now (using
MyISAM tables) and I'm a bit confused by what's in the max binary. Is
the biggest difference InnoDB tables?
Thank you,
Dan Cumpian
-
Before posting,
I have installed 4.0.9 from source.
After compiling it I want to start it with
/usr/local/mysql/bin/mysqld_safe --user=mysql
and the message mysqld ended appears.
When I move the startup script to the appropriate directory and reboot
I get the following error
Can't execute
Hi All,
I am running MySQL 4.0.11a on Win2k Pro at home. The machine is connected
to a router which redirect port 3306 to MySQL. Things seem to work very
well. I have MySQLCC and MySQL-Front both connecting to MySQL locally and
remotely. However, when I try connecting through telnet locally
In the last episode (Mar 12), Tam, Michael said:
I am running MySQL 4.0.11a on Win2k Pro at home. The machine is
connected to a router which redirect port 3306 to MySQL. Things seem
to work very well. I have MySQLCC and MySQL-Front both connecting to
MySQL locally and remotely. However,
Hello,
I apologize if this topic has been discussed in the past. I am just looking
for feedback whether to use Datetime or Unixtime (32 bit Int) for my
timestamps. From what I can tell here are the advantages and disavantages
of each method:
Unixtime (stored as 32bit int):
advantages:
-
On Wed, Mar 12, 2003 at 10:25:11PM -0700, Jason Brothers wrote:
I apologize if this topic has been discussed in the past. I am just looking
for feedback whether to use Datetime or Unixtime (32 bit Int) for my
timestamps. From what I can tell here are the advantages and disavantages
of
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05IEV4
cCAkPGJyIC8+CldoeSBkaWQgd2UgZ2V0IGhlcmU/IDUgNiAxNDY8YnIgLz4KTGVmdG92ZXI6IOE8
Hi there - I have a database and I am using mysqlcc to admin the mysql
server.
At anyrate - when I am connected and I am trying to create a new table, and
I get the error:
Could not load Field Types. Please select the location of the Syntax File
in 'Options-General-Sql Editor' and re-open this
86 matches
Mail list logo