Yes, sockets are much faster.
Best regards,
-Eran
"William R. Mussatto" wrote:
On Mon, 5 Feb 2001 [EMAIL PROTECTED] wrote:
Date: Mon, 5 Feb 2001 13:11:51 -0800
From: [EMAIL PROTECTED]
To: Gus Constan [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Port 3306
Add
Hi,
For an indexed column, the index is used if the start of the string is used:
LIKE 'a string of text%' may use an index
LIKE '%any old string%' will not, since the start of the string is unknown.
The index will only be used if the server decides that it will be quicker
than a full table
I haven't had a chance to do so yet.
But, we offer 4 kinds of searches:
'$word%'
'%$word%'
'%$word'
and
'$word'
So some searches still won't use indexes.
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 7:26 PM
To: 'Ryan Hadley';
I am surprised you said that. There are many programming languages that do
not recognise boolean datatypes. To define a boolean variable in these
languages, declare a variable as integer then 0 = false and any other number
= true.
In your case, I suggest you could try changing your Access/ASP
Hi everyone, thanks in advance for any tips whatsoever. I've been
running mysql 3.22(STABLE) on a RedHat Linux 6.2 setup, 512 RAM, pentium
III 700 18 GIG ultrawide scsi. It's been running just fine for a few
months, then all of a sudden it just dies. When I restarted using
safe_mysqld it came
Hi!
We are using PHP and want to detect if a MySQL server is available or not,
but do so very quickly. Will the MySQL library in PHP use a connection
client timeout? Can this be set under [client] in /etc/my.conf?
Also, what is the connection is a persistent connection, and the server goes
Firstly, I'm not exactly sure of what you are trying to do but in any case
check out the blob column type in the mysql manual. Also, you are probably
better off storing the image on disk and only store the URL in the database.
Whichever the case, good examples can usually be found at
Suggestions only:
Did you check the error logs? Is there a cron job running that is killing
the socket file or something?
BTW: Have you applied the latest RH patches?
- Original Message -
From: "Alex Tapia" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001
can: yes
should: That's up to you but personally I wouldn't
- Original Message -
From: "Hardy Merrill" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 3:31
Subject: --skip-locking on Redhat 6.1 Linux
Can/should MySQL be started *without* --skip-locking on
Usually means you haven't started the server. Check by doing a ps command
and also check the manual if you don't know how to start it.
- Original Message -
From: "hocine grine" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 1:00
Subject: help me !
my name
I did check the error logs, all logs, but there is nothing. No cron jobs
either. It's very strange, I did the isamchk on all the tables while mysqld
was shutdown. I don't have a clue what it could be.I've seen that some
people who have had this problem were told to have their file
Hey all.
OK. I'm done. It's taken about 2 months to rewrite our VB app using MySQL
as the back-end, rewriting much code from DAO to ADO usng MyODBC and of
course, debugging. We've switched from MS Access 97 DB's (No more DB
Corruption, Compacting and Repairing).
One of the reasons that
Don't know about max number but unlimited, I would have thought.
SELECT b1.foo, b2.foo
FROM bar as b1, bar as b2
WHERE ...
Will get you a table join on itself.
- Original Message -
From: "goEbusiness.com Mail Lists" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07,
Did you log into mysql a root?
ie mysql -uroot mysql
- Original Message -
From: "Webmaster" [EMAIL PROTECTED]
To: "MY SQL" [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 23:25
Subject: running mysql
Hi,
I am a new user of Linux and mysql and i have installed suse7.0 on my pc
I thought this would have been relatively easy.
INSERT into T1 VALUES ...
then
INSERT into T2 VALUES ...
and no, you can't insert into 2 tables with 1 insert statement unless the
mysql team fixed that with the latest version.
- Original Message -
From: "Hardi Gunawan" [EMAIL
Why would you want to? UNIQUE() is an INDEX() the only difference being
that UNIQUE can not have the same value a number of times whereas INDEX you
can.
- Original Message -
From: "Jacob Friis Larsen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 21:38
This usually means that the mysql server hasn't been started. Check this
with the ps command.
- Original Message -
From: "Progetto 2000" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06, 2001 15:47
Subject: Support request from Progetto 2000 ID support 4300
Hi,
I
"Only" 272235??? I enter on average about 75,000 to 80,000 records a day
(and some times, I break 100,000 records a day. I do monthly rotations so
it's easy to calculate how big my table gets). Granted, I don't know what
your table structure is but mine is very simple. All I do is run
What you will need to consider more is
1. The effort required to migrate across to mysql. There are tools that can
assist but I don't know the URLs. Maybe someone else on the list knows.
2. What will be faster for the majority of users and I'm talking about
overall performance. If having it
If RPM used:
rpm -ql mysql (or if unsure about the package: rpm -qa | grep -i mysql)
Location:
/var/lib/mysql
There you will find your databases where one directory under mysql
corresponds to one database. Documentation on line and searchable on-line
manual come also handy. Just read
At 11:50 06/02/2001, Peter Zaitsev wrote:
Hi!
I have made the following table on Win2000 machine:
C:\mysql\binmysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.30-gamma
Type 'help;' or '\h' for help. Type '\c' to clear the
on a related but slightly different example, what would happen if you had a
Primary Key consisting of 2 columns a b (so the pkey enforces a unique
combination of a b) and then created an index on one of the columns eg b.
Would the index on b have any effect, or does a primary key on 2 columns
Ok I have 2000 images in a database that I want to move out of the database and save
the image as a file and place the url to the image in the database. But I can\'t
figure out how to get them out and written to a file to do this.
You Wrote:
Firstly, I\'m not exactly sure of what you are
[EMAIL PROTECTED] writes:
Hello, I have a table of 26 million rows that I need to query. The table
is a keywords database with the keyword and a pointer to what page it
came off of. (pageid|keyword) The problem is that when I use the
following query is the group by make the query take about
Well, I'm looking at reliability more than speed and I'm afraid that MS
Access just won't be up to it.
I'll look for the migrating tools you mentioned, but i feel that any effort
now is better than having to rescue data later on.
Connection in the philippines can't beat acccessing your data on
You do not have to compromise. If reliability and speed is what you want,
then if you find US to produce faster results, set up mysql in the US with
replication locally. And yes, I agree, don't rely on access for stability.
If you want stability, go with mysql on a unix based system. Your
Thanks!
At 11:36 AM 2/7/2001, Rolf Hopkins wrote:
You do not have to compromise. If reliability and speed is what you want,
then if you find US to produce faster results, set up mysql in the US with
replication locally. And yes, I agree, don't rely on access for stability.
If you want
Look at section 7.19 SELECT Syntax of the manual. The line
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
is what you will probably be looking for.
- Original Message -
From: "Phillip M.(Mike) Bishop" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 07,
When tried running the mysql server, did it create the socket file? If not,
has security been set that prevents it from being created?
- Original Message -
From: "Alex Tapia" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001
Hi,
My website is running on MySql 3.21 and it has so much records that it sometimes
stopped running and
I had to restart the mysqld.
My question is how do I go about benchmarking my site and the mysql server?
TIA
Teddy
Hi,
I want to create a database for managing the attendance statements of students under
my supervision. I have mysql running on a debian machine (version 3.22.32-4).
I am unable to create the required tables as I am afraid I need a two dimensional
array which is not available(as I know) in
Start the deamon First
shellmysqld-XXX
To find out what X means go to the bin directory below and find out . d
stands for daemon
then key
shellmysql
Cheers
Donald
- Original Message -
From: "soon chee keong" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06,
If someone could give me some suggestions, please, I am getting
desperate.
I have a Slackware 7.0 system on which I am trying to install MySQL.
Kernel is 2.2.13
glibc was 2.1.2 upgraded to 2.1.3
compiler is egcs 1.1.2 (i think)
Any binary distribution works perfectly.
MySQL 3.22.23 and
hi!
I'm going to be building a system that will need to handle a fair bit of
data...
Basically I have tables that will eventually have millions of rows of
data, I believe I need to split them up for 2 reasons, 1, performance
(the tables will be quite active), 2, if a table get's corrupted then
Hello Miguel,
Wednesday, February 07, 2001, 5:52:50 AM, you wrote:
MAS I have made the following table on Win2000 machine:
C:\mysql\binmysql
MAS Welcome to the MySQL monitor. Commands end with ; or \g.
MAS Your MySQL connection id is 3 to server version: 3.23.30-gamma
MAS Type 'help;' or
hi,all
when i compile mysql on Solaris 2.6 ,
i just run : ./configure
it allways said :
checking return type of sprintf... configure: error: can not run test program wh
ile cross compiling
anybody help me ?
thanks thanks thanks
wallace
101 - 136 of 136 matches
Mail list logo