Hi there i am designing a system where users can upload revised versions of
a file, so therefore newer versions of the file will need to be joined with
the older original file. I'd need to join the parent file id with the child
file id, would using a join table work ? I have tried something that
Hello,
What is the best way to search a table with about 500.000 rows of varchar
type.
---
/ id / time / name /
---
Like '%blah%' and x Like '%blub%' is too slow (takes about 20 sec)
I tried using a fulltext index and search by using MATCH() AGAINST()
The problem
On 8 Feb 2004, at 1:33, Marty Ray wrote:
I am new to mysql and I am having trouble getting started. I am using
a Macintosh G5 running OS 10.3.2. I got mysql installed and it would
run, however when I tried to create a database, I got an error saying
permission denied. I tried running the
On Fri, 6 Feb 2004, Alvaro Avello wrote:
the questions is , the wildcard in host field doesn't
involve localhost o a machine host's ? Which kind of permissions we
have to put in host fields to have a mobility and not to be afraid to
move our servers for an emergency ?
When the host field is
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote:
the only way I can connect to the server is typing
mysql -h localhost -u root
make sure you don't have a line skip-networking in your /etc/my.cnf
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks for your reply.
Let me try again.
In access, you can create views. These are called 'queries' in Access. The
current version of MySQL does not support views, as I understand it.
Using DBManager, I import all my tables and data to MySQL from Access. One
of the options during the import
Hello
I am new to mysql. What I want to do is give a user a right to create
databases with all rights but I do not want them to see the mysql
database I have tried the following
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
DENTIFIED BY 'some_pass' WITH GRANT OPTION;
then tried to revoke
Hello Daniel,
Try with: revoke show databases on mysql.* from [EMAIL PROTECTED];
If the user [EMAIL PROTECTED] issue show databases il will not see anymore
the databases mysql.
The revoke you were trying was not only on showing the database mysql but
revoke all the privilege, is is really
I'm having the same problem. I did a performance test, and
CHAR columns are significantly faster than VARCHAR (at
least on my platform - MySQL 4.1.1a on Win32). I setup a
webpage with my sample code (VB) so that you can run the
test yourself:
http://au.geocities.com/m_fagan/VARCHARvsCHAR.html
Is anyone on the list using Coldfusion MX with MySql? It's just I've hit a
problem I've been hitting my head against for a week or so. The coldfusion
people I know have hit a blank (but they are using SQL Server). I'm
stretching now in an attempt to find someone with experience of both sides?
Ian O'Rourke wrote:
Is anyone on the list using Coldfusion MX with MySql?
Yes.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I just upgraded my MySQL to distribution version 4.0.17 up from 4.0.15
(i think). I read in the readme file i think it was that the mechanics
or output of the timestamp column had changed. I had grown to like that
column type. What's the best way to handle this change? Espially
I started getting an error:
#1049: Too many connections
Around 10 hours ago, and I don't know what it means. My admin is sort of
a go between with the host provider, so I need to give him as much
information as possible to get the problem fixed.
I haven't made any changes to the site, although
probably you had over 100 connections to you SQL db, on tcp level.
the default max is 100 connections, perhaps you can increase it a little
--max-connections=200 for example (in your startup config)
hope it helps you.
cheers
--
Kind regards,
Remko Lodder
Elvandar.org/DSINet.org
Hi all!
Running 4.0.17.
I hope this isn't a stupid question, but it appears that OPTIMIZE TABLE is
NOT equivalent to:
myisamchk --quick --check-only-changed --sort-index --analyze
Maybe I'm missing something, but OPTIMIZE TABLE rebuilds both the data file
and the index file (I see a TMD and TMM
In reference to my earlier message, I think I've figured out that the
equivalent command for OPTIMIZE TABLE is:
myisamchk -r --sort-index --analyze
That isn't documented anywhere... and in fact, the French language version
says something conflicting (I don't speak French but a Google search
On 8 Feb 2004, at 19:37, Mark Hazen wrote:
*snip*
Here's my problem: I've got a bunch of tables with hundreds of
millions of
rows in them. Every night, I delete about couple million rows and
then run
millions of searches on these tables.
What should I worry about more? A sorted index or a
Brian L. Walter wrote:
Thanks for your reply.
Let me try again.
In access, you can create views. These are called 'queries' in Access. The
current version of MySQL does not support views, as I understand it.
Using DBManager, I import all my tables and data to MySQL from Access. One
of the
What's the nature of your query?
If it's using an integer index and that's what your searching on, then
having
it physically sorted is a Good Thing. If you're table-scanning your
main table, you're toast anyway. Finding ways of making that faster is
the
way to go, maybe partitioning your
On 8 Feb 2004, at 20:28, Mark Hazen wrote:
My tables are just 2 INT columns. I have unique indexes on them going
both
ways.
Sounds like you're sorted.
You know, this might sound strange, but does the performance drop off at
all if you lose the indices? A table scan of rows 8 bytes wide is
wrote:
Hi all,
now that MySQL 5 has support for Stored Procedures,
i was wondering if anyone managed to port (or migrate) the
Stored Procedures from MS Access to MySQL ??
(With Stored Procedures i'm referring to "queries" as they're
called in MS Access)
Regards to all / Mihalidis
You know, this might sound strange, but does the performance drop off at
all if you lose the indices? A table scan of rows 8 bytes wide is going
to be pretty damn quick. Plus there's a lot less maintenance to do
without
indices and no risk of them getting corrupted.
A full table scan is
Buyer beware ...
I was a bit surprised when I learned there was a version 3.0 of MySQL-Front
... the developer of MySQL-Front shut down the project after version 2.5. As
it turns out, this new version is unrelated to the original project created
by Ansgar Becker.
Though it has many of the same
Hi all.
I'm about to attempt to implement the method of storing heirarchical
information described at: http://www.sitepoint.com/article/1105/2
However, in the comments section of the article, a couple of people are
saying that there is an issue with the author's method of adding
children to
I have some general questions:
#1 How many simultaneoulsy connection can mysql server handle?
#2 Is there a limitation in how many processes can mysql handle?
Thanks
_
Keep up with high-tech trends here at Hook'd on Technology.
In the last episode (Feb 09), Mike Mapsnac said:
I have some general questions:
#1 How many simultaneoulsy connection can mysql server handle?
#2 Is there a limitation in how many processes can mysql handle?
As many as your OS's threads implementation can handle.
---
Dan Nelson
Marty,
I've copied the list on this reply. I hope you don't mind. It's a good
idea to keep the discussion on the list. There are a lot of experts
there, so the speed and quality of your answers is improved when you
send to the list rather than to an individual. Plus, others may benefit
Yes, what's your problem?
-Original Message-
From: Ian O'Rourke [mailto:[EMAIL PROTECTED]
Sent: Sun 2/8/2004 12:52 PM
To: [EMAIL PROTECTED]
Cc:
Subject: MySQL and Coldfusion
Is anyone on the list using
As I understand it, fixed-length *rows* are faster than variable-length
rows, as mysql knows exactly where each fixed-length row starts in the
file. Once your table has any variable-length column, however, you have
variable-length rows. In that case, the smaller the rows the better,
Perhaps he really intended to revoke all privs, but he had a syntax
error. In that case, to revoke all rights for the mysql db from a
particular user ([EMAIL PROTECTED] for example), you would issue
REVOKE ALL ON mysql.* FROM [EMAIL PROTECTED]
Daniel was missing the '.*' after mysql, which
Thanks for reply Micahel,
Basically, my primary concern is speed (or actually, cpu
loads). I don't care about space - I have a fairly small
database but its going to be linked to a webserver that
will be getting a lot of hits. I'm trying to squeeze as
much performance out of the DB as I can so
Hi folks,
I'm using MySQL for survey data collected during my postgraduate study. I
have MySQL installed on C-drive (WindowsXP) but wish to store the data on
D-drive. (I try to keep C-drive sequestered for installed software
only.) I have a feeling that I saw something in the manual that
On Monday 09 February 2004 05:23, Rick Duley wrote:
Hi folks,
I'm using MySQL for survey data collected during my postgraduate study. I
have MySQL installed on C-drive (WindowsXP) but wish to store the data on
D-drive. (I try to keep C-drive sequestered for installed software
only.) I
Is it possible to have an update statement that uses curdate()?
Example:
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = (SELECT curdate());
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 10:42 PM
To: [EMAIL PROTECTED]
Subject: is it possible...
Is it possible to have an update statement that uses curdate()?
Example:
35 matches
Mail list logo