Yep - both the Win2k box and Linux box now identify each other by IP (access
control and any host references in code) - but the problem persists.
And yep again, I agree that the presence of windows is the other variable!
However, I don't see why it would be so slow to connect! Perhaps it's a
pecul
The PHP page that was being reported at being in error wasn't the one in
error.
Sorry for wasting everyone's bandwidth and time.
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our pa
Paul
I wanted to pre load keys into cache which is larger
than the total index size:
---
Reading table information for completion of table and
column names
You can turn off this feature to get a quicker startup
with -A
Welcome to the MySQL monitor. Com
I am talking a PHP+MySQL course at my local community college and
since this is the first time the course is being offered there are
some teething problems with the curriculum. I am posting this query
at the request of the instructor.
We are using a Linux Server and each Student has their own s
At 12:43 +0100 4/15/04, zzapper wrote:
Here's another rotter!
I searched UseNet and read that in MySQL you cannot have a sub-select,
That's old information. Subqueries are supported as of MySQL 4.1.
You'll probably need some quotes around the values in your BETWEEN
expression, though.
but I'm lo
At 15:18 +0700 4/15/04, Hendro S. wrote:
Hi all,
I have win2k server machine, if this machine online, i could login
to MySQL 4.1.1 on RH 9 is about 1 second, but if this machine
offline connection establish in about 10 seconds, then i try connect
to mysql 4.0.17 in SuSe machine its done in abou
At 0:03 -0400 4/16/04, Mark Susol|Ultimate Creative Media wrote:
Did I really ask that tough a question? Anyone?
I'm not sure you're asking an answerable question. Consider this requirement
that you give below:
> So what do I need to do before running any backup scripts to ensure the
> tables wi
At 20:25 -0700 4/15/04, Haitao Jiang wrote:
Paul
Because I want to use the "load index into cache..."
to pre-load the indexes into cache. But I can not use
this feature since the block size of indexes are
different (1024 vs. 2048), and the "load index into
cache.." complains about it.
Any idea?
T
At 23:54 +0200 4/16/04, Rob Schuurman wrote:
Hi,
They might be threads of the same [mysqld] proces. Can you tell me how I can
verify that?
It depends on your operating system and the process-reporting tools.
For example, on Linux, ps typically reports each thread as a separate entry.
Mac OS X doe
At 17:22 -0400 4/16/04, Mike Morton wrote:
I have a table:
CREATE TABLE `moviehits` (
`title` varchar(5) NOT NULL default '',
`movie` varchar(4) NOT NULL default '',
`hit_date` datetime NOT NULL default '-00-00 00:00:00',
`ip` varchar(15) NOT NULL default '',
`listing_id` int(10) unsi
Okay, I got phpmyadmin back but
http://logd-test.joseph-a-nagy-jr.homelinux.org still is having problems
(click the link to see the problem) and I've gone through and commented out
the lines it refers to but then all I get is a blank page. So I copy a
fresh, untouched copy of dbwrapper.php to / for
Hi,
They might be threads of the same [mysqld] proces. Can you tell me how I can
verify that?
Additional information is that the system is not in production yet,
therefore there is no load yet.
My main problem is that the system is very slow and that I found out (via ps
command) that the 10 unix
On Fri, 2004-04-16 at 14:09, Dirk Bremer (NISC) wrote:
> - Original Message -
> From: "Victor Pendleton" <[EMAIL PROTECTED]>
> To: "'Dirk Bremer (NISC) '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, April 16, 2004 15:57
> Subject: RE: SQL Query Question
>
>
> > If your data
I have a table:
CREATE TABLE `moviehits` (
`title` varchar(5) NOT NULL default '',
`movie` varchar(4) NOT NULL default '',
`hit_date` datetime NOT NULL default '-00-00 00:00:00',
`ip` varchar(15) NOT NULL default '',
`listing_id` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
T
The only thing that changed in the environment was the creation of a script
that temporarily introduces a variable ($MP3) to be created and then
accessed by the script in question but the script doesn't touch mysql at
all. What could have changed so drastically as to kill access to the db so
comple
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Dirk Bremer (NISC) '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 15:57
Subject: RE: SQL Query Question
> If your data is stored in the following format
> 2004-04-16 00:00:00
> you can do WH
If your data is stored in the following format
2004-04-16 00:00:00
you can do WHERE queue_time = CURRENT_DATE() + 0
You will also be able to take advantage of an index.
Else, if you data is kept in the datetime format,
2004-04-16 15:53:27
one option is to do
WHERE DATE_FORMAT(queue_time, '%Y%
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Dirk Bremer (NISC) '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 15:06
Subject: RE: SQL Query Question
> WHERE queue_time = Now() + 0
> Are you wanting just the date or the datetime?
>
> --
That is excellent. I was not expecting such a good response.
So with the info you now provide I am right in saying that on each table
MySQL will only use 1 index, the one that the table analyzer chooses to
be the most suited. If I was to have a separate index, 1 on cat and 1 on
date it couldnt
you are probably missing privileges for accessing the database remotely...
try this page:
http://dev.mysql.com/doc/mysql/en/GRANT.html
it's like: grant all priviledges on dbname.* for [EMAIL PROTECTED]
identified by 'password';
good luck
dan
shatam bhattacharya wrote:
Hi all,
I have to im
WHERE queue_time = Now() + 0
Are you wanting just the date or the datetime?
-Original Message-
From: Dirk Bremer (NISC)
To: [EMAIL PROTECTED]
Sent: 4/16/04 2:54 PM
Subject: SQL Query Question
I have a simple table where one of the columns is named queue_time and
is
defined as a timestamp-
This works for Oracle, give it a try, use any format you want for the MM/DD/YY area.
select to_char(queue_time, 'MM/DD/YY');
Scott Purcell
-Original Message-
From: Dirk Bremer (NISC) [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 2:55 PM
To: [EMAIL PROTECTED]
Subject: SQL Quer
I have a simple table where one of the columns is named queue_time and is
defined as a timestamp-type. I would like to query this table for all rows
where the queue_time equals the current date. I an a newbie and have been
wrestling with the docs for a solution. You help will be appreciated.
Dirk
I would like to optimize the configuration settings
for this beast of a machine, here are the specs:
Quad Xeon 3ghz (4x2 = 8 cpus), 512 cache
16 gigs ram
running Redhat Enterprise 3.0 AS
All tables are InnoDB.
I read this warning in the MySQL documentation:
*Warning:* On GNU/Linux x86, you must be
alea> mysql -V
mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386)
but
mysql < SHOW VARIABLES LIKE "have_innodb";
+---+---+
| Variable_name | Value |
+---+---+
| have_innodb | NO|
+---+---+
1 row in set (0.09 sec)
why?
the gentoo eb
Two small corrections:
ad point 1.
"b in ('2004-05-01')" behaves different from "b = '2004-05-01'". The
last one is better: key_len = 6, instead of 3.
mysql> explain select count(*) from A, B where A.a=B.a and b ='2004-05-01';
+---+---+---+-+-+---+
I have 2 tables and 1 query. The problem is when I implement ORDER BY
p.date DESC it hits the wall.
I understand that MySQL is not the best at ORDER BY DESC so I am after
some tips on possible workarounds to avoid using ORDER BY DESC.
The site will list classifieds ads so I need to display them fro
Success with the bug entry. Nice system, too.
http://bugs.mysql.com/bug.php?id=3483
Thanks,
Don
Don MacAskill wrote:
This problem is completely repeatable, I'm not the only one having it,
and I've found a (temporary) workaround. I'm not sure if it affects
other machines than AMD64, but it
Thanks for the help! Worked perfectly.
Don
Paul DuBois <[EMAIL PROTECTED]> wrote:
At 10:01 -0700 4/16/04, Don Dachner wrote:
>Ok, that worked. Thanks.
>
>I guess now my only question is is there something wrong with my
>environment since I have to type:
>
>"./bin/mysql -u root"
>
>instead of
>
On Thu, 2004-04-15 at 22:27, Josh Endries wrote:
> When I was setting up the whitelist/blacklist stuff in webmail, I
> noticed it was adding two records for every one entry on the list
> (when I added [EMAIL PROTECTED], two would be put in the db). Deleting
> them also removed two, so I didn't n
This problem is completely repeatable, I'm not the only one having it,
and I've found a (temporary) workaround. I'm not sure if it affects
other machines than AMD64, but it certainly affects them. I've tested
on two now.
If you start MySQL with "skip-concurrent-insert", the problem completely
Try creating your tables as such:
CREATE TABLE test1(ser INT(5) NOT NULL,
age INT(2),
PRIMARY KEY (ser) )
TYPE=InnoDB;
CREATE TABLE test1(serno INT(5) NOT NULL,
name VARCHAR(20),
KEY 'idx_serno' (serno),
CONSTRAINT FOREIGN KEY(serno) REFERENCES `test1` (ser) )
TYPE=InnoDB;
-Original Me
Victor Pendleton wrote:
Which logs are you referring to? For you testing purposes, if you have not
already, I would enable the general log and see what is happening on the
MySQL side.
Thanks for the response. Sorry, I'm talking about the general log,
that is how I noticed that there were multiple
IF i run update statistics on MyISAM tables, will those tables lock while the
statistics are being updated. This is the first time i think i need to update
statistics on a production server, and i dont want to lock out my users for
any time.
There are about ten tables i'll need to run statistic
I creates 2 tables
create table test1(Ser int(5) primary key,age int(2)) type=InnoDB;
create table test2(Serno int(5) references test1(Ser),name varchar(20))
type=InnoDB;
I inserted a value in test2 and it accepted. Isnt that wrong? shouldnt it
accept only if there is a vlue in the first table
Thanks for the information.
-Original Message-
From: Paul DuBois
To: Victor Pendleton; '''Chen, Jenny ' ' '; [EMAIL PROTECTED]' ' ' '
Sent: 4/16/04 11:18 AM
Subject: RE: rename database
At 11:03 -0500 4/16/04, Victor Pendleton wrote:
>Paul,
>Do you know if there will be an
>ALTER DATA
Hi,
Is it possible to make a search for a word in a longtext column
from a InnoDB database?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I am using HIGH_PRIORITY in my SELECTs to force queries to take predcedence over
updating due to replication. I have recently implemented UNION in some of my queries
to optimize queries like "WHERE table1.column1=something OR
table1.column2=somethingelse".
Anyway, I first tried formatt
At 10:01 -0700 4/16/04, Don Dachner wrote:
Ok, that worked. Thanks.
I guess now my only question is is there something wrong with my
environment since I have to type:
"./bin/mysql -u root"
instead of
"mysql -u root"?
I don't know about "wrong", but that's certainly less convenient than it
need
At 12:44 -0400 4/16/04, [EMAIL PROTECTED] wrote:
at the mysql prompt i typed
show variable like "have_innodb";
and the value was "yes".
I saw this in the mailing list and tried it. I am not familiar with Innodb .
Do i have to install the Innodb version of Mysql? I have mysql 4.0 version.
That me
Ok, that worked. Thanks.
I guess now my only question is is there something wrong with my environment since I
have to type:
"./bin/mysql -u root"
instead of
"mysql -u root"?
Thanks,
Don
At 9:30 -0700 4/16/04, Don Dachner wrote:
>I ran ./bin/safe_mysqld &
>
>and got:
>
>[1] 3328
>
>ro
Hi
Here's a complicated bit sql that I'm trying to Post from MSAccess to
MySql
I searched UseNet and read that in MySQL you cannot have a sub-select,
but I'm lost as to how to split this into two selects?
Any help gratefully received!!!
SELECT distinct p.ProjectID ,p.ProjectName FROM tbl_project
At 9:30 -0700 4/16/04, Don Dachner wrote:
I ran ./bin/safe_mysqld &
and got:
[1] 3328
root # Starting mysqld daemon with databases from /usr/local/mysql/data
and the cursor hangs on the next line down ...
Your shell printed "root #". safe_mysqld (running in the background)
printed the Starti
Just by curiosity is there any difference between this 2 queries
select * from users where users_id=10
and
select * from users where users_id='10'
assuming that the users_id column is of type integer primary key (if it
would be varchat I know there is a big difference)
at the mysql prompt i typed
show variable like "have_innodb";
and the value was "yes".
I saw this in the mailing list and tried it. I am not familiar with Innodb .
Do i have to install the Innodb version of Mysql? I have mysql 4.0 version.
Liz
--
MySQL General Mailing List
For list archive
I ran ./bin/safe_mysqld &
and got:
[1] 3328
root # Starting mysqld daemon with databases from /usr/local/mysql/data
and the cursor hangs on the next line down ...
thanks,
don
Try ls to see whether safe_mysqld is in the directory and the run:
Safe_mysqld &
Note! You have to be root to
At 11:03 -0500 4/16/04, Victor Pendleton wrote:
Paul,
Do you know if there will be an
ALTER DATABASE RENAME curName TO newName
implementation?
I don't know. I agree it would be nice, though somewhat tricky.
One workaround is to use mysqldump to dump the database, create the new
database, reload t
At 18:57 +0530 4/16/04, Sahil Aggarwal wrote:
hi all,
i have select statements in my java code which are followed by updates
in my Innodb table.
the desired behaviour shud have been
check and then update
but because of tomcat accepting connections the above becomes
check check update update
i dont
Paul,
Do you know if there will be an
ALTER DATABASE RENAME curName TO newName
implementation?
-Original Message-
From: Victor Pendleton
To: 'Paul DuBois '; Victor Pendleton; ''Chen, Jenny ' ';
'''[EMAIL PROTECTED]' ' '
Sent: 4/16/04 10:55 AM
Subject: RE: rename database
Oversight on my
Oversight on my part. This will not work for those table types.
-Original Message-
From: Paul DuBois
To: Victor Pendleton; 'Chen, Jenny '; ''[EMAIL PROTECTED]' '
Sent: 4/16/04 10:43 AM
Subject: RE: rename database
At 10:28 -0500 4/16/04, Victor Pendleton wrote:
>You can rename it at the f
When I do a FLUSH LOGS my bin log does increment and a new one is created.
My query log does not behave this way, however. Just the bin log. It
creates files with the .00x extension where "x" is an incremental number.
Lou
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To:
At 10:28 -0500 4/16/04, Victor Pendleton wrote:
You can rename it at the filesystem level.
What if you have InnoDB or BDB tables?
-Original Message-
From: Chen, Jenny
To: '[EMAIL PROTECTED]'
Sent: 4/16/04 10:18 AM
Subject: rename database
Experts:
Is it possible to rename existing databa
I get an error when trying to reset password.
I start the db using:
mysqld_safe --skip-grant-tables &
and reset the pwd using the mysqladmin command...
below is the error message.
mysqladmin: unable to change password; error: 'Can't find any matching row in the user
table'
thanks,
--
MySQL Ge
Thanks that's easy.
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 10:28 AM
To: 'Chen, Jenny '; ''[EMAIL PROTECTED]' '
Subject: RE: rename database
You can rename it at the filesystem level.
-Original Message-
From: Chen, Jenny
T
Can you please post your DDL?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 4/16/04 10:22 AM
Subject: Foreign Keys
hi,
I am new to mysql. I am trying to create tables with foreign key
constraints.
but the constraintsdoesnt seem to be showing any effect on the ta
You can rename it at the filesystem level.
-Original Message-
From: Chen, Jenny
To: '[EMAIL PROTECTED]'
Sent: 4/16/04 10:18 AM
Subject: rename database
Experts:
Is it possible to rename existing database ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
> I am new to mysql. I am trying to create tables with foreign key
constraints.
> but the constraintsdoesnt seem to be showing any effect on the table. I am
> able to add any info in the foreign key table witout the same info in the
main
> table.
>
> what is the problem??
1) are you running t
hi,
I am new to mysql. I am trying to create tables with foreign key constraints.
but the constraintsdoesnt seem to be showing any effect on the table. I am
able to add any info in the foreign key table witout the same info in the main
table.
what is the problem??
Liza
--
MySQL General Mail
Experts:
Is it possible to rename existing database ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I reached a point I can't go any further with forcing mysql to use the
index as much as needed. I am facing a multi column index of which only
the first column is used.
Let me explain...
This works fine:
create table A ( a mediumint not null, b date not null, index (a,b));
Populate the
Which logs are you referring to? For you testing purposes, if you have not
already, I would enable the general log and see what is happening on the
MySQL side.
-Original Message-
From: Josh Endries
To: [EMAIL PROTECTED]
Sent: 4/15/04 9:27 PM
Subject: repeated/duplicated query problem
Hell
"Marvin Cummings" <[EMAIL PROTECTED]> wrote:
> This appears when I attempt to open phpMyAdmin. It doesn't matter what
> account I set in the config.inc.php file, I continue to get this error. How
> do I change this so that another account logs in to the localhost? I
> unfortunately had to reboot my
Hey,
Maybe just whip something up and let us see. If there is more interest
after that then maybe you could do the latter.
Regards,
Justin Palmer
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 4:54 PM
To: [EMAIL PROTECTED]
Subject:
Why not try to create a full text index on the column?
-Original Message-
From: jeroen clarysse
To: [EMAIL PROTECTED]
Sent: 4/16/04 9:00 AM
Subject: Need help with indexing !
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called 'va
Are you running the queries in parallel or serially? Are you using the same
connection? Are you issuing Low Priority Updates?
-Original Message-
From: Sahil Aggarwal
To: [EMAIL PROTECTED]
Sent: 4/16/04 8:27 AM
Subject: row locking
hi all,
i have select statements in my java code which a
Using mysql 3.23.53, i have a table with approx 1.000.000 records, and
only 3 columns. One of these (called 'value') is usually between 50 and
150 characters, but occasionally jumps to a current maximum of 570
characters, so I figured I had to go for the TEXT type.
now I tried to add an index o
Not sure on how exactly variables work in MySQL but I do know that according
to ANSI SQL group bys are done before other things in the query. So your
query would perform the group by then it would do the actual select. This
could be one reason for strange results.
Thanks,
Andrew
From: "Vadim
hi all,
i have select statements in my java code which are followed by updates
in my Innodb table.
the desired behaviour shud have been
check and then update
but because of tomcat accepting connections the above becomes
check check update update
i dont want to set the table locking, as it will ma
> Dear Sir,
> OS : Win XP Professional, Mysql 4.0.18 Category :WinMySQLAdmin 1.4
>
> Description: I've encountered bug error problem using Mysql 4.0.18 ver when in
> Dos Command prompt, using D:/mysql/bin/mysql --user root-- password give
> error message
> ERROR 2003 : Can't conne
saiph <[EMAIL PROTECTED]> wrote:
>
> <- snip ->
> Because your tables are not InnoDB.
> Check if InnoDB is enabled:
> SHOW VARIABLES LIKE "have_innodb";
>
> <- snip ->
>
> no, InnoDB is not enabled. how can i enable it?
What version of MySQL do you use? 3.23.xx or 4.0.x?
If you use 3.23 you sho
On Fri, Apr 16, 2004 at 12:07:39AM -0400, Mark Susol | Ultimate Creative Media wrote
the following:
> On 4/15/04 11:46 PM, "Joseph A. Nagy, Jr."
> <[EMAIL PROTECTED]> wrote:
>
> > So I'm using PHP and MySQL to serve up a game and all is going well until
> > today. The first problem came when for
> Hello colleagues.
Hi,
> How can I global lock a database?
> Global means that no user/process should be able to access it; I want to
> keep the database
> in read only for a certain period, NOT ONLY for the current session.
Have a look to Grant and User Privileges.
You can create a read only u
Hello colleagues.
How can I global lock a database?
Global means that no user/process should be able to access it; I want to
keep the database
in read only for a certain period, NOT ONLY for the current session.
thanks
Enrico
--
MySQL General Mailing List
For list archives: http://lists.mysql.
well, it seems to be fine without SUM and GROUP BY...
E.g.,
"SELECT @a:=Charge, @b:=Cost, @[EMAIL PROTECTED] as Margin ..."
produces expected results.
Emmett Bishop wrote:
Vadim,
if I'm not mistaken, you can't set a variable then use
it in the same statement.
See http://dev.mysql.com/d
<- snip ->
Because your tables are not InnoDB.
Check if InnoDB is enabled:
SHOW VARIABLES LIKE "have_innodb";
<- snip ->
no, InnoDB is not enabled. how can i enable it?
the referece manual show a my.cnf configuration for a machine with at least
2gb of ram and 60 of hard disk.
how can
You can start by downloading the official C++ API.
Get it from MySQL Developer Zone
http://dev.mysql.com/downloads/other/plusplus/index.html
Ciao!
Andy B wrote:
>hi...
>
>i was interested in making mysql work with c++... how would i go about doing
>this?
>to be more exact i use borland builde
hi...
i was interested in making mysql work with c++... how would i go about doing
this?
to be more exact i use borland builder 6 and i have databases that i want to
use with it and dont know how to use it with c++...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Hello colleagues,
I want to set up a replication schema on MySQL (ISAM tables).
I then have to align the databases before starting the replication.
I would like to NOT stop the database to do the alignment because
the application needs a lot of time to startup (1 hour) and I may have
to start and
Rusma Mulyadi <[EMAIL PROTECTED]> wrote:
> While trying to fix some problems with the user access privileges on
> mysql4.0 alpha, I run the mysql_fix_privilege_tables script.
> http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
>
> As the result, I can't get to the database, even using
79 matches
Mail list logo
