Re: maximum number of records in a table

> You should be fine. 100 000 000 is not that much. > Just make sure you set the right keys (and then query by them) on the > table > and even more importantly, set caches and buffers to utilize your RAM > appropriately. thanks. > Olaf > > > On 6/12/07 11:09 A

Re: maximum number of records in a table

acceptable query execution time for > you is. > Also, what else does the machine do, are there other databases or tables > that are queried at the same time, do you have to join other tables in > for > your queries, etc? > > Olaf > > On 6/12/07 3:24 AM, "kalin mintc

Re: maximum number of records in a table

acceptable query execution time for > you is. > Also, what else does the machine do, are there other databases or tables > that are queried at the same time, do you have to join other tables in > for > your queries, etc? > > Olaf > > On 6/12/07 3:24 AM, "kalin mintc

Re: maximum number of records in a table

rds - are 90 mgb. are the .MYI files kept in ram or both .MYD and .MYI? multiplying 90x100 is what the size of the MYI + MYD will be, right? is that all living in ram? thanks > Olaf > > > On 6/12/07 3:24 AM, "kalin mintchev" <[EMAIL PROTECTED]> wrote: > >&g

Re: maximum number of records in a table

means that i have to have about 8 gigs of ram to successfully use a table like that. either that or cluster 2 machines with 4 gigs each and split the table. does this sound reasonable? is my logic flawed somehow? i'll appreciate any comments on this subject thanks... > On 6/1

Re: maximum number of records in a table

mber 5893786 - a unique id... > trying to answer only based upon row count is NONSENSICAL, IMO. > > > On 6/11/07, kalin mintchev <[EMAIL PROTECTED]> wrote: >> >> hi all... >> >> from http://dev.mysql.com/doc/refman/5.0/en/features.html: >> >

maximum number of records in a table

hi all... from http://dev.mysql.com/doc/refman/5.0/en/features.html: "Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows." that's cool but i assume this is distrib

Re: mysql limits

> > Search speeds and CPU with MyISAM is quite good. I tried InnoDb and insert > speeds was far too slow because of its row locking versus MyISAM's table > locking. Some people have been able to fine tune InnoDb but it requires > even more RAM because InnoDb works best when the entire table fits i

Re: mysql limits

> Put as much memory in the machine as possible. Building indexes for a > table > of that size will consume a lot of memory and if you don't have enough > memory, building the index will be done on the hard disk where it is 100x > slower. I've had 100M row tables without too much problem. However

Re: mysql limits

columns. > > Thanks > ViSolve DB Team. > ----- Original Message - > From: "kalin mintchev" <[EMAIL PROTECTED]> > To: > Sent: Monday, February 05, 2007 9:14 AM > Subject: mysql limits > > >> hi all... >> >> i just wanted to ask here if someb

mysql limits

hi all... i just wanted to ask here if somebody has experience in pushing the mysql limits... i might have a job that needs to have a table (or a few tables) holding about a 100 million records. that's a lot of records is there any limitation of some kind that wouldn;t allow mysql to handle t

Re: group by problem

> > but that will get you all records for that category not just the most > recently updated. > that's the main problem, isn't it? what i'm looking for is the last record for EACH of the categories in the table. i'm aware of the aformentioned options. my problem with group by is that ignores th

Re: group by problem

> > Basically you can't do what you want either without temporary tables or > using a subselect. Subselects are only available in mysql 4.1+ (I think > - check the docs) so that may or may not be an option. thanks... pardon my ignorance - how would i do that using subselects? > -- MySQL Gen

group by problem

hi all... i have an issue with group by and ordering. apparently group by ignores 'order by id DESC'?! an example is a table that has an id and a category fields. there are a few categories under which records can be filed. so what i want is the latest record from each category by doing somet

Re: select random ids from list

> > select id,title from content where id IN(10,20,30); cool thanks.. what if i want it to be random ordering like: select id,title from content where id IN(20,10,30); and i would like the order of the ids and the in() to be kept in the result array. what 'order by' would i use?! > > -- My

select random ids from list

hi all... how can i do a query on a list of ids without doing individual queries for each one of them? something like: select id,title from content where id = 100,106,109; of course this doesn't work... is it possible somehow? thanks -- MySQL General Mailing List For list arch

Re: binary select - case sensitive

> > http://dev.mysql.com/doc/refman/5.1/en/charset-binary-op.html > > It has some good examples. got it thanks... > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

binary select - case sensitive

hi all... i found this on the mysql dev manual site: "MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison." so here i tried it but no good. any ideas?! the field is not declared binary but i do

mysql for freebsd 6.0

hi all... i can't see the mysql 5 version for freebsd 6.0 on the mysql developer site? am i blind or it's on purpose?!?! curious... and actually need it... thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql

data backup

hi all... what's the best way to periodically back up mysql data? so that databases and tables can be still usable even after a mysql upgrade? thanks... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

