From: "Ed Reed"
> Is there way to return the ordinal position of a value within a table?
>
> Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by
the ID field I'd like to know what position the number '55
From: "Sebastian"
> i never understand why people use datetime anyway.. unix timestamp is so
> much easier to work with.
Maybe because dates before Jan 1, 1970 have an undefined timestamp and dates
beyond 2038 cannot be used with 32-bit integers? Quite a few people were
born before 1970 and someti
From: "Keith Ivey"
> Jigal van Hemert wrote:
>
> > Maybe because dates before Jan 1, 1970 have an undefined timestamp and
dates
> > beyond 2038 cannot be used with 32-bit integers? Quite a few people were
> > born before 1970 and sometimes one needs to store the
From: <[EMAIL PROTECTED]>
> That's what I Ntried to say, yes :) The main problem is the decimal comma
> in the amounts.
What about reading the data into the table and storing the 'amount' in
varchar for now. Then you can run an update query in which you replace the
decimal comma with a decimal poi
From: "d2clon"
> im very interested about the limitations and hardware features support.
> for example:
>
> software limitation:
> how much rows does a table can to have?
> how much size of a database does mysql support?
These depend on the version of MySQL and the OS
The number of rows is virtual
From: "Patrik Wallstrom"
> Using 5.0.7-beta the "drop trigger" functions in a very mysterious
> way:
>
> mysql> use testdb;
> mysql> drop trigger foo;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right
> syntax
From: "Sujay Koduri"
> I guess anywhere we have 3 levels of hierarchies for a phone number.
> (Country code, Area code and the actual number).
That's a pretty wild guess IMHO. You have to be absolutely sure that this is
true for each and every country in the world. Furthermore, various telecom
pr
Hi all,
We're trying to get a new 64-bit machine going to get around the memory
limitations of the 32-bit machines we have. On this dual Opteron server with
8GB memory we've installed Fedora Core 4 and MySQL 4.1.13.
Our sysadmin configured MySQL to use a 7GB buffer pool to accomodate a few
big ta
Hi Joerg,
From: "Joerg Bruehe"
> Jigal van Hemert wrote:
> > 050726 14:13:12 mysqld started
> > 050726 14:13:12 InnoDB: Error: cannot allocate 7340048384 bytes of
> > InnoDB: memory with malloc! Total allocated memory
> > InnoDB: by InnoDB 78086952 byte
Nick Sinclair wrote:
"[.] WHERE date_format(timestamp, '%Y-%m-%d %T')
<=DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR)"
* ...It only resolves to the DAY and not an hourly resolution. I have
included a script below that I use for debugging, the MySQL
functionality is taken directly from on
Lee Denny wrote:
Hello,
I'm trying to get the date and amount of the most visits to my site over a
given time period using :
SELECT max(visits) as maximum FROM visit WHERE (((visit_date >=
'$sdatestring') and (visit_date < '$edatestring')) and (site_id=$site_id))
This gives me the right figure
Ben Clewett wrote:
It had been suggested that our DNS failed prior to this event. I don't
think MySQL uses DNS, but I am not entirely sure.
If the db, user, etc. tables in the mysql system database (containing
privileges, etc.) contain host names instead of IP-addresses I suspect
it needs a
Gleb Paharenko wrote:
In my opinion, one of the causes of the problem can be the processing
of trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
"William R. Mussatto" <[EMAIL PROTECTED]> wrote:
I was storing some 8 bit information in a varchar b
Philippe Poelvoorde wrote:
Enrique Sanchez Vela wrote:
I would like to have MySQL differentiate between 'abc'
and 'ABC' both the server and clients. so far anything
I've done has not worked.
Is altering the column type an option ? If yes, you would change any
'text' for 'blob' and any 'varcha
Joseph Cochran wrote:
Some countries have multiple timezones, so it is not sufficient to
know the country code in order to get the timezone. If they have
previously posted the timezone, however, then it should be possible to
store that information in a cookie on the client machine that your web
l
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE )
- output of EXPLAIN
This way the list members can make better suggestions.
Regards, Jigal.
-
Tim Johnson wrote:
it get worse . most of my commercial work is running on
servers with ver 3.23.X (sun and RH servers). I enjoy a
great relationship with my domain hoster (who is also a
programmer who uses mysql a lot), but he has been very
cautious about
Konrad Billewicz wrote:
Hello,
I would like to do thing exactly like CREATE TABLE a LIKE b. But... I have MySQL
3.23 and this command is available since 4.1. How would you handle this task
using this, older MySQL?
http://dev.mysql.com/doc/mysql/en/show-create-table.html
Use output of SHOW C
[EMAIL PROTECTED] wrote:
MySQL has moved WELL past the 3.23.x lineage and is getting close to
retiring the 4.0.x lineage (it's only a rumor). So I suggest you update
Not completely a rumor; on August 2, Heikki wrote: "As far as I know,
one release of 4.0 will still be built."
Considering th
- Original Message -
From: "Kishore Jalleda"
as per
http://dev.mysql.com/doc/mysql/en/replication-compatibility.html
there should be no problems
On 8/17/05, Jeff <[EMAIL PROTECTED]> wrote:
> Does anyone know if there are any problems replicating from a master
> database on version 4.0.16 t
Pooly wrote:
Hi,
I would like to display a list of members who have their birthday a
given day (today for instance).
For such an application I've used a single integer column to store a
number consisting of the month and day (day as 2 digits!!!) concatenated.
So dates range from 101 to 1231.
Gyurasits Zoltán wrote:
Hello All!
I have a little problem. I can't do "serial number" in result of select.
I guess you want to display a sequential number for each row in the result.
First of all a warning: if there is no ORDER BY in the query there is no
specific order in which the result
Jeff Pflueger wrote:
Hi. Thanks for any help on this. I've been beating my head over it for
hours.
Here's what I am trying to do: I have four tables I am joining via a
unique key (Fellow_id).
The results I want to group into three categories, each alphabetized
within the group.
Is this too mu
Schalk Neethling wrote:
You guys should subscribe to the Planet MySQL RSS feed. The entire issue
was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
Maybe the "MySQL AB staff" could take the trouble of answering posts
about this issue on this list? Maybe the an
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die("Couldn't get
file list");
if (!isset($result))
{echo "NULL";}
Bill Whitacre wrote:
printf(" {$thearray[org]}
{$thearray["COUNT(*)"]}
$ {$thearray[cost]} ");
If I replace
{$thearray[cost]}
with
number_format({$thearray[cost]}, 2)
Although this is a MySQL mailing list and your problem is not MySQL
related, but a PHP question I'
Eli wrote:
Is it possible, or probably will be possible, to define indexes spanned
on more than one table?
I mean that if I have column col_a from table tbl_A, and col_b from
table tbl_B.. Can I define a KEY with both those columns? Where will the
index be saved?
Just out of curiosity and to
Eli wrote:
The reason I thought about this is that I got several tables that hold
their own specific data and are indexed inside themselves. But I got an
issue to search on JOIN of 2 or more tables with comparison and/or
ordering on combinations of fields from the various tables. This usualy
- Original Message -
From: "Chris Kantarjiev" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 19, 2005 9:06 PM
Subject: very large key_buffer on amd64?
> We're starting to use mysql (4.0.25) on an amd64 machine (running
> NetBSD-3). One of the reasons for doing this is to use much more
Martijn Tonies wrote:
Given that the OP did not state that there were any issues with an
existing website, logical requirements come first. Period. No discussion ;)
Logical requirements may come first, but may be overruled later by
requirements caused by performance issues or system limitation
C.R. Vegelin wrote:
Hi All,
Does anyone know how to use the format() function in such a way that is
displays numbers right justified.
For example, see the following query, where I want no decimal places:
SELECT 123456.789 AS X, FORMAT(123456.789, 0), FORMAT(123456.789, 0)+0;
The 1st column is n
Stephen A. Cochran Lists wrote:
I'm getting a strange ordering when using ORDER BY on a int column.
The rows are being returned sorted as follows:
The list is typically the way to order a string.
You are most likely to get meaningful suggestions to solve the mystery
if you include the table
Balazs Rauznitz wrote:
I have replication set up. Is it OK to alter one of the slaves and add
several indexes ? It did seem to work, but I'd like to be sure.
Replication does nothing more or less than copying the queries that
alter the tables (inserts, updates, alter table, delete, etc.) to th
Jason Ferguson wrote:
The data is split into about 60 files, average file size of 5 MB (varying
from 1 to 10 MB). Since there are many files, I'm trying to minimize the
required work (if there was just one consolidated file, no problem).
The work can be automated easily with the right tools ;-)
Mysql Lists wrote:
I'm hoping they get replication setup by "diffs", only sending the diffs
that are tracked from the master.. replicated to the slave.. That would
be sweet :)
On 9/27/05, *Jigal van Hemert* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
wrote:
Gleb Paharenko wrote:
I'm not giving an exact answer on your question, however, it might be
interesting for you. Usually queries are faster if you define the column as NOT
NULL.
What's the reason behind this? NULL 'values' are a bit of strange
phenomenon. In the EXPLAIN output a query with WH
Matthew Lenz wrote:
anyone using openoffice:base to design mysql db's? back when I tried it
earlier this year it wasn't able to define relationships which made it
pretty much useless as a time saving tool.
Hi Matt,
Although it's slightly OT here, there is still a lot of development
going on
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for "dsl" will not find "DSL-Modem"
I looked it up on mysql.com help, but despite the fact that this is not
seperated by sp
C.R. Vegelin wrote:
Hi, I am looking for a method to use variable table names.
I have various download-tables, all having the same structure.
All I want is to run a series of queries on each of these tables.
I tried
SET @mytable = 'Download200501';
SELECT count(*) FROM @mytable;
but this doen't
Remo Tex wrote:
1) that's common problem when doing custom install on PATH containing
spaces like "C:\Program Files". Solution - try custom location with
short(er) path and without spaces like "C:\mysql5013\". Probably that
will solve problem 2. if not then..
Remo Tex,
That is not a good exc
Merlin wrote:
I am wondering if it is possible to find words inside words with the
help of fulltext search.
Is this possible? Google does that, so somehow there should be a way.
Somehow I don't think that Google runs on a single MySQL database. Full
text indexes in MySQL mean that "words" (My
Ananda Kumar wrote:
Hi Friends,
I want to set the default date format as dd-mon-. How do i do this in
mysql.
The short answer: not.
http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html
lists the variables you can change by the SET GLOBAL or SET SESSION
command. 'date_forma
Kane Wilson wrote:
But when i try to store little but huge gif files it wont store .
First of all, use the method described at
http://www.php.net/manual/en/features.file-upload.php for a safe way to
handle file uploads. It could be that you run into a server limit which
will show up if you u
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts & digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access contr
- Original Message -
From: "Hiu Yen Onn" <[EMAIL PROTECTED]>
> if i uncomment it, then mysql server wont start at all. if i comment it,
> then, that's ok. please advise. thanks again
If the mysql server does not start it will probably leave a lot of messages
in the error log. If you sen
Octavian Rasnita wrote:
Is there a command for renaming a MySQL database?
Sorry, there is no command for that. For small databases you can use
administration tools like phpMyAdmin, etc. which will do it for you by
duplicating the database structure and data, and then drop the 'old'
database.
C.R. Vegelin wrote:
What about renaming the folder indicating the database name.
I work with Windows XP and renaming a folder works well.
Cor,
Have you tried it with InnoDB tables or anything other than MyISAM
tables? InnoDB uses a single tablespace per server (unless specified
that it shoul
zhou bin wrote:
hi,
mysql is a very goode software,so i made mysql_3.23_58 and mysql_4.1
in two of my server, and i changed the root password, but why i can't
connect to the mysql server from a client pc(use mysqlcc or any other
tools)?
the error message is:
[206] ERROR 1130: Host '218.4.**.***
Andrew Roth wrote:
Hi all,
We are a group of three students in Professor Ric. Holt's Software
Architecture class at the University of Waterloo. As our project, we
would like to examine the MySQL source to determine the best way to
implement materlialized views.
It would be wise to hang around
Martijn Tonies wrote:
| Warning | 1264 | Out of range value adjusted for column 'a' at row 1
Could be me ... but isn't this a little too late?
eg: AFTER you have lost your data?
IMO, it should raise an error UNLESS you force it to truncate the data.
This would contradict the "MySQL design phil
G G wrote:
I have two tables:
Records:
member_id - int
question_id - int
Questions:
id - int
I'm looking to select a random id from the questions table, given that there
is no record of the user already answering that question.
SELECT * FROM `Questions` AS t1 LEFT JOIN `Records` AS t2 ON t
mem bob wrote:
| id | model | service_id |
||---||
| 1 | 500 | 1 |
| 2 | 500 | 3 |
| 3 | 500 | 10 |
| 4 | 600 | 1 |
From this table i want to extract all distinct models which have
service_id=1 *AND* service_id=3
The JOIN-construction is something like:
SELECT `model` FR
From: "Tom Brown" <[EMAIL PROTECTED]>
(...)
> starting at say 1GB and then 'extending' to 25GB. So is it possible for
> all datafiles, rather than just the last one, be 'autoextending'
The short answer: no.
http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html states:
" The autoextend
Aleksandra wrote:
I've written a search machine. It's working quite well, but I have two
problems:
1. When I give the following syntax : cat and dog , as a result I get
everything with at least one of the words: 'cat', 'dog' but also 'and'.
What can I do, so that it's not looking for the wor
Wenca wrote:
SELECT * FROM tab_p WHERE d_id = 20602 AND name LIKE 'Machico'
-> no results
Try it with ...AND `name` LIKE '%Machico%';
I have encountered it once when there were non printable characters in
front of or after the text itself. Very frustrating!
You can see what extra characters
Tom Brown wrote:
hmm i'm not entirely sure i fancy adding another data file on the fly -
Can you give me a brief run down about how you would go about this?
My collegue the sysadmin usually takes care of keeping the databases
happy. But AFAIK it's a matter of modifying the setting in the .cnf fi
Eldon Ziegler wrote:
We have a geographically dispersed system with a database of student
status information that needs to be replicated in as near to real time
as we can get. The MySQL master-slave method of replication doesn't seem
applicable as students can login to any server and pickup whe
Stefan Kuhn wrote:
Am Thursday 27 October 2005 12:56 schrieb Raphaël 'SurcouF' Bordet:
Le vendredi 16 septembre 2005 à 18:14 +0200, Stefan Kuhn a écrit :
I'm using it with four machines (geographically separate) and it works
fine. Stefan
And can writes on each server in simultaneous time ?
Aleksandra wrote:
Jigal van Hemert wrote:
I assume that you use Full-Text searches (but somehow you have managed
to change the default minimum word length to three).
As far as I understand what you've written - if I change the minimum
word length to 4, I won't get any result with the
David Blomstrom wrote:
I have a PHP script that displays data like this:
Eurasia
Eurasiaisland
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiaisland is a
parent of an ecological system that is associated with
a continent. For example, Borneo would be
Eurasi
[EMAIL PROTECTED] wrote:
wang shuming <[EMAIL PROTECTED]> wrote on 10/31/2005 01:11:06 AM:
How could run mysqld-nt.exe in background on win2000/XP, not as a
would be useful in HIS operating system. AFAIK, there has never, ever,
been a Windows (or DOS) command or command modifier to launch an
e
Barry wrote:
Can someone plaese help? I have three tables 1st is a collection of
propertys, 2nd is a list of facilities(98 in total) and the third is a
list of property id's corresponding to the facilities id's offered at
each property,
The query I am running:
'SELECT'
'`'.$type.'`.`id`,'
'`'.$t
Shankar Unni wrote:
[EMAIL PROTECTED] wrote:
If I understand the InnoDB engine correctly, I don't see how they
could speed it up unless they start tracking how many records belong
to each active "version" within a database.
But one thing you can do to speed it up somewhat is to do a
COUNT
Marc Pidoux wrote:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and several
applications all linked together, I can't create it once and change i
Scott Haneda wrote:
I have a field `fedex`, in it is text date, in tab sep \n delimeted form,
for example:
90FedEx Home Delivery (Residential) 14.06
20FedEx Express Saver 22.63
(...)
Is there some way I can do some string parsing on the text field and get to
the 3
[EMAIL PROTECTED] wrote:
Jigal van Hemert <[EMAIL PROTECTED]> wrote on 11/02/2005 03:29:14 AM:
> If I understand
> http://dev.mysql.com/doc/refman/5.0/en/table-and-index.html
> correctly, the index of the primary key is stored as the clustered index
> together with the data
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job
Lindsey wrote:
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to
know h
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes again to the rescue ;-)
Appendix G [1] tells us:
Eamon Daly wrote:
I don't know why I have so much trouble visualizing indexes,
but such is life. Imagine a simple table with only two
columns: user_id and foo_id. I will only ever be looking up
records in this table by user_id, but I will always retrieve
both fields. Figure a million rows and may
Noel Stratton wrote:
more thing that I can not figure out. I would like to sum all calculations
created out of the "Total Amount Owed" field that was created.
Noel,
Take a look at the WITH ROLLUP modifier of GROUP BY [1]. This is
available since version 4.1.1.
Regards, Jigal.
[1] http://d
InterNetX - Andreas Prasch wrote:
Hi,
I have a master and a slave mysql server. On the master I write binlogs
needed for replication. From time to time I have chronological
auto_increment problems, here's a short explanation.
- the table structure :
| Field | Type| Null | Key | Default |
Paul DuBois wrote:
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:
Lindsey wrote:
but do you know how to use the * in regexp searches. err what i mean
if i want to search for * and not use it as asterix?
" To use a literal instance of a special character in a regular
expression, precede
Scott Haneda wrote:
Hello, with the release of 5, I seem to have all dead links to my old docs
for mysql 4. The way they keep changing the urls is a little maddedning :-)
I usually search using: http://www.mysql.com/
http://www.mysql.com/subquery will lead to:
http://dev.mysql.com/doc/refman/
[EMAIL PROTECTED] wrote:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '.manufacturers_id = m.manufacturers_id )
LEFT JOIN specials s
USING ( p.produc' at line 4
What's the error in the query?!!?
[EMAIL PROTECTED] wrote:
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and p.prod
Joseph Alotta wrote:
greetings,
I know this is pretty basic stuff, but I couldn't find an answer in
google.
1. I want to set the @maxdate variable, but mysql complains. What am I
doing wrong?
> set @maxdate = select max(date) from positions where account =
> "111200512343222";
select (
Jonathan Chong wrote:
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB doesn'
Javier Diaz wrote:
I would like to know if there is any problem which cause Mysql to not
use date indexes at least you use the "=" operator, because if that is
the case we will need to re-visit a few queries
If you do a select instead of a delete, will the index be used? (You can
check th
Javier Diaz wrote:
EXPLAIN SELECT * FROM process_times
WHERE date <= date_sub(now(), INTERVAL 2 day)
date_idx,date_proc_idx
(NULL)
10778561
EXPLAIN SELECT * FROM process_times
WHERE date = date_sub(now(), INTERVAL 2 day)
date_idx,date_proc_idx
date_idx
1863456
My
Jan M schreef:
How do I update a record obtained from a query result while ensuring that:
1) The record is the actual record in the database not a possible duplicate,
e.g. is there a built-in record number identifying the actual DB record or
do I have to organise that in the table structure.
Th
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop temporary tabel temp_a if exists 'temp_a';
it said syntax error.
Try:
DROP TEMPORARY TABLE IF EXISTS `temp_a`;
('table' instead of 'tabel'; table name only once; backticks around
table name instead of quotes)
http://dev
Ben Clewett wrote:
But the index does not seem nearly as fast as liner (normal) indexes.
Hence using a less effective liner index may be better...
After this method I still need select a radius within these data points,
more effort.
This could be an excellent case for using HAVING
The WHER
Claudio Nanni wrote:
"Due to selling MySQL to Sun, Widenius earned about 16.6 million € in
(...)
I fail to see the relevance of this quote for this thread...
Regards,
Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
Claudio Nanni wrote:
If he really cared about MySQL he would have not sold it or prevent from
selling it to Sun.
Initially her was convinced that MySQL as a division of Sun would really
benefit the future of MySQL [1]. Obviously his relationship with Sun
changed "a bit" later on.
It shows tha
people requiring more powerful hard- and software
for their application are simply forgetting that they were supposed to
produce a working application and not the most normalized database with
all the fancy views and other stuff.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list arc
x datasets are even made more
complex by normalization, trying to be ultimately flexible and creating
a solution for problems which simply don't exist.
In almost all cases a simple solution will be the best.
Regards,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: ht
use is really useful, chances are that the
application is a lot simpler, faster and easier to maintain.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
1 DAY
GROUP BY `account_id`
ORDER BY avg_hits DESC
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
M and InnoDB tables.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
;>>No thanks, just take me to the downloads!"
Pretty simple to avoid the questions.
--
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
configuration of the
application was enough.
It really depends on the situation of your application which table
structure is the most suitable. Test the performance of all kinds of
operations you need to do with realistic data and various amounts of
data to see how it scales.
--
Jigal van Heme
ind threads with 'solutions' such as
"ignore this", "found it myself", "never mind, solved", etc.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
Hi,
On 2-4-2011 2:18, Thomas Dineen wrote:
Can't find file: './mysql/host.frm' (errno: 13)
http://tinyurl.com/3sc3ydx
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
eceived some messages off list from people
offering you tutoring for money. Nobody else saw those messages and your
replies looked a bit odd because of this.
Please keep track of whether a message came from the list or from
someone personally...
--
Kind regards / met vriendelijke groet,
tuations if possible without having to look for all possible
combinations of the encoded data.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
it the search for the last
10 to 20 days.
Of course this requires an index which includes gmtdate, but it can make
the result set before the limit a lot smaller.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
es in the schema and even changes in the data can
lead to changes in the behaviour.
You can make suggestions for the indexes to be used and you can even
force the use of an index if the query optimizer makes the wrong
decisions in a case.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
ry. If there are not
enough different values in a column (low cardinality) it might be faster
to do a full table search instead of first reading the index and then
having to go through the table anyway.
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
Fo
fear Google is right.
http://www.net-security.org/malware_news.php?id=1853
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[email protected]
1 - 100 of 320 matches
Mail list logo
