Re: Big innodb tables, how can I work with them?

2014-05-19 Thread Manuel Arostegui
2014-05-19 11:49 GMT+02:00 Johan De Meersman : > > - Original Message - > > From: "Manuel Arostegui" > > Subject: Re: Big innodb tables, how can I work with them? > > > > noSQL/table sharding/partitioning/archiving. > > I keep wondering how

Re: Big innodb tables, how can I work with them?

2014-05-18 Thread Manuel Arostegui
another hardware upgrade, yo should've thought about a solution that would allow you keep growing without needing to spend all in hardware (unless you have unlimited money). Good luck! Manuel.

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 10:57 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 10:19, schrieb Manuel Arostegui: > > 2014-05-05 10:00 GMT+02:00 Reindl Harald h.rei...@thelounge.net>>: > > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > > "%" do

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix Socket. > > If you don't want to specify

Re: mysql Access denied error

2014-05-04 Thread Manuel Arostegui
r -plocalhost (or 127.0.0.1) "%" doesn't match localhost so if you don't specify it you will be attempting to connect via Unix Socket. If you don't want to specify -hlocalhost all the time, just do the grant with "@localhost" instead of "@%" Hope this helps Manuel.

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

2014-04-17 Thread Manuel Arostegui
level your data has been sync'ed to disk even though this is not totally true. write-back is better for performance, but you have to keep in mind that you can lose data (which is not common, but you're not 100% safe). Hope this helps Manuel.

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Manuel Arostegui
e > binaries only in case of a release upgrade (RHEL 5 to 6, for example), > i.e. when a different binary distribution exsists: > MySQL-5.6.17-1.rhel5.x86_64.rpm to MySQL-5.6.17-1.el6.x86_64.rpm. > > > Hello, Upgrades are always scary. Don't you have another server (staging) with same hardware/packages so you can try there first before doing it in production? Manuel.

Re: Data masking for mysql

2014-04-15 Thread Manuel Arostegui
rement. > > I look forward to hearing from you. I don't think there's a generic tool for it. It depends on your data, format etc. ie: it's not the same a credit card record than an email or a phone number one. It depends on your data, so you might want to do it from an application level. Good luck Manuel.

Re: Locking a Database (not tables) x

2014-03-22 Thread Manuel Arostegui
your stuff and enabled it back to its original port and IP. Obviously I am assuming your developers connect remotely (thru port 3306 or whichever you use). Manuel.

Re: DBA: please review my.cnf [for Java Hibernate application] and give suggestions

2014-02-12 Thread Manuel Arostegui
e you test different disk schedulers (depending if you have RAID and which kind of it) and see how they perform. - You might want to take a look to smp irq affinity and see how it could impact in your system. Manuel.

Re: replication question replacing the master

2014-01-18 Thread Manuel Arostegui
; - Set read_only = OFF in your new master - Start your application so you can start getting writes again. As soon as you get writes if you do a "show master status;" in the new master you should see the position going forward. I see that faster than any other thing. Hope this helps Manuel.

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-08 Thread Manuel Arostegui
2014/1/7 > 2014/01/06 17:07 +0100, Reindl Harald > what about look in the servers logfiles > most likely "max_allowed_packet" laughable low > > Is this then, too, likly when the server and the client are the same > machine? > > I left this out, that it only then happens when th

Re: InnoDB error 5

2013-11-21 Thread Manuel Arostegui
ting system and is *not* mysql specific > which is also in the message statet with "returned OS error 105" > > > http://lxr.free-electrons.com/source/include/uapi/asm-generic/errno-base.h#L8 > > Looks like a broken disk or FS corruption :-( Good luck! Manuel.

Re: Archive Engine Question

2013-09-17 Thread Manuel Arostegui
e-btree In all the tests we did we saw some performance degradation but nothing too serious and nothing we couldn't afford, but if you decide to try this, make sure you do a PoC so you know how it could impact in your scenario. Hope this helps Manuel.

Re: Performance hiccoughs..

2013-08-14 Thread Manuel Arostegui
nodb_log_file_size=100M > innodb_log_buffer_size=8M > innodb_flush_log_at_trx_**commit=1 > This can be a performance killer, try to set it to 0 and make sure you understand what it means ( http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit ) > innodb_lock_wait_timeout=50 > innodb=on > > > Do you have innodb_file_per_table enabled? Cheers, Manuel