simple load query

hi all... whats the problem with this: load data infile 'stores.txt' into table useyourcash_sports_us (chain, store, address1, address2, city, state, zip,web) FIELDS TERMINATED BY '\t' i get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versi

Re: is this normal?

>> >> > Yes you're right! you can safely delete those - but first make some > changes... as it seems you've set up root password only for : > [EMAIL PROTECTED] - right? that's why you can't login using > localhost (mysql without -h host option assumes -h localhost and if you > only changed passwor

Re: is this normal?

> Sorry I first misread yor question (I hope I cancelled prev. post on time). I thought you have problems connecting to mysql while actual problem is: Why it is so easy for everyone (even from outside) to connect? > Yes this is normal: default user is root *without password* > if you wan't to secur

is this normal?

system freebsd 4.10 mysql is binary: mysql-standard-5.0.15-freebsd4.7-i386 after mysql installation and root password set up i can type: /usr/local/mysql/bin/mysql -u no_matter_what_user_here and i get right in. even if i type -p. i do get the password prompt but doesn't matter what

data export

hi all... is there a simple way to export data from mysql tables? like the opposite of 'load data infile'? i was looking around in the manual but without success... thanks. -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: insert

n one things from 'that': insert into table_name (place, address, number,number_too) select "stuff","stuff2", this, this_too from that where one=two; thanks... > > i may yet have the syntax wrong, but its close. > > > kalin mintchev wrote: >> hi all

insert

hi all... i need some help. can somebody explain why is this insert/select not working? insert into the_db (place,address,number) values("stuff","stuff2",select this from that where one=two); i tried ()s around the 'select' too but it didn't work. thanks. -- -- MySQL General Mailing Li

RE: Deleted: 0 Skipped: 0 Warnings: a lot

e to > run it right after you run > your query (or LOAD DATA). That may be why you can't use it. > > Also, try looking under instead of a log file. That might > help out. > > J.R. > > -Original Message- > From: kalin mintchev [mailto:[EMAIL PROTECTED] >

RE: Deleted: 0 Skipped: 0 Warnings: a lot

stead of a log file. That might > help out. there is no such file on this machine... thanks > > J.R. > > -Original Message- > From: kalin mintchev [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 09, 2004 7:29 PM > To: J.R. Bullington > Subject: RE: Dele

RE: Deleted: 0 Skipped: 0 Warnings: a lot

sql-standard-4.0.13 to old for show warnings!? (J.R., sorry about the double post...) > > J.R. > > -Original Message- > From: kalin mintchev [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 09, 2004 6:53 PM > To: [EMAIL PROTECTED] > Subject: Deleted: 0 Skipped

Deleted: 0 Skipped: 0 Warnings: a lot

hi all... where can i see what these warnings are. i get them when i do load data infile. i was looking for some kind of log under /var/logs/ or mysql/var/log but there isn't a log file for mysql at any of those locations. and the mysql/var/ doesn't exist at all. i created it and redid the load bu

Re: syntax question..

> > - Original Message - > From: "kalin mintchev" <[EMAIL PROTECTED]> > To: "Adam" <[EMAIL PROTECTED]> > Cc: "MySQL General" <[EMAIL PROTECTED]> > Sent: Sunday, November 14, 2004 11:33 PM > Subject: Re: syntax quest

Re: syntax question..

> Kalin, > > Kalin> thanks to all... yes, Rhino - i'm new. my first > Kalin> post. the version is the problem indeed. it's > Kalin> 4.0.13-standard. how would i achieve the same > Kalin> query in this version?... > > You'll need to provide the following: > > (1) What is the result you want to achi

RE: syntax question..

an earlier version. > you may also cause a conflict by using the database alias (t1) as the name > of the result > Peter >> -----Original Message- >> From: kalin mintchev [mailto:[EMAIL PROTECTED] >> Sent: 14 November 2004 23:06 >> To: [EMAIL PROTECTED] &g

syntax question..

hi everybody.. can somebody please explain what is wrong with this command: select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2 where t2.chain like "%carmike%"); thank you... -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

terminated by '\r'....

hi all, load data infile doesn't work with escaped by '\\' line terminated by '\r' the problem is the '\r' . doesn't work with '\r\n' either. if i replace the \r with \n in the the text file itself then it works fine the files i'm trying to load are tab delimited txt files generated by xc

Re: cant grant privileges?!

ven need "-h localhost" in this case. > > Best regards > > Nils Valentin > Tokyo/Japan > > > > 2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました: > > hi everybody... > > > > i just installed mysql 4.0.13 on a redhat linux 8.0 > > when i creat

cant grant privileges?!

hi everybody... i just installed mysql 4.0.13 on a redhat linux 8.0 when i create a database as root and then grant privileges to another user like this: GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd"; everything seems to be fine but then if i log in as "user" and try to get t