I switched my server from linux debian to NetBSD 1.6.
All when fine until I tried to do ./configure for the mysql-3.23.52
from the source tar.gz.
Problem is, it keeps looping saying "can't cd to mit-pthreads". I did
my homework and seeked a solution on mailing list, google etc and got
nothing g
Hi,
I have a mysql + php + apache server that is under
heavy load.
I have a script that runs every minute to deterimine
if the load is above a certain value (or if swap is
high) and if so, it kills all the httpd processes,
does /etc/rc.d/init.d/mysql stop
The script then starts everything back
Hi,
I need to improve the performance of a 1-word search engine
which I've created. Currently the RAM is 1 GIG and the key_buffer is set at
512 MB which has improved the search results but I think perhaps I can improve
my method of search with your help perhaps. The program is coded to run in
Hi Scott,
On Thu, 2002-10-10 at 03:28, Scott Pippin wrote:
> I am trying to set up two data files in case the first one fills up. I
> tried to use the following in my.cnf but it says there is an error. If
> I take out the reference to the second data file everything works
>
> AIX 4.3.3
> MySQL
Hi,
On Thu, 2002-10-10 at 10:57, kayamboo wrote:
>1. Is there anyway to know the string value of the password using the
> encrypted value , from the mysql.user table ?
No. It's scrambled with a one-way (lossy) algorithm.
>2. How can I know the most recently entered record, that does not
> mysql> select first, second, SUM(first) from example group by first;
> +---+++
> | first | second | SUM(first) |
> +---+++
> | 1 | 2 | 1 |
> | 2 | 3 | 2 |
> +---+++
> 2 rows in set (0.
well the result is correct. the sum of first is 1 for the first record. the
sum of first AND second would be 3.
select first, second, sum(first + second) from example;
is that what you want?
Rgds
Terence
- Original Message -
From: "Kevin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
Dear List,
I have removed root user of localhost thru webmin and now i am not able
to login into MySQL Interface of webmin as it says "Incorrect user name
and password" when I try to enter as any user [root or any XYZ user],
please tell me how to create this user for MySQL so that I can access
th
On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like
> tables name etc.
> and i can do query like "select tables from catalogName" and get all the
> tables in t
OK. Maybe I'm expecting too much of myself, but I can't figure out what I am
doing wrong here:
mysql> select * from example;
+---++
| first | second |
+---++
| 1 | 2 |
| 2 | 3 |
+---++
2 rows in set (0.00 sec)
mysql> select first, second, SUM
mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ
ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄ"ÎâÊÏ"ÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ
Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É
ʹ»¼Õß½â³ý²¡Í´¡£
¾Ö
sql, query
Hello Folks
1. Is there anyway to know the string value of the password using the
encrypted value , from the mysql.user table ?
2. How can I know the most recently entered record, that does not have an
AUTOINCREMENT column ?
Thanks for the tips.
HI
If suppose my table has thousands of records, is it possible to create a
new table without a foreign key constraint, and then copy the existing data
with the foreign key constraint to the new one ?
regards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROT
Hi toby
Just replace the .gif with your .pdf. I hope this will work for you.
INSERT INTO photo(name , pic, picname) values( 'raman',
load_file('e:/mysql/images/Click.gif'),'Click.gif') ;
SELECT length(pic) FROM photo WHERE picname = 'Click.gif' ;
UPDATE photo SET pic = load_file('e:/mysql/ima
Hello
There are lots of discussions in this regard and the suggestions are always
to save your blob somewhere in your hard disk and just store the path.
In my case, each of my image is around 1MB but you know, I find it
difficult to map the images stored in a particular machine, through a
netwo
Is there any other way to do this in a table with thousands of records.
- Original Message -
From: "Heo, Jungsu" <[EMAIL PROTECTED]>
To: "kayamboo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 8:50 PM
Subject: Re: drop constraint in innodb
> Last week, I
>Description:
After adding a key to a nullable column, null values will
successfully join through to null values in other tables.
This only seems to happen when the index is added after
the row contains null values. This affects both MyISAM
and InnoDB table types and both binary versions 3.23.42
Here is a correct one to solve your problem:
select b.city, b.name, b.numbeds, count(distinct a.numbeds) c from hospitals a,
hospitals b
where a.city = b.city
and a.numbeds>=b.numbeds
group by b.name, b.city, b.numbeds
having c=1;
-Original Message-
From: Myoung-Ah KANG [mailto:[EMAIL P
select * from table where substring(timestampField,1,8) = 'MMDD'
from Perl, execute this statement and then process each returned row
- hcir
> My mysql database is set up having a field cdate
> -> cdate datetime
>
> has the format
>
> -00-00 00:00:00
>
> If I want to fetch rows for sa
Rafa,
it looks like the tuning I did to 3.23.53 fixes the optimization also in the
'albaranes' case below.
Lenz starts building of 3.23.53 this week. With good luck 3.23.53 is
available around Oct 17, 2002.
Best regards,
Heikki
Innobase Oy
heikki@hundin:~/mysql/client> mysql test
Welcome to
On 9 Oct 2002, at 13:14, Lawrence S. Stephens III wrote:
> When I INSERT a record, that field is empty so that the default value
> is inserted into the field automatically (at least that's what I think).
If your query is setting the column to the empty string, then you're
setting it to the emp
Scott Pippin wrote:
> I am trying to set up two data files in case the first one fills up. I
> tried to use the following in my.cnf but it says there is an error. If
> I take out the reference to the second data file everything works
>
> AIX 4.3.3
> MySQL 4.0.4
>
>
>innodb_data_file_path=libda
>From: "Sqlcoders.com Programming Dept" <[EMAIL PROTECTED]>
>
>You should look into (via google.com) some doc to pdf converters. An example
>is this com object: http://www.convertzone.com/doc2pdfcom/help.htm#HowtoBuy,
>it costs $219 and converts .doc to .pdf.
That's $219 saved if you're on MacOS
>From: christophe barbe <[EMAIL PROTECTED]>
>
>Is it then correct that VARCHAR(255) and TINYTEXT are strictly
>equivalent?
I believe they work almost the same, but there may be performance implications because
they are stored differently.
My understanding is that TINYTEXT is simply a sort of BL
Hi All
My mysql database is set up having a field cdate
-> cdate datetime
has the format
-00-00 00:00:00
If I want to fetch rows for say the date 2000-12-19, I do it using perl
(it's a tediuos code)
Is there a way to do it using sql queries
Also how can I get betwee two specific date that
Hello Wolfgang,
[..]
> My question now is this: How can I tell a php script to not use the
> standard mySQL server that exists on this server computer, but to use
> the 2nd mySQL server that runs on the different port number ?
> Currently I use info set up in variables like this:
>
> # MySQL data
Is this what you're looking for?
mysql> select city,name,max(numbeds) from hospitals group by city;
+---+--+--+
| city | name | max(numbeds) |
+---+--+--+
| Lyon | Tonkin | 300 |
| Marseille | Clairval | 150
the port is part of the server parameter in the connection eg port 3307
mysql_connect ( localhost:3307 , username , password )
http://www.php.net/manual/en/function.mysql-connect.php
has the details
HTH
Peter
---
Excellence in internet and open sou
On 9 Oct 2002, at 11:55, Bill Hess wrote:
> One would think that the value would not top out until 2^31
> since I have it defined as a normal INT. I guess I can make it a
> BIGINT, but I think I will run into a problem eventually
> regardless how big I make the field...
Since the limit you're h
Sure you can.
show tables like 's%' from mydatabase;
Iikka Meriläinen wrote:
>On Wed, 9 Oct 2002, Inbal Ovadia wrote:
>
>
>
>>Hi all,
>>There is a way to know if I have table x in my db?
>>Let's say some catalog tables that hold information about the db like tables
>>name etc.
>>and i can do
Myoung-Ah KANG wrote:
>The query is: "For each city, what is the name of the hospital having the
>highest number of beds ? ' .
>
>Select name From Hospital Where (city, numbeds) In
>(Select city, MAX(numbeds) From Hospital Group By city);
>
>
>
"select name, city, max(numbeds) from
I am trying to set up two data files in case the first one fills up. I
tried to use the following in my.cnf but it says there is an error. If
I take out the reference to the second data file everything works
AIX 4.3.3
MySQL 4.0.4
innodb_data_file_path=libdata1:100M:autoextend:max:2000M;libdat
I am useing mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686). I have
set up a table in which one of the fields have a default value (i.e. "New
York"). When I INSERT a record, that field is empty so that the default value
is inserted into the field automatically (at least that's what I
Hi Silmara,
You can use the dbExpress that comes with kylix.
Silmara wrote:
> need use MySql to Linux ( Connectiva 7 )and Kylux.
>
>What version of the MySQL?
>Do I need MyODBC?
>
--
--
\|/ __\|/
`@" / o . \ "@' Microsoft? Por
show tables;
show tables from catalogName;
show tables from catalogName like 'order%';
-J
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Iikka Meriläinen
Sent: Wednesday, October 09, 2002 10:09 AM
To: Inbal Ovadia
Cc: '[EMAIL PROTECTED]'
Subject: Re: i
Owen,
- Original Message -
From: "Owen Scott Medd" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: ""Nicholas Gaugler"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 5:44 PM
Subject: Re: mysqld Threads with Innobase
> [ start stupid question ]
Rafa,
I fixed the optimization of the ORDER BY ... LIMIT 50 query on the generated
'clientes' table you sent in September. The fix is in 3.23.53. It will favor
index range scans even more over full index scans.
But the underlying problem is in the MySQL optimizer. It does not realize
that it can
On Wed, 9 Oct 2002, Brian Reichert wrote:
> On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
> > Hi all,
> > There is a way to know if I have table x in my db?
> > Let's say some catalog tables that hold information about the db like tables
> > name etc.
> > and i can do query like "
Hello List,
I'm using MySQL 4.0.3-beta on 2 RedHat 7.3 Boxes belonging to a 2 node HA
Cluster.
To allow the takeover of the database node I formed a replication ring.
So node1 replicates to node2 and the other way round.
Read/Write operations are only done on Node 2.
The nodes are connected wit
Hi all,
Can anyone tell me how to do this?
What I want to do is run a query that calculates the next [n]th [Sun - Sat]
of [Jan - Dec] in MySQL?
ie (Return the next occurance of the 2nd Tuesday in April).
In my table I store the day of the week I want the event to occur on, which
occurance in t
Hello all,
I am new to this list ... and hope to find an answer to a question
which has come up.
On the server for my websites at my ISP, a mySQL server is installed
to handle different customers' databases (1 database setup for each
customer)
Now, as I have a need for a mySQL server where
Nope - nothing close to 4GB or even 1GB... My greatest data file size
is 80MB. The largest table is 1.7 million rows. I have databases with
more and bigger files. I think my problem is that the table having the
problem with auto increment is refreshed everyday (or even multiple
times a day
Hello,
I have a problem to treat a query with MySQL because MySQL does not permit
nested SELECT clauses.
The schema of the table is :
Hospital
num | name | city| numbeds
10 | Clairval| Marseille | 70
20 | Notre-Dame | Ma
kusuma guntupalli wrote:
>Dear Sir,
>
>When Iam trying to connect remote mysql database Using
>JSP on LINUX Os it is giving an error...
>Remote system is Windows NT.
>
>java.sql.SQLException: Communication link failure: Bad
>handshake
>
>I loaded
>
>1).MySQL-3.23.40-1.i386.rpm
>2).MySQL-client-3.
show tables;
On Wednesday, Oct 9, 2002, at 05:43 America/Anchorage, Inbal Ovadia
wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like
> tables
> name etc.
> and i can do query like "select tables from cata
On Wed, 9 Oct 2002, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like tables
> name etc.
> and i can do query like "select tables from catalogName" and get all the
> tables in the db
Hi,
I g
How can i take AUTOCOMMIT default in my MYSQL Configuration
with Innodb tablespace? Every time i login at MySQL i have to
type SET AUTOCOMMIT = 0. I want this parameter be always 0. I
don´t use AUTOCOMMIT.
Thanks
Jacob
---
UOL Eleições 2002 - Todos os lances da disputa política
http://eleicoe
On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
> Hi all,
> There is a way to know if I have table x in my db?
> Let's say some catalog tables that hold information about the db like tables
> name etc.
> and i can do query like "select tables from catalogName" and get all the
> table
[ start stupid question ]
Does setting innodb_thread_concurrency to 1 imply that only one innodb
thread will be working at any given time? So using this on SMP servers
that you would like to be answering simultaneous queries is probably not
what you would really like to be doing, no?
[ end stup
On Wed, Oct 09, 2002 at 09:29:34AM -0400, Kevan Louou wrote:
>
> If my mysql master is under Linux and my slave under Windows, if the
> master crashes, can I make the slave a master once I recover the
> Linux machine even if data is replicated 100%?
Yes.
> Does replication only involves data?
I
Hi,
I do not recommend saving the image data in the DB:
1. The size of each DB Row increases dramatically.
Depending on the structure of your tables, query speed drops
as the rows are located further away on the disk (disk seek times)
2. For each image request, you have to involve some dyna
Looks like you don't have binary logging turned on on the master.
louie miranda wrote:
>021009 12:56:49 mysqld started
>/usr/sbin/mysqld: ready for connections
>021009 12:56:49 Slave: connected to master '[EMAIL PROTECTED]:3306',
>replication started in log 'FIRST' at position 4
>021009 12:56:
Hi,
I have a question about indexing a column of type SET. It seems that
generally the index is not too useful, since it always requires some
sort of expression to get what you want out of the set, and therefore
the index won't be used.
Example:
> create table FOO (BAR set('a','b','c','d'))
> -Original Message-
> From: William Martell [mailto:[EMAIL PROTECTED]]
> I am trying to query MySQL using PHP and I would like the
> results to display
> on multiple pages.
>
> I would like to display only 20 results per page and allow
> the user access
> to the other pages by clickin
Hi all,
There is a way to know if I have table x in my db?
Let's say some catalog tables that hold information about the db like tables
name etc.
and i can do query like "select tables from catalogName" and get all the
tables in the db
thanks :)
Inbal
If my mysql master is under Linux and my slave under
Windows, if the master crashes, can I make the slave a
master once I recover the Linux machine even if data
is replicated 100%? Does replication only involves
data? Would there be issues that would make my Windows
slave incompatible as a master
Alexis Antonakis wrote:
>The thing I was wondering is whether there is any advantage in saving IMAGES
>in a database?
>
>
None whatsoever unless you can't do remote file access any other way.
# SQL: SELECT name FROM images LEFT JOIN table1 ON table1.imageid =
images.id;
# Program: open(name) o
thnx guyz
1) i m tryin to put the pdf file into a blob field but i cant insert it like
normal text how shall i go about inserting it
2) i m in the process of converting the word doccuments to pdf got this
acrobat disteller n m havin a million probz with that alone like the
security iss
"Shaun Bramley" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I am using mySQL and PHP, how can I use PHP to display the length of time
> used by a query?
Shaun,
HTH.
-
Martín,
Tuesday, October 08, 2002, 8:29:21 PM, you wrote:
MF> I have downloades the last version of your software, but when I try to
MF> connecto to the mysql server remotly, the server crash, and safe_mysqld
MF> restar it. Your software reports "lost connection to MySQL dureing query"
MF> And th
Jeremy,
Tuesday, October 08, 2002, 8:55:35 PM, you wrote:
JOn> I am currently try to set up mysql on my computer and I'm running into a
JOn> few bugs. I'm using the book "PHP fast & easy web development". I've
JOn> run into a problem when I type the command mysqld --standalone into the
JOn> pro
Jojo,
Wednesday, October 09, 2002, 12:00:07 PM, you wrote:
JM> I'm using MySQL for Windoze (latest version of Server & ODBC).
JM> Is it possible to get the lists of DB in the Windows using the system
JM> tables of MySQL?
If you what to get a list of databases just use SHOW DATAB
speters,
Wednesday, October 09, 2002, 2:09:30 AM, you wrote:
samdc> I think i have a damaged table in one of my databases.
samdc> I can do a SELECT count(*) from table
samdc> on every table in the db with no problem, except for 1
samdc> of them, the query just sits for a while.
samdc> So i assum
I am trying to find a way to store the body of a binary NNTP message into
iamdc> MySQL. However, due to the way lines are encoded, MySQL will not accept the
iamdc> SQL statement. Does anyone have any ideas on how I should approch this?
NNTP message is a simple text message. You can store it in t
Putte,
Wednesday, October 09, 2002, 12:04:25 PM, you wrote:
PK> Is there a simple solution to define MySQL to use comma instead of dot in
PK> numeric fields?
You can't use ',' in numeric values. If you want to use ',', you can
store as a string.
--
For technical support contracts, goto https
Daniel,
Tuesday, October 08, 2002, 11:14:06 PM, you wrote:
DM> I have am having problems getting the MySQL server to start running, please help
me, here are my problems, I have also displayed my error logs below, at least I hope
they are the error logs;
DM> I have been trying to install the
Russell,
Wednesday, October 09, 2002, 1:44:14 AM, you wrote:
RU> we use the binary log as a crash recovery tool.
RU> therefore, once we have backed up the db (we use the excellent mysql_backup for
this) we can happily discard yesterday's binlog.
RU> the only correct way i've found to get rid of
kayamboo,
Wednesday, October 09, 2002, 8:45:39 AM, you wrote:
k> ALTER TABLE main_db ADD CONSTRAINT FOREIGN KEY( Code, Kana) REFERENCES
k> Syoyu_db( Code, Kana) ON DELETE CASCADE ;
k> works fine.
k> But how to drop the constraint or modify the constraint ?
k> Simply changing ADD to DROP or MODI
Hi,
The thing I was wondering is whether there is any advantage in saving IMAGES
in a database?
I have had a little play around with a 50k jpeg file and it appears that if
I save it in Blob format, then the filesize of the database increases by 50K
as well, and surely converting it from/to a data
Last week, I posted a message related to this.
Heikki (InnoDB Developer) said "sorry, DROP CONSTRAINT is not implemented yet."
- Original Message -
From: "kayamboo" <[EMAIL PROTECTED]>
To: "list mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 2:45 PM
Subject: drop constrain
But did you check if the file size is at 4Gig? This will cause
strange things to happen, mysql does not gice a nice error for this
condition. If the table was not created with MAX_ROWS option = to
some real large number like 5000, then you could be running
into a problem with the size of
It says in the manual ".. recompile MySQL, and rebuild your FULLTEXT indexes
...".
First time I downloaded the source code and compiled it, I just deleted the
old indexes and created new ones. But now I have a lot of tables with
fulltext indexes. So I'm looking for an easy way to do it.
Searched
What are the issues if I were to remove the following snippets from
"mysql.server" on a RH 7.2 system running multiple instances of MySQL
under multiple users?:
# Make lock for RedHat / SuSE
if test -w /var/lock/subsys
then
touch /var/lock/subsys/mysql
fi
Description:
Hello,
We reported a problem about selecting fields that some of them didn´t belong to
the used index on September.
We have already installed MySql 4.0.4 and we have a similar problem
(and also we are still having the original problem) when we select fields which some
sql spam filter
Hi
I'm running MySQL-3.23.37 on a cobalt raq. I have a table with approx
40,000 records and a dozen users running simple queries and updates -
names, addresses that kinda thing, but every time a query is run mysql
takes everything it can get and the box freezes:
10:33am up
Is there a simple solution to define MySQL to use comma instead of dot in
numeric fields?
Sincerely,
Putte koivisto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I failed to connect mysql from external network (it works by connected
. In the error log, I found the following message.
Number of processes running now: 1
mysqld process hanging, pid 13523 - killed
021009 12:35:28 mysqld restarted
/usr/libexec/mysqld: ready for connections
As you ca
Hi Guys,
I'm using MySQL for Windoze (latest version of Server & ODBC).
Is it possible to get the lists of DB in the Windows using the system
tables of MySQL?
or any workaround you can suggest.
Many thanks in advance.
Regards,
Jojo
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
Bill Hess wrote:
> Hello all...
>
> What is the maximum value of an AUTO_INCREMENT field? I am currently
> running into a maximum value of 296,995,724 on Solaris 8 using MySQL
> 3.23.42 - the field has been defined as an INT(11), which should be able
> to handle a value bigger than what I am see
Hi,
I try to install mytop in order to get some information about my MySQL
database, after I installed :
- DBI-1.18.tar.gz
- Msql-Mysql-modules-1.2216.tar.gz
- Data-Dumper-2.101.tar.gz
- Data-ShowTable-3.3.tar.gz
...and 'perl Makefile.PL' I get this warning:
Warning: prerequisite DBD::mysql fa
Nicholas,
- Original Message -
From: ""Nicholas Gaugler"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 09, 2002 8:22 AM
Subject: mysqld Threads with Innobase
> I know it's not very important in normal day to day operations, but does
> anyone know what
82 matches
Mail list logo