Re: hypothetical question about data storage

2013-07-29 Thread Manuel Arostegui
er for you. As Rick said, with BBUs, disk schedulers, write back/write thru configuration etc things can change. The last tests with SSD disks shows no difference, so for the new servers with SSD we're going for RAID5 as you get more disk space :-) Just my 2 cents! Manuel. -- Manuel Aróstegui Systems Team tuenti.com

Re: InnoDB problem.

2013-07-23 Thread Manuel Arostegui
2013/7/23 Rick James > Did you change innodb_log_file_size? > innodb_log_file_size error always appears in the logs...he only posted a few lines of his log...but I guess (or I want to believe) he's gone through the whole log before starting the thread :-) Manuel > >

Re: mysql on zfs

2013-06-28 Thread Manuel Arostegui
Hello, Do you have trim enabled? Maybe those stalls could happen when the disks are getting trimmed. Just a random thought. Manuel 2013/6/28, nixofortune : > Hi guys, > Did you have any experience running MyLSQ or in my case MariaDB 5.5.31 > on FreeBSD on top of zfs? > We are using

Re: help: innodb database cannot recover

2013-06-20 Thread Manuel Arostegui
t; >How did you copy the database? > >Manuel > > I copy the files ib_logfile0 ib_logfile1 ibdata1 into /var/lib/mysql in > linux and the whole database directory my_database_name into > /var/lib/mysql/my_database_name, the same location as previous machine > /var/lib/mysq

Re: help: innodb database cannot recover

2013-06-20 Thread Manuel Arostegui
2013/6/20 Peter > Hello, > > I copied innodb database (ib_logfile0 ib_logfile1 ibdata1 and the whole > database directory) from one crashed machine to another. > I find that I cannot start database to get the database data any more. How did you copy the database? Manuel

Re: open files in mysqld 5.1.53

2013-06-12 Thread Manuel Arostegui
this as a for-good-solution but a temporary one till you decide what to do. We migrated most of the tables to InnoDB (there was no reason to keep them as MyISAM, it was just legacy stuff). And these problems were gone. I don't know if this can be your case, but this is what happened to us. Hope this helps. Manuel.

Re: Stopping mysql does not always stop it?

2013-06-06 Thread Manuel Arostegui
2013/6/6 Reindl Harald > > Am 06.06.2013 15:39, schrieb Manuel Arostegui: > > Once that problem has been found...you can use either /etc/init.d/mysql > > stop or mysqladmin. Both should work in the same way > > > You should never use kill > > and why? what d

Re: Stopping mysql does not always stop it?

2013-06-06 Thread Manuel Arostegui
. In order to check it, you can just try to use pgrep to look for the process and/or also check whether the .pid (and/or .sock) exists. I would always use a combination of two methods to make sure it is stopped. Hope this helps. Manuel. -- Manuel Aróstegui Systems Team tuenti.com

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-23 Thread Manuel Arostegui
2013/5/22 Tim Callaghan > Rafal, > > I don't believe TRIM is supported for XFS. > I tried this two weeks ago and worked pretty well: http://xfs.org/index.php/FITRIM/discard Manuel.

Re: Mysql server - which filesystem to choose? Is it really that important nowadays?

2013-05-22 Thread Manuel Arostegui
uration in around 200 DBs without any stability issue. I still have pending to test ext4/xfs with 3.2.X kernels... Manuel.

Re: Chain Replication QUestion

2013-04-30 Thread Manuel Arostegui
sition and logfile those slaves need to start the replication from. You can also use xtrabackup if you like. Manuel.

Re: Determing number of queries

2013-04-04 Thread Manuel Arostegui
2013/4/4 > >>>> 2013/04/04 22:40 +0200, Manuel Arostegui >>>> > You can start with show innodb status; > <<<<<<<< > It is now > show engine innodb status Yep, sorry, not used to it just yet :-) -- Manuel Aróstegui Systems Team tuenti.com

Re: Determing number of queries

2013-04-04 Thread Manuel Arostegui
there a way that mysql > can tell me info about it's workload? > > Thanks Hello, You can start with show innodb status; For the basics, you might want to start graphing the stats under ROW OPERATIONS (inserts, updates, reads, deletes...) Manuel.

