Eric,
Eric Mayers wrote in message ...
I have an application that stores a large (up to 6gb) database in an
InnoDB table. I'm using an InnoDB table to have concurrent inserts and
selects and to get beyond the 2gb limitation.
I have to allow read-only remote database connections and cannot
Hi,
I work with a rel. 3.23.36 of MYSQL and I have found this problem:
I have two tables named t_payments and t_payment_lang; these are their
descriptions and data:
t_payments (description):
+-+---+--+-+-+
+
| Field | Type
Hi!
You have not created an index on your foreign key. From
http://www.innodb.com/ibman.html :
...
An example:
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY
Dear Members,
How can I know the no. disk acesses and the main memory used to execute a
particular query in mysql ?
Plz mail me asap.
in anticipation
Praveen Sirupa
-
Before posting, please check:
That's a bit of a pain :) Any idea if this will be supported at some point?
Cheers, Neil
Victoria Reznichenko wrote:
Neil,
Monday, February 04, 2002, 6:00:18 PM, you wrote:
NF Hi,
NF Ideally I wish to keep all of my database files on a network drive
NF (X:\). Using WinMySQLAdmin.exe I
Hi,
We use
Red Hat Linux release 7.1 (Seawolf)
Kernel 2.4.3 on a 2-processor i686
Only around 5000 of the rows match out of the 58,000,000.
As I understand it, we do have single indexes on each of the columns.
Given the replies below, I feel that mysql is not getting the optimisation
Hi, all MySQL team
Thanks for your former help. Here is another question:
As MySQL support multiple instances, each instance will
run with different socket file and tcp/unix port number.
I want to know when using MySQL client programs like
mysqladmin to connect different instances, are both
Hi,
What is the alternative in mysql for ROWNUM of Oracle?
Thanks,
Rama Raju
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
On Mon, Feb 04, 2002 at 08:01:39PM -0700, Matthew Walker wrote:
I need to find a text editor for Linux that doesn?t load the whole file
into memory. I need to edit a 1.5 gig text flatfile to add two lines.
But I don?t have enough ram to open it in most programs. Can anyone
recommend
Dear all,
Which of the following SQL queries is faster and better
select thefield from thetable group by thetable
Or
select distinct thefield from thetable?
and WHY?
Best Regards
Hayan
Get your own 800 number
Voicemail, fax, email, and a lot
hi again,
Now I need to sort a field of varchar type. But the filed values are like...
b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
meaning thereby, an integer prefixed by some character.
Is there any straight way to frame the query?
thanx in advance for your time,
regards,
-vishi
Kinney,
Monday, February 04, 2002, 9:06:45 PM, you wrote:
KB Hi,
KB I'm playing with PHP/MySQL for the first time having used Perl and MySQL
KB for years.
KB In one of my first update scripts, PHP is automatically escaping quotes and
KB such, which I assumed was a good thing.
KB However, I'm
Erin,
Tuesday, February 05, 2002, 12:37:33 AM, you wrote:
EL Hi, this is Erin Lilly, I've used support before with you all for
EL bodyconsultant.com and you were extremely helpful. I'm installing mysql on
EL erinlilly.net and have run into that common /tmp/mysql.sock (111) error
EL version:
Hello there,
I use MySQL (4.0.1) with InnoDB tables with binary logging on.
I see that the
BEGIN and COMMIT statements that wrap my queries are
not written to the binary log. I perfectly understand this if
I have one server. But assume I have a master server, and a
slave server that
Dear Hayan,
Which of the following SQL queries is faster and better
select thefield from thetable group by thetable
Or
select distinct thefield from thetable?
and WHY?
=if you use the MySQL command line to issue a query, a summary report follows any
output giving number of rows
affected
hi,
is mysql support transaction?
how to setup it?
please help
thx
felik
__
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
-
Before
On Tue, 2002-02-05 at 02:42, Joe Villari wrote:
I'm hoping I can get some help here, I'm trying to get MySQL running
on YellowDog Linux 2.4.17 kernel. I've installed the mysql,
mysql-server and mysql-devel-3.23.32-1.7a rpms from my install CD.
Ran mysql_install_db then changed the group
On Tue, 2002-02-05 at 10:18, Vishakha Mali_Wagh wrote:
Now I need to sort a field of varchar type. But the filed values are like...
b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12
meaning thereby, an integer prefixed by some character.
Is there any straight way to frame the query?
OK, if the
Dear Members,
How can I get the no. of disk accesses main memory used to execute a
particular query in mysql ?
Plz reply asap.
Thanx in advance.
Praveen Sirupa
-
Before posting, please check:
Yes MySQL supports transaction.
But you have to use certain table types : for example InnoDB or BDB (and not
MyISAM).
I use InnoDB ; read the following section of the manual :
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I
nnoDB
it will tell you which options you may
Stuart,
Monday, February 04, 2002, 7:36:39 PM, you wrote:
SO some stupid fool has deleted the mysql.sock file from our redhat server
SO system. (me!)
SO How do I regenerate one?
You should restart your MySQL server.
SO thanks a mil
SO StuartO
--
For technical support contracts, goto
On Mon, 4 Feb 2002, Manuel Bouyer wrote:
What a minute ... you're loading the tables to a 'mysqld' process, using
the 'mysql' command, rigth ?
Maybe it's just the mysql command which runs out of files descriptors ?
Did you try to raise the limit of the shell before starting it ?
On
On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote:
On Mon, 4 Feb 2002, Randy Arabie wrote:
Right. Like this:
mysql -u someuser -p -D somedatabase ./data.sql
No. I didn't raise the shell limits, I rose the kernel maxfiles and
the mysqld process
At 04:21 AM 2/5/2002 , you wrote:
Dear all,
Which of the following SQL queries is faster and better
select thefield from thetable group by thetable
Or
select distinct thefield from thetable?
and WHY?
Best Regards
Hayan
Hayan,
I believe the Select Distinct.. gets translated into a Group
HUH ?
Oh well lets try again, please read below ...
SQL = SELECT help FROM mysql.list WHERE spam NOT LIKE 'bounce%'
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your
Hi
The I have noticed that the number of Aborted Clients and Aborted
Connections has increased sharply recently on our two production
servers, but not on our development server.
Yesterday we started getting a number of blocked host errors, which we
had to clear up with flush hosts.
alter table your_table add unique index (path_id,word) ;
-Message d'origine-
De : Jon Shoberg [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 5 février 2002 16:40
À : [EMAIL PROTECTED]
Objet : Spam Filtered - Re: Making Unique Pairs ??
HUH ?
Oh well lets try again, please read below ...
On Tue, 5 Feb 2002, Manuel Bouyer wrote:
On Tue, Feb 05, 2002 at 07:59:20AM -0700, Randy Arabie wrote:
On Mon, 4 Feb 2002, Randy Arabie wrote:
Right. Like this:
mysql -u someuser -p -D somedatabase ./data.sql
No. I didn't raise the shell limits, I rose the kernel
Hello,
I'm relatively new to mysql and I've come
across a problem while trying to insert
values from
multiple tables into a single, existing
table. Here's the syntax that I'm using:
insert into table1 (col1,col2,col3,col4)
select Foo.col1, Foo.col2, Bar.col3,
Bunk.col4 from table2 as
Foo,
On Tue, Feb 05, 2002 at 08:34:34AM -0700, Randy Arabie wrote:
You mention that, mysqld AND mysql. You will note above that when I checked mysqld
with fstat,
there were only 64 files open. That, coincidentally, is the default
proc.curproc.rlimit.descriptors.soft
setting.
Does mysqld
Steve [EMAIL PROTECTED] writes:
I'm trying to pick the best path, but between this older K62 and the
warning about gcc 2.96, I'm having trouble :)
(I'll be using a K62 with RH7.1)
The rpms here
http://people.redhat.com/teg/mysql/
should work just fine (they're built in a RHL 7.2
I have problems with starting mysqld. When i put down command:
./safe_mysql
it returns message:
Starting mysqld deamon with databases from /usr/local/mysql/var
020205 15:07:03mysql ended
I've instaled latest mysql from source distribution on Linux Slackware
8.0.
Lp
jure
- use of mysql_pconnect (introduced in Novemeber)
- use of fsockopen($Primary, 3306, $errno,$errstr,5) (closed by
fclose()) to test if connection possible before attempting connection
(introduced last week)
- much high web activity causing recycling of httpd processes
You're putting more
hello,
i made the mistake of changing my root password manually in the mysql
database. after doing so, i 'flushed privileges'.
now i'm unable to log on using the root. i've tried to log on using the new
password a number of times, but i'm always denied access. strangely enough,
other users
Dave,
Monday, February 04, 2002, 10:08:04 PM, you wrote:
DM I'm currently trying to install MySQL in my home directory on a server which
DM I do have root access to. I follow the steps outlined in O'Reilly's
DM 'MySQLmSQL' book and I get through the first several steps before problems
DM
sreedhar,
Tuesday, February 05, 2002, 6:42:51 AM, you wrote:
s How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat
s Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB
s table.
You can find info about it in the manual:
Hello, I have two tables in my database as such:
CREATE TABLE `skill_names` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
);
CREATE TABLE `skills` (
`skills_id` int(11) NOT NULL auto_increment,
`member_id` int(11) NOT NULL
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B matching certain criteria.
I've tried every type of inner, outer,
On Tuesday 05 February 2002 9:59 am, Barry J. Wiegan wrote:
Hi,
I'm trying to build a query to solve a fairly simple problem.
I have two tables (A and B) linked by a common ID. I want to
locate a specific record in A that is linked to two or more
records in B based on second field in B
jeremy,
Tuesday, February 05, 2002, 6:40:29 PM, you wrote:
jr hello,
jr i made the mistake of changing my root password manually in the mysql
jr database. after doing so, i 'flushed privileges'.
jr now i'm unable to log on using the root. i've tried to log on using the new
jr password a
Hi
I am working on a search logging script to count the most popular word or
phrases searched for.
Table
I could add a line for each search, and aggregate the results for reports,
but I was wondering about the following which would keep table sizes down.
| search word | count |
Most of my experience with SQL comes from an SQL environment in which the
program will run through and end fairly quickly. I'm now up against a
constantly running C program which utilizes the database on a regular basis.
In this case, is it better practice to only open the connection for the
Whoops! Forgive me, I meant to say a CGI environment. This should be a
lesson to me to proofread no matter the time restraints. :)
- Original Message -
From: Dave Mittner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 05, 2002 10:37 AM
Subject: Using SQL in a C Program
Hi Peter,
I am working on a search logging script to count the most popular word or
phrases searched for.
Table
I could add a line for each search, and aggregate the results for reports,
but I was wondering about the following which would keep table sizes down.
| search word | count
Neil,
Tuesday, February 05, 2002, 11:19:35 AM, you wrote:
NF That's a bit of a pain :) Any idea if this will be supported at some point?
Apparently it will not be supported. Disk file system differs
from networking file system. MySQL will not work via networking file system.
NF Cheers, Neil
hello,
following the instructions for resetting a password (
http://www.mysql.com/doc/R/e/Resetting_permissions.html ),
i was not able to find the .pid file. is it possible to continue the process
without killing it?
what would be the command to restart the daemon using the
--skip-grant-tables
MySQL: DATETIME vs. INT
http://forums.devshed.com/showthread.php?s=threadid=29754forumid=4
C:heers!
-Original Message-
From: DL Neil -- Sent: Tuesday, February 05, 2002 1:28 AM
Checking the MySQL manual (6.3.4 Date and Time Functions)
UNIX_TIMESTAMP()
UNIX_TIMESTAMP(date)
...returns
Hi, I currently have a very large MS SQL7 database that I need to put on the
web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
Visual Basic front end on the MS SQL7 Server. I would like to have my VB
program write The MS SQL7 server data to a MYSql database and then have
At 16:00 04/02/2002 +, Neil Freeman wrote:
Hi!
I did the test in my small network and works. The only care I
did is to mapped the network drive, assign a letter (in my case
F). Please take a look if effectively you had mapped the drive
X (trying to access the X drive with an DOS prompt).
After reviewing the MySQL documentation about the available privileges and
what
they would be used for, I still was not able to find my answer.
Can another user, besides root, use the replication commands?
What would be the minimum set of privileges that could use SLAVE START,
SLAVE STOP, SHOW
Hi all,
I want to connect a MySQL client from Windows NT to SUN Solaris 2.6.
How can I do this? I need some services running in the Server (in my case, SUN
Solaris). What means the message:
Host my_IP is not allowed to connect to this MySQL server ??
Thanks in
Hi Bob,
Hi, I currently have a very large MS SQL7 database that I need to put on the
web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
Visual Basic front end on the MS SQL7 Server. I would like to have my VB
program write The MS SQL7 server data to a MYSql database
I downloaded the following file from mysql.com.
mysql-3.23.47-sun-solaris2.8-sparc.tar
I untarred it into /mysql, then I have the following
files.
Look here:
# ls
bin include scripts sql-bench tests
data lib share support-files
#
Then I went into /mysql/bin and tried running mysql
like so:
hello again,
still learning ...
i'm experiencing some unusual behaviors from the daemon. it stops
immediately.
[localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql
[localhost:/usr/local/mysql] root# Starting mysqld daemon with databases
from /usr/local/mysql/data
020205
We are running an extremely large instance of mysql version 3.23.46 on
Solaris 2.8. We are attempting to use a software version compiled 64 bit
and have been experiencing memory related server crashes.
The behavior suggests that we are still unable to use more than 4G of
memory.
If the
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
Clarification:
I currently have 22 NT workstation that send data to various tables in a
SQL7 database running on a NT sever. The visual basic front end organizes
this data in to a
dear all.
I have a problem using mysql(occured at using phpMyAdmin):
i send the query:
DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53
AND var1=1000.1 LIMIT 1
and 0 effect.
but when var1 has a (INT) value there's no problem:
DELETE FROM test WHERE user = test AND timestamp
In the last episode (Feb 05), Matthias Hoffmann said:
dear all.
I have a problem using mysql(occured at using phpMyAdmin):
i send the query:
DELETE FROM test WHERE user = test AND timestamp = 2002-02-05 21:42:53
AND var1=1000.1 LIMIT 1
and 0 effect.
but when var1 has a (INT) value
We've built MySQL 3.23.46 on Solaris 8/SPARC as a 64-bit executable
using the Sun C compiler. Everything built OK. We built against
ncurses, readline, and zlib, all built as 64-bit libraries. Are there
any special settings to get MySQL to work properly in this environment
or should things work as
On Tuesday 05 February 2002 13:03, Matthias Hoffmann wrote:
dear all.
I have a problem using mysql(occured at using phpMyAdmin):
i send the query:
DELETE FROM test WHERE user = test AND timestamp = 2002-02-05
21:42:53 AND var1=1000.1 LIMIT 1
and 0 effect.
but when var1 has a (INT) value
When using the LOCAL option to the LOAD DATA INFILE query, does the
client program read in the file or does the server read in the file?
I'm asking because I'm hoping that there is a way to disable the LOCAL
option or make it so that the File_priv will even apply to the LOCAL
option. Right
Hi;
I get this error when I try to access a database as root:
mysql use antigo;
Can't read dir of './antigo/' (Errcode: 13)
What does this mean and how do I fix it?
TIA,
BenO
-
Before posting, please check:
hi,forks,
Now I try to save image to MySQL, I create a table
with longblob field, i try two ways as follows but
both did not work
1. use appendchunk, i succeed in saving image to MS
SQL with this funtion. but i can't save image to MySQL
with it.
2. using Load_File insert a bmp file (size is
When I try to connect to the mysql server (mysql -u root -p table),
I get an error about /tmp/mysql.sock.
Anyway, what is the problem here? Do I have to take it down and start
it up again? I'm pretty sure the problem is that the file has been
deleted, probably a cron job, but I can't remember
hi forks,
I try to save image to MySQL and I create table with
longblob field. but i failed with following two ways:
1. use appendchunk and getchunk which are succeful in
MS SQL but failed in MySQL
2 insert a bmp file(size is 54k) into table with
load_file and get data from table using select
Hi All,
I'm glad to inform you that the new (1.51) version of EMS MySQL Manager has
been released today. In this version we've included the fixes of all bugs
which had been found by our users. Many thanks to all who sent us their bug
reports. Also a lot of small improvements was added, which
I have a site using PHP Mysql. About a month ago to now one of the tables
gets corrupted with the message Got Error 127... I fix it and everything
works OK, except every time I loose 1 record.
Today I could obtain mysql.err from the machine and I could see whenever an
error is produced by date,
Try:
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
C:heers!
-Original Message-
From: Cindy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 1:59 PM
To: [EMAIL PROTECTED]
Subject: mysql.sock
Sorry, I know this is documented somewhere, because I've seen it,
but
On 5 Feb 2002, at 15:11, Dan Nelson wrote:
I assume var1 is a float in the first case? Due to rounding
issues, the = operator will almost never work on fractions.
Use the primary key to select which record to delete, or use a
number range (var1 BETWEEN 1000.009 AND 1000.1001).
Matthias
I would like to authenticate my IntrAnet users against our Microsoft Active
Directory database. Has someone done this before?
How would I connect MySQL to the AD?
Thanks
-Allen
---
[This E-mail has been scanned for viruses and is clean]
Oh well worth a try
Thanks
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Hi there,
I have installed MySQL 3.23.37-sun-solaris2.7-sparc.
Some times the server starts and when i try to connect it using my
password it hangs. It doesn't allow me in. Neither does it say anything
about the password or about the connection.
How do i solve this.
This is the second time it is
Running Kernel 2.4.17 gcc-2.95.3 glibc-2.2.5
I read through the manual for hints and searched the mailing list
archives but couldn't find a similar report.
Here's the build output:
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\
hello,
This is my problem and question:
I installed mysql-3.23.36 when I installed the RedHat7.1, but now I want to
install mysql-3.23.47 to the platform and I hope the two versions are both useful. How
should I configure the parameters when I configure? I want mysql supporting
Hi,
I am used to using Microsoft SQL or Sybase servers where there is a simple
client setup mechanism or I can connect using
DBArtisan etc. (this is from previous employment)
What we have is MySql and PHPadmin setup on a Linux Box (done by someone
else). Its only just been setup.
If you want to get the most out of MySQL, then you really need to learn to
use the command line tools. MySQL has the easiest to use tools and language
of any database I've used. SQL allows you to do really powerful things
easily.
Download the Windows version and install it. You can use the
Hi list,
I'd like to generate arrays into a field for the result-set
by means of grouping...
myTable ( MySQL 3.23.33 / MyISAM table )
++--+
| id| type |
++--+
| 002 | 'CD' |
| 002 | 'LP' |
| 011 |'DVD' |
| 081 |
At 14:10 06/02/2002 +1100, WG4- Cook, Janet wrote:
Hi,
What is the best or easiest client to set up on my NT4 workstation so I
can connect to the MySql server
and create tables, etc via scripts? I tried downloading one or two from
the MySql site but none of them seem
to have any
Description:
When issuing a command containing both a GROUP BY and an ORDER BY clause, the server
is returning no results. This issue has
arisen since upgrading from 3.23.47 to 4.0.1
How-To-Repeat:
Table Creation:
CREATE TABLE statarchive (uid INT unsigned NOT NULL AUTO_INCREMENT, referal
Hi bob,
I have do everything you need but may be a little diff. I have MS
SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The
first thing you must define some role of usage and other, how to manipulate
your data. I have PHP update routing in some project
Hi,
I need to know that MySQL has any compression method when it store
data? If the answer is Yes, How the different compression between MySQL
and other tools (zip, gzip)? I asked this question because I need to store
some text file for future used (at least 1 Mbyte per day). I was
My apologies, what I said in this previous post is incorrect.
It appeared as if the time was UTC (except for daylight savings)
to me, but it was mearly because of the format string
As Paul DuBois quite rightly pointed out is that %h in
select FROM_UNIXTIME(UNIX_TIMESTAMP(),
Hi,
I have install mysql-RPM 3.23.38 on red hat linux 6.2 machine,
which was running properly for more than 3 months .
recently , It started restarting after every 30 min.
I am trying to find the problem but, error file shows stack trace
which I could not understand.
I have
That's great but... do you know there is some FREE products to manage MySQL
DB.
I propose MySQL Front, you can find it at http://www.anse.de/mysqlfront/
Hope This Help All Folks
theOtherOne
- Original Message -
From: Igor Brynskich [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
84 matches
Mail list logo
