Hi,everyone
The connection is very so slowly when I connect mysql server,and
disconnection is so slowly too!
So when I view my homepage,the homepage show very slowly(I homepage must
connect mysql server via perl or php.)
(Mysql server install in win98,and I connect mysql server through localhos
I downloaded both the 3.23.31 version of mySQL, as well as the
patched BerkeleyDB (v3.2.3h) from mysql.com. I compiled BDB and
installed it under /usr/local. Then I proceeded to mySQL and gave it
the following configure args:
./configure --prefix=/usr/mysql
--with-berkeley-db-includes=/usr
I can start mysql from the command line with the "safe_mysqld --user=root &" call with
no problem. When mysqld is launched from init.d at startup (or when mysqld is called
from the command line) I get the following:
/usr/libexec/mysqld Can't find file: ./mysql/host.frm (errno13)
Can someone help
Hello!
My company curently use microsoft SQL, we discover the MySQL database few
weeks ago and we really impressed, but i have a few problems becouse my
querys use the union select which is not acceptet by MySQL, for example:
SELECT
DATE_FORMAT(min(time_stamp),'%Y.%m.%
You use "safe_mysqld &" try again.
Pete Hay wrote:
> I can start mysql from the command line with the "safe_mysqld --user=root &" call
>with no problem. When mysqld is launched from init.d at startup (or when mysqld is
>called from the command line) I get the following:
> /usr/libexec/mysqld C
"Ashley M. Kirchner" wrote:
>
> I downloaded both the 3.23.31 version of mySQL, as well as the
> patched BerkeleyDB (v3.2.3h) from mysql.com. I compiled BDB and
> installed it under /usr/local. Then I proceeded to mySQL and gave it
> the following configure args:
>
> ./configure --prefix=/
Hello
Anybody any idea how to fix this for Alpha?
bye,
-christian-
--
It has just been discovered that research causes cancer in rats.
Cheers,
downloaded 3.23.31. Builds just fine on i386, but sadly, fails on alpha
(potato, Linux 2.2.13, gcc version 2.95.2 2220).
g++ -DMYSQL_S
Hello all,
I've been trying to fix a problem we're facing without luck for the last
few weeks. I also searched mailing lists for a similar problem, both
MySQL and FreeBSD, without luck.
The situation is as follows... A brank new server was deployed last
month for our company. It's a 933Mhz Xeon-
Hello
A friendly reader of the Debian mailing lists backported the latest
security patch for the mysql version that is in Debian's last release.
I post this in case that
a) any other people rather like to patch their existing servers than
upgrade to a new major release
b) anybody finds a pr
try doing
"SELECT UNIX_TIMESTAMP('1990-2-31')"
and you'll get a number.
This is very weird, since this is an incorrect date.
Is there any way to figure out if a date is correct in mysql
SQL implementation? And why UNIX_TIMESTAMP does
not return NULL for incorrect date?
Artem
--
I have just installed myodbc and opened a connection to a mysql database
from access 2000. The connection is sucessful and i can see the names of
the tables as well as the fields. The problem is that when i make a query,
the resultset comes back with the correct # of records but the fileds in
ea
Hi Noor,
have you tried to run a "show processlist" within mysql during these
OVERHEAT situations to find out if there is a query forcing this high
load? You could also activate the logfile for slow queries (starting
mysqld with --log-slow-queries[=file_name])... maybe you will get some
info from
Hello Jan and all,
I have issued a "show processlist" all the time during the time that
mysqld is at high loads, but I didn't notice slow queries of some kind.
Furthermore, I personally go over all queries and tables produced by our
developers to insure proper syntax and indexing, so I am pretty
Hi all,
I was wondering what's wrong with a query like this:
select itemlist , sum(field1), count(*) as cnt from table where where conditions
group by id having cnt=2 order by field_x, field_y desc limit 10
I am expecting to get the requested rows order by field_x. Those with same value (
Hello MySQL authors
On RedHat there's no need to add "-lz" to the linker options, on Debian it
is (when using the statically libmyslclient.a). Is this a bug somewhere
in the makefile or anyways, should compress be in the .a lib or is it ought
to be added manually with -lz?
bye,
-christian-
Hello,
I've got quite some feedback from people that FreeBSD's threading
support sucks. One of the guys suggested that I build mysqld without
thread support.
I was wondering: what would be the implications of doing this on the
speed and performance of mysqld?
mysqld runs on a productional syste
Hello Noor,
I am struggling with a similar problem on a linux based system. It's a
Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
scsi controler.
On certain moments, mostly in the peak hours, mysql suddenly behaves
weird and the load increases very very quick. The swap u
> -Original Message-
> From: Artem Koutchine [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, January 21, 2001 1:44 PM
> To: [EMAIL PROTECTED]
> Subject: Checking if a date is correct
>
>
> try doing
> "SELECT UNIX_TIMESTAMP('1990-2-31')"
> and you'll get a number.
> This is very weird, since
> Hello!
> My company curently use microsoft SQL, we discover the MySQL database few
> weeks ago and we really impressed
YES! Another convert! :-)
> , but i have a few problems becouse my
> querys use the union select which is not acceptet by MySQL, for example:
Bob Hall has a couple of good su
>How one can implement foreign key in MySQL? I've looked at the doc
>but didn't get the method.
>
>Please comment,
Sir, it says in the manual that MySQL doesn't support foreign keys.
However, foreign keys are created by database design, not by RDBMS
support. There's nothing to stop you from im
>Hi all,
>
>I was wondering what's wrong with a query like this:
>
>select itemlist , sum(field1), count(*) as cnt from table where
>where conditions group by id having cnt=2 order by field_x, field_y
>desc limit 10
>
>I am expecting to get the requested rows order by field_x. Those
>with s
>Hello!
>My company curently use microsoft SQL, we discover the MySQL database few
>weeks ago and we really impressed, but i have a few problems becouse my
>querys use the union select which is not acceptet by MySQL, for example:
Sir, it would be a bad idea to continue trying to convert your SQL
Brett,
Regarding large tables in mysql, I am using tables with 20 million rows+ and
it works just fine. The tables only have two columns. The first is
varchar[50] and the second column an int type.
Regarding speed of access to the data, selects like "select field1 from
table1 where field1='abcd'
Pardon the newbie question but is there a tool available for MySQL that I
can give it 2 databases and it give me the ALTER TABLE statements necessary
to make 2 identical to 1?
Specifically, I have a test and prod database. I've made structural changes
to test and want to propagate them to prod.
I'm not sure what you mean by "structural changes".
If the the two table have the same number of columns and they are in the same order,
you can do something like what I have explained below. It you included the table info
from prod and test I could help you better (DESC prod;).
# Create t
You didn't give any details about the database and how it is being used/accessed.
There may NOT be anything wrong with your setup. It may actually be inefficiencies in
your code or queries that are causing the problems.
Also Note MySQL 3.23.31 has a serious bug!
- Scott
> Hello all
Database in Test:
Table1
Table1ID
myField1 varChar(20)
myField2 int
myFiled3 varChar(40)
Database in Prod:
Table1
Table1ID
myField1 varChar(60)
myField2 int
myField3 varChar(40)
myField4 int
I'd like something that compares these two databas
In case this wasn't reported before:
"show logs" in the server makes the client crash. Christopher Lameter
reported this via the Debian bug tracking system.
bye,
-christian-
--
codito ergo sum - I code, therefore I am!
Good question.
I can give you some details about the database I am using. This is about
another situation than Noor's (linux instead of FreeBSD), but the
problems looks similar.
I have not find any specific event that causes mysqld spinning around
and claiming memory. I activited the logging
KINROSS-21/01/01
Essence Software has released MySQL Plugin 1.1. MySQL Plugin is a plugin
for the REALbasic development environment on the MacOS. This plugin allows
developers to communicate with MySQL database servers from their
applications. MySQL Plugin 1.1 fully supports the REALbasic Databas
Hi all,
I trying to insert values from one table into another table, but keep
getting an error that the columns don't match. Do I have to select from the
one table in the same order that the columns are in the table I'm trying to
insert into?
Lee Jenkins
General Operations
DataTrak Business
Where can I get an example(s) of Microsoft Visual C++ 6.0 API to MySQL
running under Linux 6.2? In addition to a C++ source file examples(s),
where do I get the #include headers file(s) and the library file(s) ?
Any comments about header / linker options / settings would be greatly
appreciated als
Hi,
You should be able to do something like
INSERT INTO newtable SELECT col1, col2, col3... FROM oldtable;
if the definition of col1, col2, col3... matches the structure of newtable.
If it doesn't, then, you can try
INSERT INTO newtable (newcol1, newcol2, newcol3...) SELECT col1, col2,
col3...
Brett,
I am using mysql to log RADIUS accounting for a big ISP.
The accounting table has 10 fields of different types with one index on an
aggregate of 3 fields. The record is fixed length.
Mysql is reasonably fast and handles tables until you reach the 2 GB file
size limit where it fails (this
John,
are you sure that all indexes on all the tables merged are the same (same
fields, same order of indexes) ?
Benoit Grange
LibertySurf Telecom
10, rue Fructidor, 75834 Paris CEDEX 17
Tel: +33 (0) 1 41 66 77 88, Fax: +33 (0) 1 41 66 77 67
> -Original Message-
> From: John Hoffmann [
Hello,
Ord says :
> Next I tried to get a write lock on the table so that I could run the
> updates, but that made a huge mess - I could not obtain the lock.
I also have the same kind of problems while trying to RENAME a table when a
DELAYED INSERT is running.
I tried all the methods below and
>try doing
>"SELECT UNIX_TIMESTAMP('1990-2-31')"
>and you'll get a number.
>This is very weird, since this is an incorrect date.
>
>Is there any way to figure out if a date is correct in mysql
>SQL implementation? And why UNIX_TIMESTAMP does
>not return NULL for incorrect date?
Sir, this seems to
Acabo de instalar MySQL 3.22.32 para pc-linux-gnu 386
cuando intento hacer una conexión ODBC me sale.
ERROR 1130 is not allowed to connect to this MySQL server
Gracias, Thank.
-
Before posting, please check:
http://www.mys
Hi,
I have installed, uninstalled and reinstalled a number of times but keep
running in to this bizarre problem. If anyone else has experienced it and
knows of a workaround, I'd really appreciate hearing of it.
I am running an Intel RedHat 6 box and installing from the source tarball. I
receive
ah, I must have to stipulate the columns I'm inserting into. I will give it
a try.
Thanks a bunch
Lee
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 5:11 PM
To: '[EMAIL PROTECTED]'; MySQL Mail list
Subject: RE: INSERT INTO Statement
Can someone drop a line to the mySQL webmaster to clean up the RENAME TABLE
Syntax page? There is a long rambling of comments in which only 3 are related
to RENAME.
Regards,
-Nick G.
OS: NT 4.0, SP6
MDAC: 2.6
MyODBC: 2.50.36
MS-Access: 2000 (9.0.3821 SR-1)
MySQL-OS: Linux, RedHat 6.2
MySql: 3.23.27-beta
Symptom: Two of seven tables return all columns and rows as "#Deleted" (and
wouldn't you know it, the two most important tables in the database). have
been throu
hi sirs,
i met a serious bug on
inserting a 900+KB data into a LONGBLOB column.
the error shows
"MySQL server has gone away on executingSQL= INSERT INTO
ebody(rtime,body,size,subj,pri,froms,tos,ccs,bccs,nattach,msgid)
VALUES(date_add(curdate(),interval curtime() hour_second),?,?,
How one can make a field encrypted in a table, so that it cannot even be
seen using the select statement? I have a field in which I'm storing
passwords and I don't want it to be visible.
Ghazi, Muhammad Farhan
_
Get Your P
At 7:24 AM +0500 1/22/01, Muhammad Farhan Ghazi wrote:
>How one can make a field encrypted in a table, so that it cannot
>even be seen using the select statement? I have a field in which I'm
>storing passwords and I don't want it to be visible.
Making it visible or not isn't a matter of encrypt
See the section of the documentation on the password function.
Insert into users (username, password) values
('joesmith',password('somepassword'));
It will encrypt your passords. then you select using the same function.
select username, password from users where username = 'joesmith' and
passw
In the last episode (Jan 21), Noor Dawod said:
> I've got quite some feedback from people that FreeBSD's threading
> support sucks. One of the guys suggested that I build mysqld without
> thread support.
Building mysql without threads is impossible; mysql is extremely
thread-centric. I doubt Fre
Hi!
> "Basil" == Basil Hussain <[EMAIL PROTECTED]> writes:
Basil> Hi,
>> I am BEGGING you to please make the describe command OPTIONALLY display the
>> Privileges column. Before 3.23, I was able to see the describes properly. Now
>> the command is almost totally useless to me!
Basil> I agr
> "Huang-Ming" == Huang-Ming <[EMAIL PROTECTED]> writes:
Huang-Ming> hi sirs,
Huang-Ming> i met a serious bug on inserting a 900+KB data into a LONGBLOB column.
Huang-Ming> the error shows
Huang-Ming> "MySQL server has gone away on executingSQL=
Huang-Ming> INSERT INTO
ebody(rtime,
Hi,
I am trying to benchmark mysql's performance for fetching a random record.
To do so, I have setup the following configuration: Linux, 14 2G tables,
each populated with 65000 records of fixed 32k size, type mediumblob. My
test randomly generates a table/id pair and selects the record. I then
Thanks to Apollo and Lee for fast responses. Both recommended adding
TimeStamp columns to the table. Lee also recommended adding an
auto_increment column.
What actually was the culprit was that in the suspect tables, I had a
Primary Key on a TinyText field. I have not tried (a) converting the
Hi,
I've read from the FreeBSD SMP kernel developer's list that the FreeBSD
threads implementation is not as mature as Linux is. Even then, either OS'
thread implementations are not as mature as commercially available systems.
It was suggested that Solaris be used for mysql.
--
Vibol Hou
Hello Cal,
I don't think there is a "magic bullet" for what you want. Although I'm sure some
sort of Perl script could do a comparison and create the proper ALTER TABLE SQL to
make the two tables equal.
I usualy just copy tables using the CREATE TABLE syntax (as below) and make the manual
a
Hi all,
I'm wanting to set up mysql to run in a chroot jail. I saw the command
line option --chroot and tried this which seemed to work (well mysql ran
anyway). I added this to the startup script (running redhat 7.0) in
/etc/rc.d/init.d/mysql so that it would use this option (and because I n
Hi...
I need to somebody clarify what is the problem with this..:
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW rows;
int i,n;
.
.
.
result = mysql_store_result(&mysql);
n = mysql_num_rows(result);
for(i=0;i<=n;i++)
{
rows = mysql_fetch_row(result);
printf("%s\n",rows);
}
"Jeremy D. Zawodny" wrote:
> On Tue, Jan 16, 2001 at 03:41:14PM +0800, Ganen Ganeswaran wrote:
>
> > I'm a relative newbie in mySQL. I have 10 mySQL databases. At the
> > moment I'm only using 1 of the databases. I was wondering if it's
> > possible (and how) to setup some sort of replication/loa
Use it where? Doesn't mysql set this stuff up when installed?
BTW - I've been an NT administrator for the past few years and I'm trying to
explore this Linux thing. Not real encouraging so far.
Pete Hay
- Original Message -
From: "Tony Cheung" <[EMAIL PROTECTED]>
To: "Pete Hay" <[EMAIL PR
I hope so.
A point that my Noor's situation and mine have in common is fast disks.
Maybe there is a timeng problem ?
Another remarkeble table I did not mention is a table with a blob-field.
The blob field is used to store perl-objects with a size of about 8Kb.
The table is about 3000 rows lar
58 matches
Mail list logo