Re: Importing SQL dumps into MySQL through Command line

2013-03-31 Thread Manuel Arostegui
2013/3/31 Norah Jones > Hi, > > To source sqldump i can use the source command, but if I need to do the > same stuff using command line without going to the sqlpromt, can I achieve > that. > > Hello, You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ? Manuel.

Re: Defragmentation of MySQL tables, how many times have I to do it?

2013-03-28 Thread Manuel Arostegui
ay monthly optimize and then decide. I am assuming you are not optimizing because of disk space issues. Manuel 2013/3/28, Antonio Fernández Pérez : > Ok. Thank you very much. > > Best regards, > > Antonio. > -- Manuel Aróstegui Systems Team tuenti.com -- MySQL General Mailing

Re: How to change max simultaneous connection parameter in mysql.

2013-03-24 Thread Manuel Arostegui
2013/3/24 Reindl Harald > > > Am 24.03.2013 05:20, schrieb spameden: > > 2013/3/19 Rick James : > >>> you never have hosted a large site > >> Check my email address before saying that. > > > > :D > > as said, big company does not have only geniusses > > >> 20 may be low, but 100 is rather high. >

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
IP. You'd need to check the binlogs. By having both MySQL replicating from each other, you'd avoid this. Make sure you do "reply all" instead of replying only to me :-) Manuel.

Re: Promoting MySQL 5.5 slave to master

2013-03-21 Thread Manuel Arostegui
set it active (move the VIP, pointing your Apache manually to write to it, however you do it). What you have to make sure though is about the read_only parameter. Make sure the new master comes back to life with read_only = ON just to avoid any problems. The standby master should always have read_only = ON until it becomes active. Manuel.

Re: How to change max simultaneous connection parameter in mysql.

2013-03-16 Thread Manuel Arostegui
server. If you are close to get your server to swap...be careful with this parameter as any swapping will affect your performance. Manuel. -- Manuel Aróstegui Systems Team tuenti.com

Re: Multi-Master Replication Manager - monitor works but mmm_control show executes very long and sometimes returns no output.

2013-03-11 Thread Manuel Arostegui
or but that has not resolved > the problem. When I have rebooted the monitor host first use of > mmm_control show was ok but then the problem was active again. > > Any advice? Have you had any similar problems? Hello, Have you tried to set "debug 1" in your mmm_common.conf and

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

2013-02-16 Thread Manuel Arostegui
once you get rid of them, your database will use much less space. I have seen this scenario many times and I have seen tables using like 30GB disk space and after an "optimize" their reported disk size would be just 5-10GB. Manuel.

Re: slave replication with lots of 'duplicate entry' errors

2013-02-15 Thread Manuel Arostegui
appears in your mysqldump...the only explanation is...they are writing directly into the slave. Manuel.

Re: slave replication with lots of 'duplicate entry' errors

2013-02-14 Thread Manuel Arostegui
int-in-time recovery from -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000974', MASTER_LOG_POS=240814775; And if you're using the right IP, there's no reason to have duplicate entries unless someone is writing directly into the slave. Manuel.

Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6

2013-02-14 Thread Manuel Arostegui
are server running for several days before upgrading the rest of machines to 5.6. If possible, I would do some stress tests or benchmarking to make sure it performs as you expect. Manuel.

Re: log sequence number InnoDB: is in the future!?

2013-02-04 Thread Manuel Arostegui
a matter of setting it up as a master, which generally takes minutes. Hope you guys fixed everything already! Manuel.

Re: log sequence number InnoDB: is in the future!?

