Am 28.03.2013 19:43, schrieb Rick James:
> I have never traced a performance issue in InnoDB to the need for OPTIMIZE.
but with files_per_table you can get back GIGABTYES of disk-space
depending on your backups this may be relevant
> The Query Cache is irrelevant to this discussion
it is NOT b
he need for OPTIMIZE.
The Query Cache is irrelevant to this discussion.
> -Original Message-
> From: Bheemsen Aitha [mailto:pgb...@motorola.com]
> Sent: Thursday, March 28, 2013 8:59 AM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: Defragmentation of
optimizeall() is simply called from a cron script
the mysql-wrapper does not exist in public but you get the table
overhead with "SHOW TABLE STATUS" as you can see below
Am 28.03.2013 16:59, schrieb Bheemsen Aitha:
> I would like to implement your strategy of optimizing tables. Can you please
>
Hi Reindl,
I would like to implement your strategy of optimizing tables. Can you
please share how are running these scripts? Where does the
mysql-wrapper-class exist? And what parameters need to be passed?
Thanks
Bheem Aitha
MySQL and Oracle DBA
On Mar 28, 2013 4:43 AM, "Reindl Harald" wrote:
>
Hello Antonio,
As Reindl said, it is recommended but it shouldnt be done just
everyday if your tables are quite big and you use query cache.
If you do have lot of writes and deletes (depending on what you
consider a lot), your table will indeed have lot of 'blank rows' which
eat disk space.
Opti
Hello Manuel,
Exactly. My objective doing performance MySQL it isn't to free disk space
(it isn't the problem). I would like to get a good performance using cache
and setting good values to configuration variables.
I will defrag tables once per month.
Best regards,
Antonio.
Ok. Thank you very much.
Best regards,
Antonio.
Am 28.03.2013 12:28, schrieb Antonio Fernández Pérez:
> So, is it not necessary (not recommended) to defragment tables if I have a
> lot of write operations (writing or deleting)?
it is recommended but not permanently and not blindly
i use a daily cronjob which runs optimize table on tables wit
Hi Reindl,
Thanks for your reply.
So, is it not necessary (not recommended) to defragment tables if I have a
lot of write operations (writing or deleting)?
Best regards,
Antonio.
Am 28.03.2013 12:09, schrieb Antonio Fernández Pérez:
> Hi everybody,
>
> Once I have done the defragmentation of MySQL tables, mysql-tunner.pl suggests
> me do it again. Is this correct? I think that the idea is that in the
> result of the script there are not fragmented tables ...
>
> Any ide
Hi everybody,
Once I have done the defragmentation of MySQL tables, mysql-tunner.pl suggests
me do it again. Is this correct? I think that the idea is that in the
result of the script there are not fragmented tables ...
Any ideas?
Thank you very much.
Best regards,
Antonio.
In the last episode (Aug 25), Moon's Father said:
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will
> be big appreciated.
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
Hi.
For example, entering mysql command line client,
mysql> pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
Hi
If you don't mind keeping the general log, you can periodically parse it. I
read that MySQL 5.1 (or some later version) will have an option to keep the
general log in a table - that will be very handy.
Be careful if you use this option (logging to a table) - while it's an
extremely att
008, you wrote:
>
> Hi,
>>
>> Is there any way to figure out how many, if any, people are accessing and
>> using our MySQL server?
>>
>> I am aware of the SHOW PROCESSLIST command, but this one only shows how
>> many processes are currently running. I would
there any way to figure out how many, if any, people are accessing and
> using our MySQL server?
>
> I am aware of the SHOW PROCESSLIST command, but this one only shows how
> many processes are currently running. I would like to register this
> information, and be able to analy
At 02:32 PM 12/21/2008, you wrote:
Hi,
Is there any way to figure out how many, if any, people are accessing and
using our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how
many processes are currently running. I would like to register this
information
Hi,
Is there any way to figure out how many, if any, people are accessing and using
our MySQL server?
I am aware of the SHOW PROCESSLIST command, but this one only shows how many
processes are currently running. I would like to register this information, and
be able to analyze it later
On Mon, Sep 8, 2008 at 12:47 AM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 08), Yi Wang said:
> > According to the mysql manual, I changed key_buffer_size from 8M to
> > 512M. But In mysql administrator, key buffer hitrate seems stay
> > unchanged. And key buffer usage alway
On Mon, Sep 8, 2008 at 12:47 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Sep 08), Yi Wang said:
>> According to the mysql manual, I changed key_buffer_size from 8M to
>> 512M. But In mysql administrator, key buffer hitrate seems stay
>> unchanged. And key buffer usage always be
In the last episode (Sep 08), Yi Wang said:
> According to the mysql manual, I changed key_buffer_size from 8M to
> 512M. But In mysql administrator, key buffer hitrate seems stay
> unchanged. And key buffer usage always below 4M.
>
> The total db size is about 200M. And the system's load is sligh
| 357751 |
| Key_blocks_used| 3820|
| Key_read_requests | 2170473 |
| Key_reads | 11343 |
| Key_write_requests | 6339|
| Key_writes | 1693|
++-+
7 rows in set (0.00 sec)
My question is: In a light load system, how many key bu
Hello guys
before to a last doom requeriment,
i used to work with
this type of relation
ArticuloNoAuto (english ArticleNoCar like MotorCycle or Motor)
and CabeceraComprobanteVenta (like a header of Receipt of some sell
"SalesReceiptHeader")
so 1 CabeceraComprobanteVenta can [b]sell/contain one
On 12/6/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
-Original Message-
>
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 06, 2006 3:37 PM
> To: MySQL General
> Subject: How many records in table?
>
> What's a quick query to deter
On 06/12/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
Use SELECT in with count(*)
SELECT count(*) from YOUR_TABLE
Mikhail Berman
Thanks, Mikhail. Will do.
Dotan Cohen
http://what-is-what.com/what_is/xss.html
http://english-lyrics.com/
--
MySQL General Mailing List
For list archives: htt
Use SELECT in with count(*)
SELECT count(*) from YOUR_TABLE
Mikhail Berman
-Original Message-
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 3:37 PM
To: MySQL General
Subject: How many records in table?
What's a quick query to determine how
What's a quick query to determine how many records a given table
contains? I don't think that a SELECT query is appropriate, as I don't
intend on doing anything with the data selected. Note that I'm
interfacing with MySQL via php, if that matters. Thanks.
Dotan Cohen
htt
indexes on a table to
optimise all of your queries. Sometimes this makes the indexes much
larger
than the data itself.
Hope this helps,
Andy
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2006 16:04
> To: John.H; mysql
> Subj
much larger
than the data itself.
Hope this helps,
Andy
> -Original Message-
> From: Brent Baisley [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2006 16:04
> To: John.H; mysql
> Subject: Re: How many colums should a index contain?
>
> I think you want to create separate
it would still
have to search half the database, might as well search the whole thing.
Create separate indexes on the fields you mostly search on.
- Original Message -
From: "John.H" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Thursday, November 02, 2006 3:25
John.H wrote:
but why when I do a query with 'explain' ,it shows that the
'possible_keys' is null or primary rather than the index I just create
Please always CC the list - you will get much faster responses and
others will be able to offer their input as well.
Post the query, the explain
John.H wrote:
I have two tables and I must do :
select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in
( ...this is a subquery in table2 )
should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my
query
will take less time
or should a index contain so many colums?
I
I have two tables and I must do :
select `id`,`bid`,`title`,`link`,`bname` from table1 where `bid` in
( ...this is a subquery in table2 )
should I create a index (`id`,`bid`,`title`,`link`,`bname`) so that my query
will take less time
or should a index contain so many colums?
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 su
e info, but my question is how many databases, not so much how many rows per table or how
big the database can be... I mean, how many "create database ABC" can I do
before MySQL says "sorry, you can't have more than X databases".
Say I create 1000 empty MySQL databas
Each Schema is a Subfolder under the datadir of the MySQL Instance
However many folders an operating system permits is how many schemas can be
created
- Original Message -
From: Dominik Klein <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, October 18, 2006 10:05:17
John M.Brown schrieb:
Thanks for the info, but my question is how many databases, not so much how many rows per table or how
big the database can be... I mean, how many "create database ABC" can I do
before MySQL says "sorry, you can't have more than X databases".
Thanks for the info, but my question is how many databases, not so much how
many rows per table or how big the database can be... I mean, how many "create
database ABC" can I do before MySQL says "sorry, you can't have
more than X databases".
Say I create 1000 empty
John,
How many databases does a single instance of MySQL Server 5.x support?
I suspect you'll get a bit of a , 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'
I've looked as many places as I can think of and can't find a direct answer to
my question:
How many databases does a single instance of MySQL Server 5.x support?
Is this because there is no logical limit?
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
At 06:32 AM 8/3/2006, Ratheesh K J wrote:
Hello all,
Just wanted to know how many columns are preferable in table. At present
we are having nearly 50 - 60 columns in some of the tables. Is this ok or
should we be splitting the tables for normalization.
If we really need to split then how
Hello all,
Just wanted to know how many columns are preferable in table. At present we are
having nearly 50 - 60 columns in some of the tables. Is this ok or should we be
splitting the tables for normalization.
If we really need to split then how better would it be in terms of performance
Hello
I have sent this e-mail 2 weeks ago and did not get any answers. Please
allow me to give a second try.
I have Mysql 4.1.7 on Solaris / innodb tables
I have 2 innodb_log_files of 100M each. A group of statements (19000
insert) does that both logfiles are stamped with the same time. It might
Hello
I have Mysql 4.1.7 on Solaris / innodb tables
I have 2 innodb_log_files of 100M each. A group of statements (19000
insert) does that both logfiles are stamped with the same time. It might
be because one has just finished filled and the other start or it might
be because they both rotated
Hello.
> Is there any advantages to having one single ibdata file, or is it better to
> have several, and if so, how many?
As said at:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
You may get some performance improving if you put the files on the different
di
, and if so, how many? If you could point me to a url where I can
read about this, I would greatly appreciate it.
Thank you and regards.
--
Alfredo J. Cole
Grupo ACyC
www.acyc.com - www.clshonduras.com - SolCom - www.acycdomains.com
--
MySQL General Mailing List
For list archives: http
from sale where user_id = 1 GROUP BY id;
>
> I need to know how many rows or how many entries this query returns. I
> tried to use "count" and "sum". But the result is wrong.
>
> I want to be able to make select and know how many rows this query
> re
Your sample query doesn't really make sense, but perhaps you are looking for
SQL_CALC_FOUND_ROWS. From the manual, "SQL_CALC_FOUND_ROWS (available in
MySQL 4.0.0 and up) tells MySQL to calculate how many rows there would be in
the result set, disregarding any LIMIT clause. The numb
On Saturday 13 November 2004 06:40 am, Jerry Swanson wrote:
> This is my query
> select id, status from sale where user_id = 1 GROUP BY id;
>
> I need to know how many rows or how many entries this query returns. I
> tried to use "count" and "sum". But the res
This is my query
select id, status from sale where user_id = 1 GROUP BY id;
I need to know how many rows or how many entries this query returns. I
tried to use "count" and "sum". But the result is wrong.
I want to be able to make select and know how many rows this query
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 16, 2004 10:11 AM
Subject: How many UNIQUE Columns per table
Hi all,
I have a query ,
Please can someone just tell me the details of restrictions on how many
maximum no of UNIQUE Columns can be there per table
and how many
Hi all,
I have a query ,
Please can someone just tell me the details of restrictions on how many maximum no of
UNIQUE Columns can be there per table
and how many maximum PRIMARY KEY Columns,HOW many maximumum AUTO_INCREMENT Columns can
be there per table
In the last episode (May 02), Mailing List Receiver said:
> We weekly rotate the mysqld log. I need to find a way to query the
> server to see how many current connections with clients there are,
> so I can wait to restart the server when the number of connections
> is zero. mysqla
We weekly rotate the mysqld log. I need to find a way to query the
server to see how many current connections with clients there are,
so I can wait to restart the server when the number of connections
is zero. mysqladmin doesn't seem to have this capability.
Is there any other way?
Hi Ron,
how many clients can be connected to mysql ?
Is there any setup for client connections ? where can I find it ?
Timotius Alfa
-
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Apart from "my.cnf" MySQL also provide you with
my-huge.cnf, my-large.cnf, my-medium.cnf and my-small.cnf.
Files whih are used for diferrent sizes of datadases. Check them out it can
help. if you find the conf you r looking for in one of the cnf file you just
have to rename it to my.cnf.
Vinay
On Mon, 25 Aug 2003 10:05:32 +0530 (IST)
"Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I have a mysql database running on Mysql version 3.23.53 on a Red Hat
> Linux 7.2. In the database there is a single table with over 150,000
> records. Unfortunately, the performance of that table is
Hi,
I have a mysql database running on Mysql version 3.23.53 on a Red Hat
Linux 7.2. In the database there is a single table with over 150,000
records. Unfortunately, the performance of that table is very poor,
comparing to other tables in the same database.
Can somebody help me out.
Thanks,
R
Hi Jeremy,
Thankx for the solution..but can you please tell
me how to increase the key buffer fo mysql ??
Its urgent...we are facing a lot of problems.
Thankx once again for the solution.
> On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
>> Hi,
>>
>> We are using MySql ve
Thank you for the Email. I will contact you within 24 hours.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Aug 22, 2003 at 10:55:49AM +0530, Rupak Banerjee wrote:
> Hi,
>
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking
"Rupak Banerjee" <[EMAIL PROTECTED]> wrote:
> Hi,
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The
Hi Rupak!
> We are using MySql version 3.27.53 on a Red Hat Linux platform version
> 7.2. For the past couple of months we are noticing that the performance
> of the server has gone down very badly. Every, single insertion is
> taking a hell lot of time.The particular table has only 150,000 reco
Hi,
We are using MySql version 3.27.53 on a Red Hat Linux platform version
7.2. For the past couple of months we are noticing that the performance
of the server has gone down very badly. Every, single insertion is
taking a hell lot of time.The particular table has only 150,000 records.
Is there
a lot Roger!
Babale
-Ursprüngliche Nachricht-
Von: Roger Baklund [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 16. August 2003 14:32
An: [EMAIL PROTECTED]
Cc: B. Fongo
Betreff: Re: How many join do I need for a query on 3 table?
* B. Fongo
> I was able to extra the information from the
* B. Fongo
> I was able to extra the information from the first 2 tables yesterday
> using following query:
>
> SELECT Customers.Name, Customers.City, Orders.Product,
> Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
> customers.cust_id = "2"
>
> -
Hello again!
I was able to extra the information from the first 2 tables yesterday
using following query:
SELECT Customers.Name, Customers.City, Orders.Product,
Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
customers.cust_id = "2"
--
On Mon, Jun 23, 2003 at 03:19:05AM -0400, M Lists wrote:
>
> I'm researching a specific network design and have some questions that may
> involve 2-way replication.
Ok...
> I have one master mysql server doing 1 way replication to a large
> number of remotely located slaves. Each slave serves a
I'm researching a specific network design and have some questions that may
involve 2-way replication.
I have one master mysql server doing 1 way replication to a large number of
remotely located slaves. Each slave
serves a number of proprietary software clients running inside a private
network.
On Wed, 02 Apr 2003 11:10:04 -0600
gerald_clark <[EMAIL PROTECTED]> wrote:
> AChecks for empty
> B Checks for empty
> AUpdates
> AReads ( and owns record )
> BUpdates
> BReads ( and owns record )
>
Reality says to do it more like this
A Write lock on table
B Tries to
<[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:59 AM
Subject: RE: How Many
> Just noticed this thread.
>
> Here is another method, still using the 'userid' method, but slightly
> differently; it claims a job immediately. You then have to run a select
by
>
ike
get_last_update or mysql_affected_rows to gather information on what the
UPDATE affected rather than another select. This was just quick and
generic.
-Mike
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:12 AM
To: gerald_clark
C
<[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record )
BUpdates
BReads ( and owns record )
Now What?
Cal Evans wrote:
No. You check for empty. update, check
last man wins.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
> AChecks for empty
&
lt;[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:22 AM
Subject: Re: How Many
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a
restriction.
2: It doesn't work that way. It's not like V
-
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "Ed Kiefer" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:22 AM
Subject: Re: How Many
>
>
> Cal Evans w
-- Original Message -
From: "Ed Kiefer" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 7:40 AM
Subject: How Many
How many people can be accessing the same mysql database at the same time?
Can several people work on the
nutes, 2 hours, 3 days, etc) old, I invalidate
the lock by going to step 2 anyhow.
Clear as mud?
=C=
- Original Message -
From: "Ed Kiefer" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Tuesday, April 01, 2003 7:40 AM
Subject: How Many
> How
How many people can be accessing the same mysql database at the same time?
Can several people work on the same record at the same time?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>From: "Andrew Kuebler" <[EMAIL PROTECTED]>
>
>2) Is it just as fast with Mysql to access 10 fields in a table with 10
>columns as it would be to access those same 10 fields among let's say 90
>other fields in a 100 column table?
Are you certain that performance should be your primary concern her
I'm not sure what the limit is. MySQL limits tend to be dictated by the
OS that is being used. The more columns you have the larger the database
file will be. You should try to avoid having many empty columns in a
database design, even if you are using varchar instead of char. Try to
think ahe
Two questions:
1) How many columns does MySQL support per table?
2) Is it just as fast with Mysql to access 10 fields in a table with 10
columns as it would be to access those same 10 fields among let's say 90
other fields in a 100 column table? Would speed only be reduced if I
pulled a
At 15:41 -0400 10/1/02, Chuck Payne wrote:
>Hi,
>
>I am having problems get how many days out an invoice is from mysql. I have
>try this.
>
>SELECT NOW()-summitted_date FROM table;
>
>But it not working as usually. So please guys a little help.
What do you mean "not
Hi,
I am having problems get how many days out an invoice is from mysql. I have
try this.
SELECT NOW()-summitted_date FROM table;
But it not working as usually. So please guys a little help.
So If an invoice was summitted on 9-26-02 then I should be able to see that
5 days.
Chuck Payne
Magi
The subject pretty much says it all... is there a limit to the number of
datafiles you can specify with the innodb_data_file_path parameter, and
if so, what is it?
I looked through the docs, didn't find anything, but with my boss
looking over my shoulder I may have missed it. ;)
(filterbait
I can't think of any reason to have that many fields. It really starts
to make the databases structure unmanageable, or at least difficult and
time consuming to manage. It also can make it very difficult to create a
good, flexible search interface.
Filemaker might be an exception because of the
What is the limit on amount of fields in a MYSQL table.
Access / lotus will only do 255, whereas Filemaker will do over
Hopefully someone will tell me it is more than 459 (that is what I need in
mine).
Thanks
Brian Leyland
-
In the last episode (Jun 08), Shoshi & Iphtach Cohen said:
> Hi experts,
>
> I appreciate if you could tell me how many MySQL tables we can open in
> parallel.
>From a client's point of view? Unlimited. Internally, mysql will only
open "table_cache" number of
Message -
From: "Shoshi & Iphtach Cohen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 08, 2002 2:00 PM
Subject: How many MySQL tables can we open paralel
> Hi experts,
>
> I appreciate if you could tell me how many MySQL tables we
Hi experts,
I appreciate if you could tell me how many MySQL tables we can open in
parallel.
In our application (BuildaGate Suite Technology) which is based on PHP &
MySQL, there are strange situations of data loss, and we are looking for
information on what are the limitations of an M
; the directory. When table is created, MySQL creates file(s) on the
> disk. So, the maximum number of tables is defined by OS
> characteristics: how many files (subdirs) OS can handle for the
> directory.
>
> This does not apply to InnoDB tables as they use different
> storage
MySQL creates file(s) on the
disk. So, the maximum number of tables is defined by OS
characteristics: how many files (subdirs) OS can handle for the
directory.
This does not apply to InnoDB tables as they use different storage scheme.
RB> Roger
--
For technical support contracts, goto
At 08:33 PM 2/16/2002 , you wrote:
>Hello
>
>I am new to the subject. I am experimenting in mysql via PHP with a nice
>book (PHP and MySQL
>Web development). My question is how many queries to mysql, made via PHP,
>should considered
>ok for efficiency. I know it has much t
> I am new to the subject. I am experimenting in mysql via PHP with a nice
> book (PHP and MySQL
> Web development). My question is how many queries to mysql, made via
> PHP, should considered
> ok for efficiency. I know it has much to do with the size of databases,
> but I wo
Hello
I am new to the subject. I am experimenting in mysql via PHP with a nice
book (PHP and MySQL
Web development). My question is how many queries to mysql, made via
PHP, should considered
ok for efficiency. I know it has much to do with the size of databases,
but I would like to get an
http://www.mysql.com/doc/n/o/node_365.html
> Can anyone tell me how many characters a MySQL TEXT field can hold? What's
> the limit?
--
Steve Rapaport
World Citizen
-
Before posting, please check:
http://ww
Hello All!
Can anyone tell me how many characters a MySQL TEXT field can hold? What's
the limit?
Thank you,
Carlos Fernando.
Linux User #207984
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
You'd probably want to make sure the tables are at least in 3rd normal form.
1st: each column contains only ONE attribute. The means you can't
have a list of people for "members" or the such. And each row must
have a primary key. No two rows can be identical in a table.
2nd: no column is parti
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 24, 2001 4:40 PM
Subject: How many tables?
> How far should I go with this? Right now when I look at my frequency
table, it'
1 - 100 of 140 matches
Mail list logo
