> Hello colleagues.
Hi,
> How can I global lock a database?
> Global means that no user/process should be able to access it; I want to
> keep the database
> in read only for a certain period, NOT ONLY for the current session.
Have a look to Grant and User Privileges.
You can create a read only u
Hi,
> j'ai le red hat 9 et j'ai télécharger mysql-3.23.58-pc-linux-i686.tar.gz
> j'ai crée le repertoir /usr/local/src et j'ai fais
> gunzip mysql-3.23.58-pc-linux-i686.tar.gz
> tar xvf mysql-3.23.58-pc-linux-i686.tar.gz
> cd mysql-3.23.58-pc-linux-i686
> ./configure --prefix=/usr/local/mysql
>
>
Hi,
Have a look here :
http://www.mysql.com/doc/en/Windows_installation.html
Bye
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Hi list,
>
> I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
> important and so, i'm asking your help :)
>
> I'm using MySQL 4.0.15 under Linux.
>
> Here's a test query :
> mysql> explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
> LIMIT 234599,20;
>
+---
Hi list,
I'm trying to optimise a SELECT ... LIMIT query, perhaps i miss something
important and so, i'm asking your help :)
I'm using MySQL 4.0.15 under Linux.
Here's a test query :
mysql> explain SELECT * FROM F4000 WHERE ReplyTo=8711465 ORDER BY Numero
LIMIT 234599,20;
+---+--+---
From: "Willy Dockx" <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 7:23 PM
Subject: RE: French characters ok with mysql in Windows, nok with mysql in
Linux
> Hello,
>
> etc/sysconfig/i18n contains:
>
> LANG="en_US.UTF-8"
> SUPPORTED="nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en"
> SYSFONT="latar
From: "Willy Dockx" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 05, 2004 3:00 PM
Subject: French characters ok with mysql in Windows, nok with mysql in Linux
> Hello,
>
> I already posted this problem end of 2003, but probably, the champagne has
> troubled the answers.
>
> The
Tuesday, December 09, 2003 2:51 PM
Chris Elsworth wrote:
> If you increase delayed_insert_limit then you're effectively giving
> the DELAYED thread more preferencee to the table; it will write more
> rows (once it can, ie there's a phase of time where there's no locks
> on the table) in a batch, w
> > So, i'm using INSERT DELAYED with some good succes.
> >
> > But I've got a question.
> > If i decrease delayed_insert_limit to ten secondes for example, is that
mean
> > that delayed_queue will be flushed every ten secondes ?
> > Is there an other variable that specify the flush time ?
>
> No -
Hi list,
I've got a small MyISAM table which is used for some statistics.
I'm only doing insert into this table.
I need that clients doing INSERT queries can exit as soon as possible.
So, i'm using INSERT DELAYED with some good succes.
But I've got a question.
If i decrease delayed_insert_limit
Hi list,
I've just a crazy problem with Mysql 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz).
I have 2 user, root and Dstats.
With root, i can do all i want (create database, create table ...).
With Dstats i can't create table in a database.
My Grant :
grant all privileges on Dstats_Stats.*
Hi list,
I think i've found a little bug in MySQL 4.0.15
(mysql-standard-4.0.15-pc-linux-i686.tar.gz)
Description :
Here's my error log :
Warning: thr_alarm queue is full
Warning: thr_alarm queue is full
[...]
How To Repeat :
Here's my conf file :
[client]
port= 3306
socket
> Hi,
>
> I don't know if it has anything to do with your problem, I just wanted to
> comment on the use of a timestamp column in a primary key...
>
> * David Bordas
> > +--+--+--+-+-+
> >
> Hi list,
>
> I've got a little bug with MySQL.
> I can insert a row into my table but this row will not appear in the table
> :(
> Server is under linux redhat, MySQL is 3.23.56 installed from binary
tar.gz
> from MySQL team.
>
> Table Description :
> mysql> desc Log_Forums;
>
+--+---
>
> Can you create a repeatable test case ?
>
> Regards,
> Sergei
>
On the server where i've got problem, I tried making a dump and import dump
into a table with same name but into a different database.
There it works ...
So, i come back to my production database and table.
I've always got the sam
Hi,
>> mysql> select * from Log_Forums where Date="2003080611";
>> mysql> insert into Log_Forums (pseudo,date,Type_Message) values
>> > ("doss08",2003080611,"0");
>
> insert into Log_Forums (pseudo,date,Type_Message) values
> ("doss08","2003080611","0");
>
Same thing here.
But i "sol
Hi!
> Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating
> upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if
> MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if
> something is going to break if I upgrade.
>
> What are the main advantages
Hi list,
I've got a little bug with MySQL.
I can insert a row into my table but this row will not appear in the table
:(
Server is under linux redhat, MySQL is 3.23.56 installed from binary tar.gz
from MySQL team.
Table Description :
mysql> desc Log_Forums;
+--+--+
> Hi,
> I'm using GNU/Linux Slackware 8.0 and not using any my.cnf (so the
> configs are all at default).. Is it possible that mysql is doing some
background tasks while the system is in idle state ?
Which MySQL version did you use ?
Some old mysql binary were compiled with wrong glibc and have th
>Here's an example of how much data could be stored in a year:
>1 value/minute are stored = 1440 values/day.
>365 days / year.
>We have 100 different tables with 25 columns each.
>This makes 100*25*365*1440 = 1 314 000 000 values per year.
>A typical value could be 25,5624.
>How much space (in
Hi list,
I've a question about the database privilege and the Mysql.db table.
If i do something like this : GRANT SELECT ON MYDB.* TO [EMAIL PROTECTED];
( i'm using MyISAM tables ... )
And if MYDB contains something like 100 tables, could this make me problems
?
In fact, i have errors like this :
Hi,
>Was found problems with some glibc system, please use temporally the
>work around of the start the server with the option:
> --thread_stack=196KB >>
Ok i'll have a look to that.
For the glibc, i used binary tar.gz, so even if my glibc is buggy this'll
not affect me ...
>The access denied i
Hi list and thanks to read me.
Since december, I've got aborted_clients and aborted_connects to my mysql
server ...
Clients that connected to this server have errors like :
Failed to connect to database:
Error: Access denied for user: '[EMAIL PROTECTED]' to database 'mydb'
MySQL server has gone
> Anybody else who has any idea why the index are not used as they should?
I've got same things with 3.23.xx and select query through a TCP/IP
connection.
I don't know why, but you can solve this issue using the USE INDEX syntax
for select queries ...
http://www.mysql.com/doc/en/SELECT.html
Dav
Hi all,
I've some problem with my Mysql servers since the beginning of last week :(
I've upgrade mysql from 3.23.53a to 3.23.54a and i still have same errors :(
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database ´DB1
hi,
I always have my problem and i didn't find any solution pour the moment.
Please, if somone have an idea ... :(
Thanks
David
Subject: [Error] Mysql server has gone away && 3.23.53a
Date: Thu, 19 Dec 2002 17:23:31 +0100
I've some problem with my Mysql servers since the beginning of this week.
Hi all,
I've some problem with my Mysql servers since the beginning of this week.
I've got plenty of error like this :
Failed to connect to database: Error: Access denied for user:
´[EMAIL PROTECTED]´ to database ´DB1´
MySQL server has gone away
Error Nø1, please contact webmaster ...
In fact, c
> I have the following query. When executed in MySQL I get an error on the
> first sub-select, and I can't find why:
http://www.mysql.com/doc/en/News-4.1.x.html
You'll see that sub-select query will be in future 4.1.xx release ...
David
-
>> Have a look to the mysql error log to see if you can find your problem
...
>> This file should be in /usr/local/mysql/data
>>
> I have no log file, the only file created is .err with the
number of the thread who crash.
>
> touch13
>
This file IS the mysql error log.
On one of mine i can see thi
> Hello,
>
> I upgrade my server from Mandrake 8.2 to Mandrake 9.0 and i have a little
problem with MySql 3.23 (Ver 3.23.52 for pc-linux-gnu on i686):
> When i try to start MySQL with this command with "root" user :
> # safe_mysqld --user=mysql &
> I obtains the following response:
> # Starting mys
> I wish to tune our MySQL Server Parameter to increase
> the speed of Join. I was trying to do a simple join
> with two tables. One is big (~2,500,000 records); the
> other one is small. The current join seems to take
> forever to finish even on the indexed attribute.
>
> I am trying to learn from
> How can i extract names of columns from table? I am doing select *
> from table, then i want to get name of columnsis it possible?
Use desc or describe.
http://www.mysql.com/doc/en/DESCRIBE.html
David
-
Before posting,
> Could someone tell me where the logs are written to by default, for a 3.23
> install of MySQL on Linux?
>
> I looked in /usr/share/mysql/english and each directory leading up to it,
> but I didn't see anything resembling a log file.
>
> Thanks.
> Neal
Logs are in your data directory with the T
> Hi All,
>
> What's wrong if this error message appears when I try to run mysql:
> cannot connect to local Mysql server through socket
> '/var/lib/mysql/mysql.sock'
>
> If I run mysql_config, this appears:
> --socket /tmp/mysql.sock
>
> What should I do to correct this? Thanks.
Modify your my.
This problem is due to the glibc used by mysql AB for building binary ...
Have a look to mysql 3.23.53 change log :
<<
We've hopefully fixed the problem with spurious load spikes on Linux
> >systems when accessing the Database via TCP/IP. This was caused by
the
> >static glibc files we us
MR> We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2
x
MR> SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older
version
MR> of MySQL (we run only binary releases) for a long time (6 months) with
MR> great success. We had uptimes like 100 days and almost 200 que
Hi,
IM>I'm not either sure if they're used during normal operation, but that way
you
IM>could get a file number like (x / 3) + [a few files] where x is the
number of
IM>files with MyISAM. Also, InnoDB should support .frm:less tables someday
in
IM>2003 (at least www.innodb.com says so). But if you
Hi,
>I use mysql 3.23.4 max on linux and it have worked just fine.
>Now I want to use Transactions so I thougt that I should use the my.cnf to
configure for that.
>Trouble is there is no my.cnf file on my computer.
>Do I have to create the file myself ?
>or is the InnoDB settings configured righ
Hi list,
I've just a little question for the end.
I planned to have around 10K tables under a DB and this number surelly grow
up to 20K.
I know that a database is a directory and a table is 3 files.
I just want to know is mysql have a limit in the number of table per
database.
If not, i know tha
DB> I found my problem and why Mysql lock my table for a select. In
DB> fact, mysql sometimes don't use the right index and so does a 'Table
DB> sort' that lock my table. I modify the query to add USE INDEX
DB> clause and now, all seems to work well ... I just need to test
DB> during several da
> DB>I still have performance problem with my big MyISAM table.
> DB>In fact, mysql keep locking my table, even for doing select :(
PDB> That's how MyISAM works -- it uses table locks for everything.
PDB> Given that fact, if it didn't lock the table for reading, that would
PDB> allow other client
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
I don't know why but it's very very annoying.
1% of my query are search ones.
Theses queries are slow, too slow.
So i'm thinking about splitting my table to lot of l
Hi all,
Just a little question on the MyISAM table lock implementation ...
I just see ( with show full processlist ) that my version of mysql ( 3.23.45
binary linux tar.gz ) locked my MyISAM table at every query and not only for
update / delete / insert.
Why is it locking table for select query ?
From: "borracho 138" <[EMAIL PROTECTED]>
> Many thanks for the reply - nice to know that I'm not the only one with
this
> issue(!)
> Seems like my problem is related to 2 areas:
> - I'm concerned about the lack of memory 'freeing' with the system, but a
> kernel upgrade may fix that
Don't have t
From: "borracho 138" <[EMAIL PROTECTED]>
> I've searched for more information on these issues, without luck.
>
> The system randomly spirals out of control - load avg increases very
> rapidly, resulting in loads of 200-300 in 2/3 minutes. At other times the
> server is fine, handling the busiest
Hi,
> I have written previous websites where I used perl or PHP
> to access a Mysql DB wen bith the webserver and the Mysql
> db are on the same server.
>
> My questions is how different is it to access or connect
> to the Mysql database when the database is on a separate
> server(machine)?
Just
From: "Shashank Tripathi" <[EMAIL PROTECTED]>
> | Why not regexp but this is not i mean, in fact
> | " where CONTENT like '%word1%'
> | >or CONTENT like '%word2%'
> | >or CONTENT like '%word3%'"
> | shoud be :
> | " wher
From: "Shashank Tripathi" <[EMAIL PROTECTED]>
>This will be fast if you have the right index--
>field5 like 'John%'
>These will NOT be fast --
>field5 like '%John%'
>field5 like '%John'
>Putting a wildcard character ("%") before the term will avoid the index.
Yep, and it's for that p
BS> Have you tried the command : "EXPLAIN SELECT select_options"
BS> (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see
BS> what Indexes are used ...
Yep i do that but varchar and text fields aren't index so ...
I'm also having a look to FULLTEXT index, but i think that the
ME> In this case...
ME> Can you try again?
Sure.
query 1 :
> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR Field5 LIKE
> '% John%' ) ORDER BY Field6 LIMIT 0,20;
query 2:
> SELECT Field1,
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
> As I understand...
> After removing "Field5 LIKE '%John'" condition the query works much
faster.
Nop, sorry i'm not clear, the query works mush slower ...
> But it is different query... :)
> I mean that queries return different results.
Yep ...
>
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> IMHO the problem is in this condition
ME> ...Field5 LIKE '%John'...
>
ME> Can you remove it from query and try again?
In fact it was Field5 LIKE '%John%',
but "Field5 LIKE '%John'" and "Field5 LIKE '%John%'" don't change query
speed at all excep
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
DB> SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable
WHERE
DB> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
DB> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
DWP> h
- Original Message -
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> Can you send result of the query, please:
ME > select * from MyTable PROCEDURE ANALYSE();
Here you are :
mysql> select * from MyTable PROCEDURE ANALYSE();
+--+--+--++---
From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> Check the query plan
ME> EXPLAIN SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM
ME> MyTable WHERE
ME> Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%'
OR
ME> Field5 LIKE '%John') ORDER BY Field6 LIMIT 0,20;
From: "Andrew Izsof" <[EMAIL PROTECTED]>
DB > I know that '(Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR Field5
LIKE
DB > '%John')' part is the problem.
AI> The formula : '%John%' always sweeps through all of the records, because
it
AI> can't utilize any indexes, sorting, etc. But if you lea
From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]>
KF> an Index wouldnt help much , because of the 'LIKE "%..." '.
KF> If a wildcart is at the beginning of the search-string , an Index
KF> cannot help much.
Ok as i thought, index text field is a bad thing ...
KF> You have to think about why a
DB> Already done something like optimize :
DB> myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
ME> And? No result?
Some good result but nothing enough good :(
I'll have a look to fulltext search, perhaps i'll find something good.
I know that fulltext search only search for full wor
ME> As first step, try to optimize table with help of
ME> OPTIMIZE TABLE MyTable
ME> command.
ME> Any progress?
Already done something like optimize :
myisamchk -v -a -S --sort-records=1 ../data/jeuxvideo/MyTable
David
sql,query
--
Hi all,
I've discovered that we have a select query that blocked all others query to
this table.
99% of query used indexs, no join ...
But this one is a problem :
SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE
Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field
Config for us :
Linux Red-Hat
Kernel 2.4.7-10smp #1 SMP
Dual intel PIII
1 GB RAM
The problem occurs with these versions :
mysql-3.23.51-pc-linux-gnu-i686.tar.gz
and
mysql-3.23.52-pc-linux-gnu-i686.tar.gz
Cordialement
David BORDAS / JEUXVIDEO.COM
> David,
> Thursday, August 22, 2002, 9:48:14 AM, you wrote:
> DB> Victoria
> DB> Monday, August 19, 2002 11:58 AM, you wrote :
>
> VR>> Hi, David!
> VR>> You can find new 3.23.52 binary packages at www.mysql.com
> VR>> Could you install new packages and check if loading problem occurs
> VR>> aga
Victoria
Monday, August 19, 2002 11:58 AM, you wrote :
VR> Hi, David!
VR> You can find new 3.23.52 binary packages at www.mysql.com
VR> Could you install new packages and check if loading problem occurs
VR> again?
One of our production server is running 3.23.52 ( the tar.gz one ).
Uptime is 26 H
IK> hi list
IK> Can I also execute mysql commands from the shell.
IK> Something like this:
IK> % mysql -u root -pmypass --execute=use mydb; select * from mytable;
You can do something like this i think :
% mysql -u root -pmypass mydb --execute='select * from mytable'
David
---
Hi list,
I've just a tiny question.
I used mysql 3.23.49 linux binary package but i've got some problems with
it.
I should upgrade quite shortly because 3.23.49 binary package is buggy
... ).
We have load problems, memory eating ...
But i can't use mysql 3.23.51 binary package.
( see Re: 3.23.5
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Du
Hi list,
Same thing here, mysql 3.23.51 works well during about 2 hours then
suddently load average grow up to 200 and more ...
Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com
OS : Linux Red hat 7.2
kernel : 2.4.10
1 Go RAM
2 * Intel 1 Ghz
Du
Hi,
perhaps Mytop will be good for you ...
http://jeremy.zawodny.com/mysql/mytop/
David
- Original Message -
From: "Lasse Laursen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 10:56 AM
Subject: Performance Monitoring/Counters
> Hi all,
>
> Which tools would
hreads_created | 65680 |
| Threads_connected| 92 |
| Threads_running | 87 |
| Uptime | 132998 |
+--++
111 rows in set (0.00 sec)
Thanks
David
> - Original Message -
> From: "David BORDAS"
Hi list,
I've got lots of troubles with one of my mysql dedicated server.
The problem occurs time to time ( during peac or idle time ).
In fact mysql seem not to answer all connections.
Netstat show several connections "TIME_WAIT" and show process_list only show
1 ou 2 queries running ...
But on
Hi list,
just have this when connecting to my mysql dedicated server :(
The server is like this :
bi PIII 1 Ghz
1Go of ram
Raid 5 scsi hdds
Here is a tail of the error log :
020619 08:03:09 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
The system don't swap.
Using Linux 2.4
Hi list,
just a tiny question, i use mysql 3.23.51 ( tar.gz binary ) under linux.
All is fine, mysql is started without a problem ...
020618 14:28:04 mysqld started
/usr/local/mysql-3.23.51/bin/mysqld: ready for connections
I can see in /usr/local/mysql-3.23.51 some files like :
localdomain-bi
Hi list,
I've got a mysql dedicated server.
Some piece of hardware :
SMP : 2 * Intel PIII 1 Ghz
1Go of ram
Scsi - Raid 5 Hdds
Linux red-hat 7.2
This system run mysql 3.23.49 (tar.gz binary from Mysql.com ).
I only have one MyIsam table with around 5 Millions of records ( around 1.2
Go disk space
Think that even if mysql don't have connection, there are severals processes
running ...
For waiting connection for exemple.
<< with 11.5 Mgs or so >>
This memory is i think a buffer or a cache shared by each mysql process such
as indexes for exemple ...
David
From: <[EMAIL PROTECTED]>
To: "Ser
Hi,
Just connect to mysql and use this query :
show processlit;
http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html
You can also use slow query logs.
http://www.mysql.com/doc/S/l/Slow_query_log.html
David
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesda
Have a look to mysql error log located in /usr/local/mysql/data
David
- Original Message -
From: "Paul" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 12:15 PM
Subject: can't start mysql.server
> hi,
> my machine is compaq alphastation DS20E, and the mysql ver
I think you'll find some usefull infos here :
http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.2
3.x
Just one thing : 3.23.50 tar.gz and rpm is little different because Mysql
team used a newer gcc version ...
Bye
David
- Original Message -
From: "Inbal Ovadia" <
Hi list,
i know that 3.23.50 is a pre-released version. But if someone can tell me
when this version will be declared as stable so i will upgrade my linux
production servers running redhat 7.2 and gcc 2.96 with the tar.gz build
mysql.
Thanks
David
filter : sql,query
--
SMP is System Multi Processor
Like a server with 2 or more CPUs ...
David
- Original Message -
From: "webmaster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 1:07 PM
Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3
> So far I've experienced it on one SMP
- Original Message -
From: "Harpreet Kaur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 5:44 PM
Subject: mysqldump
> Dear group members
>
> I did a mysqldump on my machine at home to backup a database. I saved the
> file to the /home/backup folder at my work
Hi all,
just one question, i need to use an index on a specific query.
This feature in fact :
http://www.mysql.com/doc/N/e/News-4.0.0.html
<< ORDER BY ... DESC can now use keys. >>
And this one is only available in mysql 4.0.x.
I'll give a try to mysql 4.0 in a test server.
But i need some fe
> - Original Message -
> From: "MySQL Newsgroup" <@[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, April 19, 2002 2:55 PM
> Subject: Re: Select with Order By that don't use my INDEX :(
>
>
> > Subject: Re: Select with Order By that don't use my INDEX :(
> > From: Vic Cekvenich
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "David BORDAS" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 19, 2002 10:34 AM
Subject: Re: Select with Order By that don't use my INDEX :(
> David BORDA
I'm using mysql 3.23.49 on Linux redhat dedicated server.
Here is my query :
mysql> show index from MyTable;
Table: MyTable
Non_unique : 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name : Field0
Collation : A
Cardinality
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
> David,
> I could be wrong but since bigint isn't a date or time oriented data
> type I imagine this would be completely useless to you unless you are
> storing unix timestamps.
In fact i'm looking to a way to st
Hi,
i'd like to alter a table which have a date and time field so 3 Bytes for
date and 3 Bytes for time.
I'd table to add a new field to store date like this : MMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2
fields date + time and with
one unique field
Yes but in fact i forgot to say that i have to change a value of a column,
Ex dump all data from table where category = 2 and
insert all this data into the other mysql with category = 4 and not 2
I think with too connection
i can select all data then insert in new server
ben delete on the old ser
Hi all,
i've got a problem, i need to transfert some data from one database to the
same database but on a différent mysql server.
I think i can't do that easily via command line, so i'll try to make a C
script to do that.
If someone have some fonctions names that can help me ...
Thanks in advan
89 matches
Mail list logo