2013-01-28 Thread Manuel Arostegui
wouldn't do it if it's not totally necessary (ie: you don't have another machine to copy the data from). If you can get the data copied again from some other server, that is probably the safest solution here to make sure your data isn't corrupted. If not, I would suggest to run pt-table-checksum to make sure the data is okay. Once your DB is recovered from this crash. Cheers Manuel.

Re: Handlersockets - mutex_delay contention

2012-12-12 Thread Manuel Arostegui
gain after disabling the transactions limit. Manuel. 2012/12/7 Manuel Arostegui > Hello all, > > I am testing handlersockets performance in a 5.5.28-29.1-log (Percona) > server. > These are the enabled options: > > loose_handlersocket_port = 9998 > loose_handlersocket_port_wr =

Handlersockets - mutex_delay contention

2012-12-07 Thread Manuel Arostegui
. I have not been able to find what is that related to. Does anyone has a clue about what's it and if there's a way to improve and overcome it? Cheers Manuel.

Re: MySQL Replication Error

2012-12-05 Thread Manuel Arostegui
You might want to try pt-table-checksum ( http://www.percona.com/doc/percona-toolkit/2.1/pt-table-checksum.html) to see what else do you have broken. Manuel. -- Manuel Aróstegui Systems Team tuenti.com

Re: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf cause mysqld to randomly crash on high load?

2012-11-26 Thread Manuel Arostegui
fail when restoring them (or even when backuping them). Good luck! Manuel 2012/11/26, Rick James : > Nothing looks bad. > 96G for the buffer_pool is bigger than I have experienced, but I know of no > reason for it to fail (given that you have 128GB of RAM). > >> -Original Me

Re: Replication between different versions

2012-11-15 Thread Manuel Arostegui
g compatibility. > Otherwise I'll keep on installing the same version... You should have no problem as long as you're not using some feature not supported anymore in 5.5 version. Manuel

Re: Assistance with replication

2012-11-12 Thread Manuel Arostegui
2012/11/12 Machiel Richards - Gmail > Hi Manuel > > Please take careful note of what I have stated in the original > mail. > > 1. the fact that the slaves say "seconds behind master = 0" does > not neccesarily mean that repliication is working

Re: Assistance with replication

2012-11-12 Thread Manuel Arostegui
all the data arriving to the master is: Master: show master status\G Check File and Position field Slave: show slave status\G Check Exec_Master_Log_Pos and Master_Log_File The should be the same in both, master and slaves. Keep in mind these values will change if the master is getting writes. So try to run the commands at the same time in the 3 servers. Good luck! Manuel.

Re: How to verify mysqldump files

2012-11-07 Thread Manuel Arostegui
to make sure the backup'ed data is correct. Manuel.

Re: Mysql backup for large databases

2012-11-02 Thread Manuel Arostegui
daemon in the delayed slave to make sure everything is committed to disk. Otherwise can end up having a corrupted DB which won't boot when you need it. And lastly, but probably most importanttest your backups periodically!! Hope this helps Manuel. 2012/11/1 Karen Abgarian > Hi

Re: Replication Question

2012-10-25 Thread Manuel Arostegui
ation? > > Hello, Make sure you run a "show master status" at C before sending the writes to it so you can get to know at which position/binlog you have to start A replicating from. Also make sure read_only = OFF in C. Manuel.

Re: monitoring tool

2012-10-10 Thread Manuel Arostegui
gged users. Again, you'd need to parse its output. > 5. Other admin tasks > Do you really think we can help you with this description? :-) Manuel.

Re: monitoring tool

2012-10-10 Thread Manuel Arostegui
2012/10/10 Aastha > Hi, > > Are there any open source MYSQL rela time monitoring tools available in the > market. > > Aastha > Hello Aastha, You should try to be more specific when asking for stuff. What do you want to monitor? reads/writes? QPS? threads? etc Thanks Manuel.

Re: InnoDB corrupt after power failure

2012-10-04 Thread Manuel Arostegui
tried playing with innodb_force_recovery option to try to get the server started at least? That way you might be able to identify which table(s) is/are the corrupted one and the one(s) preventing the whole server from booting up. Manuel

Re: InnoDB vs. other storage engines

2012-09-19 Thread Manuel Arostegui
ect etc. The best approach, from my point of view, would be, firstly, tune your MySQL server (if you've not done it yet) before getting into engine/tables optimizations which can be more complicated. Manuel.

Re: Temporary table creation fails

2012-09-10 Thread Manuel Arostegui
2012/9/10 Machiel Richards - Gmail > Hi, > > permissions are confirmed as being correct. Other applications and > users are currently writing files to this directory yes. > Have you tried su - mysql and touch /tmp/test? (if your mysql user has shell...) Good luck! Manuel.

Re: Understanding Slow Query Log

2012-09-04 Thread Manuel Arostegui
2012/9/5 Adarsh Sharma > Actually that query is not my concern : > > i have a query that is taking so much time : > Slow Log Output : > # Overall: 195 total, 16 unique, 0.00 QPS, 0.31x concurrency _ > # Time range: 2012-09-01 14:30:01 to 2012-09-04 14:13:46 > # Attribute tota

Re: How to use an hardcoded list of values

2007-10-03 Thread Manuel Vacelet
pensive at all, I will keep the "simple" solution. Regards, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to use an hardcoded list of values

2007-09-26 Thread Manuel Vacelet
i.item_id IN (20203,20204,20205,20206,20223,20207,20208); Is it possible not to make a look-up in 'item' table ? -- Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql and disk space left

2007-04-23 Thread Manuel Vacelet
On 4/19/07, Manuel Vacelet <[EMAIL PROTECTED]> wrote: Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Hi everybody, Nobody can answer my question

Mysql and disk space left

2007-04-19 Thread Manuel Vacelet
Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Update multiple tables strange behaviour

2007-02-19 Thread Manuel Vacelet
2007/2/15, Manuel Vacelet <[EMAIL PROTECTED]>: Hi all, I'm facing a strange behaviour with an UPDATE statement. I have a table like: +-+--+ | item_id | rank | +-+--+ |2812 |2 | | 13050 |4 | | 13051 |3 | | 13052 |1 | +-+---

Update multiple tables strange behaviour

2007-02-15 Thread Manuel Vacelet
13052 |1 | +-+--+ -> It works. Can someone explain to me what happen ? Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to "cast" a column ?

2007-01-30 Thread Manuel Vacelet
y to write the query to use indexes or do I have to change my schema ? I'm using Mysql 4.1 with MyIsam engine. BTW, how can I get the number of rows examined (like in slow queries log) from mysql command line ? Thanks, Manuel -- MySQL General Mailing List For list archives: http://lists.mys

Re: How do I do this query efficiently?

2006-11-17 Thread Manuel Vacelet
he t1.ids for which there's no greater version. Actually after I sent my email I tried to understand by myself and I'm happy to see you confirm my reasoning. Thank you Peter, Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

source compilatio or install precompiled packages

2006-10-24 Thread Jose Manuel Peso
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi list, Why is recommended the precompiled package install way (as i read in the downloads page)? Thanks, Jose -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFFP

Help on VB and ODBC

2006-05-04 Thread Manuel Betanzos
Hi everybody, Please I need help on this. I am beginning a new application. I am doing it with VB 6.0 - MySQL 5.0 - MyODBC 3.51 on Windows Is there any parameter i need to establish in order to be able to work with RecordSets in the Client side , actually i can't because if i d

Re: Logging (wrong) passwords by mysqld

2006-03-05 Thread Manuel Schmitt (manitu)
> is there a reason that the unknown passwords can't simply be reset? yes, because not all clients are currently known and resetting them would possibly break the application(s) -- ____ Manuel Schmitt - Geschäf

Re: Logging (wrong) passwords by mysqld

2006-03-05 Thread Manuel Schmitt (manitu)
dication, never the password. Yes, I know and you're right. The problem: A customer which has currently no way to find out if he/she still uses some old passwords for one and the same user. So I would like to do that by mysql. -- ____

Logging (wrong) passwords by mysqld

2006-03-05 Thread Manuel Schmitt (manitu)
ereal, but this should not work with encrypted connections. Any help would be appreciated. Thanks Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Importing data from a file

2004-10-25 Thread Manuel J. Contreras Maya
I managed to do it using mysql> load data infile '/home/manuel/databases/import.txt' -> into table countries -> fields terminated by ';'; Query OK, 240 rows affected (0.01 sec) Records: 240 Deleted: 0 Skipped: 0 Warnings: 18 (I will check the warnings...)

Importing data from a file

2004-10-25 Thread Manuel J. Contreras Maya
Hello, I am new in mysql and I woul like to ask what is the best way to import data from a file. Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Commercial Licensing Question

2004-10-20 Thread Sujith Manuel
. Thanks in advance, Sujith Manuel.

HELP mysql.sock is missing in Mac OS X

2004-05-12 Thread Jose Manuel Islas Romero
I start MySQL and it seems to start the server normally >TrentCioran:/usr/local/mysql TrentCioran$ sudo ./bin/mysqld_safe >Starting mysqld daemon with databases from /usr/local/mysql/data >040512 21:27:05 mysqld ended but when i try to open the mysql console it sends me the message: >TrentCior

lost sa password

2004-03-18 Thread jose manuel
Hi all: Long time ago I've installed MySQL on my Debian Machine and I'm pretty sure I did'n left the "sa" pwd blank as recommended. Now, I'm installing other apps that need that "sa" pwd in order to be installed properly butI can't remember the pwd. is possible to recover the sa passwo

basic SQL question

2003-08-06 Thread Gomez Fabre, Pedro Manuel
Dear all, I have the following problem, I am trying to select records from two tables. the tables are constructed like: block block_id sequence_id snp_required first_polymorphism_index last_polymorphism_index first_reference_positio last_reference_position start_pos end_pos tiled_bp polymorphis

Problems compiling mysqlcc

2003-07-04 Thread manuel Silva
When compiling mysqlcc-0.9.2,I get: checking for libmysqlclient... checking for "/usr/lib/mysql//libmysqlclient.a"...yes checking for mysql_real_connect in -lmysqlclient...no configure:error:Could not find libmysqlclient in `/usr/lib/mysql/ /usr/lib/ ...etc. I did: ./configure --with-mysql-lib=

RE: Upgrading to 4.0

2003-06-17 Thread Manuel Diaz-Regañón
Thank you very much. Broad Telecom S.A. (BTESA) - Spain Manuel Díaz-Regañón phone: 913274363 e-mail: [EMAIL PROTECTED] -Mensaje original- De: Anselme [mailto:[EMAIL PROTECTED] Enviado el: martes, 17 de junio de 2003 16:15 Para: [EMAIL PROTECTED]; Mysql_MailingList Asunto: Re: Upgrading t

Upgrading to 4.0

2003-06-17 Thread Manuel Diaz-Regañón
Hi all !! I am trying to upgrade to MySql 4.0 from 3.23 version. I dont know how to proceed. I was looking for some files for upgrading but i found nothing. Any help?? Thanks Broad Telecom S.A. (BTESA) - Spain Manuel Díaz-Regañón phone: 913274363 e-mail: [EMAIL PROTECTED] -- MySQL General

Sensible solution if binary logs get too large?

2003-03-07 Thread Manuel Kiessling
archive the old logs and only leave the current, will that be ok for the slaves? Thanks, -- Manuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: The Security of MySQL

2003-02-26 Thread Manuel Kiessling
Dyego Souza do Carmo wrote: Tanks Tanks very much uh, we have war already?? (sorry couldn't resist) -- Manuel Kiessling sql,query,innodb,mysql - Before posting, please check: http://www.mysql.com/manua

Re: Datentypen

2003-02-14 Thread Manuel Kiessling
Hello Ingo, n etman wrote: als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. this is an english list. dies ist eine englischsprachige Liste. -- Manuel Kiessling - Before posting, please

Re: Enabling Large File System support in MySQL

2003-02-05 Thread Manuel Kiessling
Hello, sorry for this question, after googling for nearly 2 hours, I really thought I found out everything I could on my own. Just found this one: http://www.mysql.com/doc/en/Full_table.html and my questions are answered. Thanks and sorry again. -- Manuel Kiessling

Enabling Large File System support in MySQL

2003-02-04 Thread Manuel Kiessling
Hello, to allow tables bigger than 2GB, I want to compile MySQL in a way that it can utilize the LFS support on my Linux box (SuSE 8.1, ext3 FS, should support files up to 2048GB). Anyone has an advice? -- Manuel Kiessling

Re: Segmentation fault when scanning mysqld port

2003-01-26 Thread Manuel Kiessling
Hello, yep, this one fixed it: ftp://ftp.suse.com/pub/suse/i386/update/8.1/rpm/i586/glibc-2.2.5-161.i586.rpm mysql - gotta love that filter -- Manuel Kiessling - Before posting, please check: http://www.mysql.com

Re: Segmentation fault when scanning mysqld port

2003-01-26 Thread Manuel Kiessling
Hi, found some advise here (in german): http://groups.google.de/groups?q=suse+glibc+mysql&hl=de&lr=&ie=UTF-8&oe=UTF-8&selm=apkaeo%242cspr%242%40ID-121729.news.dfncis.de&rnum=3 -- Manuel Kiessling

Segmentation fault when scanning mysqld port

2003-01-25 Thread Manuel Kiessling
meone can say something to this. -- Manuel Kiessling - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <

Need help installing mysql - Thanks a lot

2003-01-21 Thread Manuel Velasco
I'm getting the following messages after running safe_mysqld (as root): leo:/usr/bin # ./safe_mysqld & [1] 4798 leo:/usr/bin # Starting mysqld daemon with databases from /var/lib/mysql 030121 19:38:15 mysqld ended [1]+ Done./safe_mysqld leo:/usr/bin # cd /var/lib/mysql leo:/v

RE: Recovery with binary logs.

2002-11-29 Thread Manuel Villasante
Hi Martin, Thank you very much. My system is Linux based so your answers are exactly what I need. One more question though: when you use the --record_log_pos option in mysqlhotcopy, where is that position recorded? In the logging output of the program or somewhere else? Thanks again, Manuel

Recovery with binary logs.

2002-11-26 Thread Manuel Villasante
for any help provided, Manuel Villasante - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

RE: MySQL-Front Discontinued

2002-09-11 Thread Manuel Villasante
I second that opinion. -Original Message- From: Gerald Jensen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:02 PM To: [EMAIL PROTECTED] Subject: MySQL-Front Discontinued I went to http://www.anse.de/mysqlfront/ today ... the notice posted on the site says "MySQL-Front

Replication on different SQL servers

2002-07-17 Thread Luis Manuel Cova
Hi.. I'm working on a proyect to implement a SQL server with PHP to allow acces to a MySQL server on the web. The Master server (the server everybody work with) is a Windows 2000 CENTURA SQL server. I want to know how i can manage to export a database from that server to another server (The one

Porting from GUPTA-SQL client to PHP - SQL client.

2002-07-05 Thread Luis Manuel Cova
Hi.. I have a client that's been writen in GUPTA and compiled to be used as a cliento to an SQL database that i access using my local Lan and Netbios.. I want to port that client software (i have the source code for the Gupta Cliente) to be used in a PHP server to allow acces to the database fro

Stumped on this Report - HELP

2002-07-02 Thread Manuel
Dear All, I am stumped on this report. I just need an idea and help to do this in MySQL. To simplify my actual database, I am using an example. Database fields - salesperson,date,visited company industry type salespersons - a,b,c,d,e (can be 10 salesperson or 20 salesperson) visited company in

read only tables

2002-04-23 Thread Manuel
Dear all, When I try to update or create a record to a table, there is an error saying the table is read-only. How can I change it to read-write? I have chmod 777 to all the tables in the mysql data directory. I have also restarted the mysql engine. This happened only after I copy the tables f

problems deleting a user from "user" db

2002-03-25 Thread Manuel Hendel
I got problems deleting a user which I've created before. mysql> delete from user where user=wus; ERROR 1054: Unknown column 'wus' in 'where clause' mysql> Can anyone provide some help? Thanks, Manuel --

Time comparison problem with 3.23.49

2002-02-24 Thread Manuel Mall
or a bug or something related to Linux 6.2 libraries or ...? For the time being I will stick with 3.23.48 to avoid all my applications breaking. Manuel -- Your MySQL connection id is 1 to server version: 3.23.49 mysql

Re: sysctl & process limitations

2002-02-05 Thread Manuel Bouyer
t the values have really been raised ? The 'safe_mysqld' script I use has an option to raise the limit: /usr/pkg/bin/safe_mysqld --open-files-limit=256 Anyway the error code doesn't match a per-process limit but a system limit. This is why I would use ktrace to check what the error r

Re: sysctl & process limitations

2002-02-05 Thread Manuel Bouyer
only has 38 tables, and the datafile I'm trying to load is only > 37 KB. > > Someone suggested a few days ago that perhaps the error reported is not accurate. >How would > I test that? > > My 'gut' says this is probably an easily resolved co

Re: sysctl & process limitations

2002-02-04 Thread Manuel Bouyer
d' process, using the 'mysql' command, rigth ? Maybe it's just the mysql command which runs out of files descriptors ? Did you try to raise the limit of the shell before starting it ? -- Manuel Bouyer <[EMAIL PROTECTED]> --

  1   2   >