Hi all
I am working with startup company.
Have some quries about Mysql
1. What is the maximum database storage capacity of mysql
2. What is the maximum row capacity?
3. How much time it will take to search the record if there are consider more
than 1 billion rows in a table
4. How many records
Hi Vishwas
These and many other answers can be found here :
http://dev.mysql.com/doc/refman/5.0/en/what-is.html
There is no practical limitation on the row size apart from the number
of fields x the size of these fields. eg. 1000 fields of varchar(255) or
larger will take up that space. I don't
Hello:
I found that MyODBC use mysql_ping to check connection and reconnect.
After reconnect by using mysql_ping character_set_client,
character_set_connection and character_set_results go back to latin1.
But I need them to be utf8.
What can I do with MyODBC?
Regards,
gu lei
祝
I am giving the system configuration which we are using to run MySQL.
2-CPU 4G RAM, SAN filesystem.
MySQL version : 4.14 (INNODB)
OS : RHEL - 3
Amount of Data : 200G
No of Rows : 278 million approximately (Every day 2.5-3 million rows gets
added)
Transaction rate : 300-400 reads/sec, 110-120
Hi Sujay,
Can you please post details like the my.cnf configs, how is the
load on system like cpu, memory, disk usage etc.
Thanx in advance
--Alex
On Mon, 09 Jan 2006 15:16:39 +0530, Sujay Koduri [EMAIL PROTECTED] wrote:
I am giving the system configuration which we are using to
Hi,
I'm porting a D-ISAM application to Mysql. My idea is to emulate ISAM
calls with the HANDLER syntax. But I wish to make sure that performance
will be at least as good as direct ISAM calls. Then I did some tests,
scanning a simple table containing 6000 records with a small C program.
George,
- Original Message -
From: George Law [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Sunday, January 08, 2006 10:10 PM
Subject: allocate space for innodb innodb_file_per_table
Hi All,
I am running mysql 5.0.18 with a innodb table of 9 GB (plus several
others)
Sujay ,
Tables : 1 (only 1) ::: Innodb or Myisam ?
I see lots of updates happening on that table so , how frequent do you
defragment the table .
--
Thanks
Praj
On Mon, 9 Jan 2006 01:46:39 -0800
Sujay Koduri [EMAIL PROTECTED] wrote:
I am giving the system configuration which we are using
I need to do a search query on the columns called
Name of business the name of the business
Town Local town or city name
Postcode this is the same as your zip code
Categorythis is type of business ie dress shop bakers
XY this is the table of geo
Yes, after some further research, I found a Perl Modules that handles this queit
nicely.
thx's
[EMAIL PROTECTED] wrote:
I need to do a search query on the columns called
Name of business the name of the business
Town Local town or city name
Postcode this is the same as
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.
Hi,
There is a database available which maps post codes to grid references.
This is controlled by the Royal Mail.
See http://www.royalmail.com/portal/rm/jump2?mediaId=400088catId=400084
This may also be interesting: http://www.jibble.org/ukpostcodes/
In case you don't know, UK post codes
Andy,
thank you, this is very helpful understanding the UK postcode scheme, appreciate
your input.
Andy Eastham wrote:
Hi,
There is a database available which maps post codes to grid references.
This is controlled by the Royal Mail.
See
Hi Anthony,
I am not sure if you have an installation of MySQL on your local server.
If you do then you can try to use something like below to execute your
SHOW DATABASES
Local_server[path to your mysql/bin directory]/mysql
--host=your_remote_host --user=your_user --password=your_password -e
Try this
UPDATE people
SETphone = CASE
WHEN LEFT(phone,4) = '405_' THEN MID(phone,5,20)
WHEN LEFT(phone,3) = '405' THEN MID(phone,4,20)
ELSE phone
END
FROM people
WHERE LEFT(phone,3) = '405'
AND LENGTH(phone)
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/connection-pool.html
wangxu wrote:
Are Mysql ODBC supporting connection pool?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___
Hello.
This should be interesting for you:
http://bugs.mysql.com/bug.php?id=16266
Ian Sales (DBA) wrote:
- unfortunately, the set up demands that the master stays at 4.0. I
can't change that. The triggers were working in 5.0.16. It's the new
DEFINER that was added with 5.0.17
Hello.
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.
Perhaps, you should add UNIQUE key to you table structure. See:
Hello.
See:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Tripp Bishop wrote:
Howdy all,
First off, We're running 5.0.15.
Theres a particular update statement that we run that
updates data in several tables. On our mac OSX test
server (also running 5.0.15) the
Hello.
Is there a specific innodb list?
There is an InnoDB forum:
http://forums.mysql.com/list.php?22
disablign the keys. I think I tried that, but with a table with 7 mil
rows, that takes longer than the load data :-\
Have you increased the myisam_sort_buffer_size variable to
Hello.
You should install MySQL support in PHP. See:
http://dev.mysql.com/doc/refman/5.0/en/php-problems.html
Jon Miller wrote:
I'm a newbie to MySQL so please bear with me. I'm creating a program from =
a script I found and I'm wondering why I keep getting the same error =
Hello.
Searching in the manual didn't return me any pages which have
five-tiered inside. If you're interested in MySQL security read
this:
http://dev.mysql.com/doc/refman/5.0/en/security.html
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
I get a concept about mysql
Gleb Paharenko wrote:
Hello.
This should be interesting for you:
http://bugs.mysql.com/bug.php?id=16266
Hi,
The bug report implies that if you recreate the triggers on the slave
(deleting them manually from the database directory), then it resolves
the issue. Unfortunately, the
Pete Harlan wrote:
FYI,
4.1.16 appears not to be using prefixes of compound indexes when doing
updates. Reverting to 4.1.15, or adding an index consisting of only
the desired field, restores reasonable behavior.
I have added feedback to a possibly-related bug,
We're running MySQL version 4.1.12 on Fedora Core 3 64-bit. we've
been crashing; here is a mysqld.err file from one crash:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
I would totally agree with this. I moved from using Fedora Core 3 to SuSE 9.3
and haven't looked back. YaST is one of the best tools out there. With the
stuff you have installed it would be best just to start over with a new
install. :)
jay
-Original Message-
From: George Law
(reading some old mail)
Hi Jose, don't know if folks have answered your question. If you're
using Mysql 5.0 or higher, you want to check out the NO_ZERO_IN_DATE
and NO_ZERO_DATE SQL modes --
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html. Previous
versions do not allow that.
For
I have a table that contains a foreign key that can be null. When I
do a search I want to have the matches that are null appear first,
and then all other values sorted by another column. My data looks
like this:
id name
nullabc
1 def
2 xyz
nullzzz
7 aaa
I
Marcus Bointon wrote:
I have a table that contains a foreign key that can be null. When I do
a search I want to have the matches that are null appear first, and
then all other values sorted by another column. My data looks like this:
idname
nullabc
1def
2xyz
nullzzz
7
OK, turns out this was a two fold issue.
The server I was on had 4.0 mySQL, which was severely limited in it's
abilities to use subqueries. The server has since been update to the 4.1
series, and now the following 2-subquery query work just fine.
SELECT firstname, lastname, B.playerid,
(still catching up, sorry about the old issues)
Don't know what version is being used here, but one thing you might
want to use, if you're just going to skip the errors anyway (hopefully
you understand WHY you're getting them), is to start replication with
the
--slave-skip-errors
option -- you
Thanks a lot Shawn.
I didn't realize that views don't take advantage of indexing. This is the
cause of my major performance hits. I'm basically using views as a form of
DB abstraction over the tables. So, many of my views pull all records from
all tables they join, and it is up to the user to
To add a few short notes:
1) What happens when you modify data on the slave directly depends on how
you configure your setup. It is possible to have slave updates appear on
the master, that is usually referred to as circular replication. Since you
have 2 replication slaves I would advise against
To be clear:
Replication in MySQL replicates the DML (data manipulation language)
and DDL (data definition language) commands -- that is, any command
that's an alter, update, insert, replace, create, drop, etc statement
to the slave.
If you write to the slave, it does not write back to the
Hi Jason,
Most other peoples responses are excellent as usual, however might I suggest
getting a copy of High Performance MySQL by Jeremy Zawodny (O'Reilly
publishers). This covers the exact scenario you are talking about.
Regards
Mike Blezien wrote:
Yes, after some further research, I found a Perl Modules that handles
this queit nicely.
thx's
Please tell me where this module is, if you would.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
'SHOW DATABASES;' | mysql -u foo -h bar.com
this works, I haven't tested it with other databases though.
On 1/9/06, Mikhail Berman [EMAIL PROTECTED] wrote:
Hi Anthony,
I am not sure if you have an installation of MySQL on your local server.
If you do then you can try to use something like
Hi Anthony,
If you are accessing the db from perl, just execute a show databases
from there using the DBI interface. There is quite an amount of doco
about this and other features at cpan.org. You could also look at the
source for phpMyadmin as this has to get the database names to display
them.
If anyone worked with FAS3050 / FAS3020
(http://www.netapp.com/products/filer/fas3000_ds.html) and mysql?
We have very large DB (InnoDB mainly with some MyISAM tables) and want
to use FAS3050
Any information about any problems or other issues will be very
appreciated.
Best regards,
Alexander
I'll 2nd that High Performance MySQL.
it is by far the best MySQL book I've come across (though I didn't need the
101 stuff, I specifically needed tuning/architecting for HA, etc.)
the only knock I could make (which isn't their fault) is that it needs to be
updated for 5.x (can you say 2nd
im quite new to mysql and here is the problem. I simply cannot connect to
mysql through phpmyadmin or anything else. Lets say i enter the url to
connect (localhost/phpmyadmin/index.html) i end up in the welcome page but
it says access denied for user [EMAIL PROTECTED] (using password: NO)
Hello.
MySQL 5.0.18
Not assigned 0x80 - 0xFF for
CHAR().
When use:
mysql_stmt_prepare(), mysql_stmt_bind_param(), mysql_stmt_execute().
For NCHAR()successfully assigned0x00 -
0xFF.
Successfully executed:
INSERT INTO test (h) VALUES(CHAR(128))
Vladimir Khodakov.
--
MySQL General Mailing
On 1/9/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Anthony,
If you are accessing the db from perl, just execute a show databases
from there using the DBI interface. There is quite an amount of doco
about this and other features at cpan.org. You could also look at the
True, however you could run the perl script locally via another
mechanism and allow it to return the database info in the format that
you desire, or run it using the mysql -e 'show databases' -u
local_user_that_doesn't_need_a_password
The other option is to use an ssh tunnel to the server in
On 1/9/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
True, however you could run the perl script locally via another
mechanism and allow it to return the database info in the format that
you desire, or run it using the mysql -e 'show databases' -u
HI,
The below equation as been obtained from the docs in mysql.com. As per
this equation and looking @ your configs, if definitely looks like a
memory problem.
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+
Hi!
Nowadays we've conducted something what I can call extended testing of
MySQL on Solaris10/x86.
The most annoying issue is a problem with locking queries to MyISAM-type
tables.
Mechanism seems to be simple to explain - long running query locks table
for READ, next there is some DML query
47 matches
Mail list logo