Naz,
Without going into detail about various projects I've seen, surfice it to
say that I have wittnessed some true horrors. In defence however, the
largest abomination I have ever witnessed was from an MS shop that had grown
a database from a MS Access system upward and had then, bluntly
Afternoon everyone,
Sorry, don't you hate the fact that the tab key submits your emails on
web clients!?
Anyway please ignore that last partial email, I've got myself stuck with
some SQL. What it boils down to is...
SELECT
wordgroup.Title AS `Keyword Group`,
site.Site_name AS Site,
Afternoon everyone,
Not been on here for a while, works been to hectic and this thing called
life keeps getting in the way ;^)
--
Regards,
Phil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
Neil,
The short answer is probably merge the two databases manually and
rebuild the index. I don't think there's any real answer otherwise.
Given the old version of MySQL you aren't going to be able to do
anything fancy like federating the two
Marten
In more recent version you can do a simple...
SELECT ENGINE FROM TABLES WHERE TABLE_SCHEMA = {database name} AND
TABLE_NAME = {table name};
...dunno how you'd do it on older versions exactly, you can do...
SHOW TABLE STATUS WHERE Name = BID_UNIQUE_IDS;
...but you can't select
Marten
In more recent version you can do a simple...
SELECT ENGINE FROM TABLES WHERE TABLE_SCHEMA = {database name} AND
TABLE_NAME = {table name};
...dunno how you'd do it on older versions exactly, you can do...
SHOW TABLE STATUS WHERE Name = BID_UNIQUE_IDS;
...but you can't select
Guys,
I doubt I'd qualify as an expert but here's my two pence worth ( ;^)
)I wrote a search engine a while back that relies heavily on full-text
searching and the three things I found that improved results were...
1) Precisely what Dan explains, doing extra biasing per field in the SQL
Jan,
In English I pronounce them as...
My-eye-sam
In-oh-dee-bee
...respectively.
Regards,
Phil
2007/1/7, js [EMAIL PROTECTED]:
Hi list,
Sorry for this silly question but I've been always had trouble
pronouncing MyISAM and InnoDB.
How do you pronunce them?
Thanks in advance.
When
Servers24,
Well this question may seem funny...
No, a funny question would start something like Why did the nun cross
the road?. ;^)
The problem is with counting a user's contribution in my site. Suppose
that
each user that send an email will be stored in DB. Now I want to count
number of
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql (not considering the filesize
limitations)?
Thanks
Olaf
The best is probably ZFS if you really are intent on make things huge,
Servers24,
Hi Philip,
Thank you very much for your help.
Can you please tell me the differemce between COUNT(*) and COUNT(id) ?
Thanks again.
Actually sorry I was a bit misleading there. MySQL is optimized to
calculate...
SELECT COUNT(*) FROM aTable;
...but given the fact you've got a
pay attention to when selecting the
file system
Thanks
Olaf
On 12/29/06 11:31 AM, Philip Mather [EMAIL PROTECTED] wrote:
Olaf,
Thanks for the detailed answer.
So basically the limitations come from the OS and the file system used.
What is the best file system to use for mysql
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as root?
You also say you can only see a test database, can you not see
Mohsen,
First off, what version of MySQL are you running and on what platform?
Now when i use --skip-grant-tables i can see my databases.
Please help me...
When you use MySQL via a shell I would assume you're logging in as root?
You also say you can only see a test database, can you not see a
Mohsen,
I'm not sure you're receiving any of this as you also seem to have a
rather over-eager spam filter as well...
Symantec Mail Security detected prohibited content in a message sent from your
address (SYM:40763633734165155763)
Subject of the message: Re: MySQL My program
Recipient
Chris,
On Thursday 07 December 2006 16:34, Ed Reed wrote:
Thanks for the quick reply Chris.
It's close but it's a little off. Your example also returns all
instances that where the letter N exists in another words as well
SELECT SUBSTRING(value,2) as value_num, value FROM num_test
[EMAIL PROTECTED] wrote:
Hi,
How much memory do you have on your system ? (the current setting in your
my.cnf could eat *a lot* of memory)
min_memory_needed = global_buffers + (thread_buffers * max_connections)
thread_buffers
---+-
sort_buffer_size
mos,
I'm looking for a free, perhaps open source, case tool for MySQL 5.x.
(Older MySQL 4.0 case tools may not work because of the changes to pw
security in 4.1 and later)
I tried MySQL Workbench 1.1.5 alpha but I keep getting errors The
following error occurred while launching the object
Kevin Old wrote:
On 12/8/06, Philip Mather [EMAIL PROTECTED] wrote:
So something like 15G, that's not that bad. I'd run mtop as someone
suggested and see if some query is hammering it, maybe some other
process on the machine is hogging or going IO bound?
Thanks. We are watching the queries
Has anyone here seen any software (preferably PHP and Open Source)
that connects to MySQL and allows people to build/design/modify
databases and tables?
I'm not really looking for something like DBDesigner or phpMyAdmin
although their close/similar to want I want, I'd like something more
[EMAIL PROTECTED],
hi,
i'm created a 'configuration' table:
create cofiguration (
config_key VARCHAR(25) NOT NULL PRIMARY KEY,
config_value VARCHAR(255) NOT NULL
) ENGINE=MyISAM;
I have about 30 records (store_name, store_owner, template_name,
website_width, owner_address,
Dan,
In the last episode (Nov 22), Alfred Mak said:
Can I shutdown one of the databases in MySQL but not the whole mysqld
process (i.e. keeping the other databases still running) ?
shutdown would be the wrong word then :) How about revoking
permissions (either at the mysql or the
Kieran,
Just make a backup of the database to a file using mysqldump and then
drop the database. If you need to recreate it again in the future, you
can use the mysqldump backup file.
Oh indeed, but if you got a xGB database that's not exactly going to
be quick. I'm thinking of instead of
Leandro Guimarães Faria Corcete DUTRA wrote:
On Wed, 08 Nov 2006 18:51:20 -0800, Rares Vernica wrote:
Is it possible to access the Full-Text Index structures from SQL?
What do you mean exactly? SQL is not intended for physical structures.
I started writing a little
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a
Warren Young wrote:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a
Jerry,
Is 9640 a word by itself? A full-text search wouldn't find abc9640,
No a full text search would find numbers pretending to be a word, the
full text search has a fairly high level definition of a word. Try
searching for 1960 over at http://ftvdb.bfi.org.uk/search.php.
Regards,
Jerry,
Is 9640 a word by itself? A full-text search wouldn't find abc9640,
No a full text search would find numbers pretending to be a word, the
full text search has a fairly high level definition of a word. Try
searching for 1960 over at http://ftvdb.bfi.org.uk/search.php.
Regards,
List,
Without getting into the specific problem the general debug path I'd
follow would be: -
1. Make sure you are actually connected to the database, you say it's
the admin area? Does the admin area login with different details? try
eching the result of a select NOW() right at the start
John,
How many databases does a single instance of MySQL Server 5.x support?
I suspect you'll get a bit of a shrug /, with a 64bit machine there's
a limit of 4.2 billion rows per table and with an XFS file system 8EB
per table, there's a join limit specified somewhere but I don't think
Dan,
Cheers for doing the translating, I'm one of those beardy types they
keep locked in a dark room writing search engines so my English isn't
spectacular ;^)
As Rolando points out your file system may place a limit on the
number of files or directories, but to my knowledge XFS has no
Kerry,
It gives me a solution and some reading.
No probs, here's some actual code that I hacked together on a
4.1-sommat-or-other database, an important thing to note is to be
careful of any Unique keys selected from the three individual tables as
they may no longer be unique of course
Ravi,
Knight 4 to Pawn's 5!
Sorry, being serious for a minute, you'd need more info to solve
this problem. Your example implies that something without a number after
it still counts for a value of 1, i.e.
and 3 if I am searching for WT.
Correct? What is the extent of the two letter
Bruce,
i had initially thought that i could have the following tbl structure:
UniversityTBL (
name
ID auto_increment,
)
In a generic kinda Best Practice, things I've picked up from various
places way I'd recommend the following things: -
1) The first field always be the Primary Key and
Brent,
Given that...
You really have to match cardinality with distribution of values.
...sounds like hard work (well you actually have to think about it) and...
considering all the above cases, what should I conclude? should I have
indexes on these three fields?
Looking for a specific
35 matches
Mail list logo
