Re: mysql guru??
Relational databases are not very suitable for representing graph-style data. You might want to look into graph databases, or the OQGraph engine for MySQL: http://openquery.com/products/graph-engine good luck! Walter On Fri, Jan 20, 2012 at 13:54, bruce badoug...@gmail.com wrote: Hi. Got a major pain that I'm trying to solve using mysql. Trying to handle a hierarchical tree structure, where I have a parent/child structure that grows as data is added to the system. The process needs to continuously determine if the overall tree, and all the associated nodes/leafs have completed so not only is the tree growing, but data for the given node/leaf is also changing, The system is comprised of a parent app which spawns descendant apps that in turn can spawn descendant apps, and so on.. The system is represented in mysql as a parent/child tree, where each spawned app has an ID, as well as a status for the completion status of the app. I'm trying to find someone I can talk to regarding this, so I can get clarity on how this can be implemented. The process needs to be able to: -update the tree tbl with updated data from the running apps -update the tbl with new nodes/leafs as the spawned apps are created -quickly return 0/1 if the descendants of a node have been complete I've created a few different tbl defs, and played with a few different approaches, but haven't got this right yet. I've looked at a number of different articles covering hierarchical, adjacency models, closures, etc... **The nested soln isn't applicable to the project, as the data/tree tbl is continually growing, which would require a complete rebuilding of the nested tbls, which would impose a computational/time hit on the process. I can provide the sample tbl defs/data that I'm using, as well as more data on what I'm trying to accomplish. So, if you're skilled in this area, let's talk. Thanks -bruce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Free Navicat
Try using yum to install your rpm, it should search for the dependencies and install them if I'm not mistaken (or just don't use centos for desktop OS and save yourself all kinds of misery altogether :P). cheers, On Tue, Jul 26, 2011 at 14:35, Adarsh Sharma adarsh.sha...@orkash.comwrote: ** Ya , I know that but I fail to install Mysql-workbench in Linux Systems ( CentOS , Ubuntu ) Error shows like below : [root@ws-test Desktop]# rpm -ivh mysql-workbench-gpl-5.2.34-1el6.x86_64.rpm error: Failed dependencies: libatkmm-1.6.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcairomm-1.0.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libcrypto.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgdkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgio-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgiomm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libglibmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libgtkmm-2.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 liblua-5.1.so()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpangomm-1.4.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libpython2.6.so.1.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libsigc-2.0.so.0()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libssl.so.10()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.10)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.11)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libstdc++.so.6(GLIBCXX_3.4.9)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libuuid.so.1(UUID_1.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.4.30)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libxml2.so.2(LIBXML2_2.6.0)(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 libzip.so.1()(64bit) is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 pexpect is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python(abi) = 2.6 is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64 [root@ws-test Desktop]# Is there is a any detailed link to install it with dependencies. Thanks Walter Heck - OlinData.com wrote: You can try MySQL Workbench instead. It's FOSS too: http://wb.mysql.com/ have fun! On Tue, Jul 26, 2011 at 14:31, Adarsh Sharma adarsh.sha...@orkash.comwrote: Dear all, Is there is any free version of Navicat to access data from Mysql. I am using 30-day trial version. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily -- Walter Heck -- Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- Follow @tribily on Twitter and/or 'Like' our Facebook page at http://www.facebook.com/tribily
Re: Master Master Replication ... do a fail over and a week agos data is revealed.
To Clarify this a bit: You can only reliably do writes to one server. Your reads can go to both servers with no problems. For reads that need to read data that was just written though, you need to read from the 'active' master, as you can not rely on replication to be instantaneous. On Tue, Oct 19, 2010 at 20:07, Johan De Meersman vegiv...@tuxera.be wrote: On Tue, Oct 19, 2010 at 1:03 PM, Carl c...@etrak-plus.com wrote: Johan, You state that master - master is not reliable in dual active environments. I am in the process of setting up just such an environment (moderate active on the primary server, lighter activity on the other server.) Do you know where I can get some information on the risks? On the MySQL site, I guess :-) Your major issue is likely to be the lack of two-phase commits (which has been added in the most recent release, iirc): even if you properly interleave your autoincrements, the lack of a true global lock means you still risk conflicting updates. I can't really tell you a single spot where I got my knowledge on the subject - I'm a long-time and multi-platform DBA, so it's a combination of stuff I read and an understanding of how things work - or don't. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- Walter Heck Founder @ OlinData (http://olindata.com) Co-founder @ Tribily (http://tribily.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql cluster with 3 db/data and 2 mgm nodes
Unless you have a very good reason, you probably shouldn't go with cluster in the first place. If it is HA you want to have, check out other options like MMM for MySQL (http://mysql-mmm.org), DRBD +Heartbeat and others. Can you tell us a bit more about your goals/desires? Walter Heck Engineer @ Open Query (http://openquery.com) On Mon, Aug 9, 2010 at 14:46, Ghulam Mustafa mustafa...@gmail.com wrote: Hi, i am about to configure mysql-cluster setup with 3 data+sql nodes and 2 mgm nodes, i would like to know if it's ok to go ahead with this setup, because somewhere i read it's preferred to setup _even_ number of data nodes instead e.g. 2, 4, or 6. please advice me. thanks and best regards, -m -- Ghulam Mustafa cell: +92 333.611.7681 sip: cyren...@ekiga.net mail: mustafa...@gmail.com web: cyrenity.wordpress.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql and oom-killer
It would be a lot better to make sure your server doesn't turn OOM-psycho on you. The most common case of this happening is that you have set the memory-settings in your my.cnf in such a way that it allows MySQL to use more memory then you have available. Could you post your my.cnf here by chance? Walter Heck Engineer @ Open Query (http://openquery.com) On Fri, Aug 6, 2010 at 02:43, Евгений Килимчук ekilimc...@gmail.com wrote: Hello! I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use 75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory and all SWAP file (8GB), kernel run OOM-Kiler wich kill mysqld procces. I use: echo 0 /proc/sys/vm/swappiness - This allows to reduce using of SWAP. I want to use: echo -17 /proc/`pidof mysqld`/oom_adj - This allows save mysqld when run oom-killer. Someone used this option? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MMM Mysql
It kind of depends on your application. If you have an application like most web applications, it is okay to skip a beat and a half when a failover occurs. Usually you can lose a very small number of transactions (the ones that are ongoing when the failure occurs), but your failover happens sub-second or very close to that. For most web applications it is more important that service continues, and it is acceptable to lose a few transactions (these will just have to be tried again). Other then that 1. make sure to use a separate machine for the monitor 2. make sure that if you use VM's, you put your masters on different physical machines 3. make sure that ARP traffic can flow freely between your machines. EC2 doesn't support thatfor instance, so you'll either have to stick with MMM 1 or patch MMM 2. That's the most important part I think :) Walter Heck Engineer @ OpenQuery (http://openquery.com) On Sat, Jul 24, 2010 at 07:59, Kyong Kim kykim...@gmail.com wrote: Are there any known issues or challenges implementing MMM? We're currently focused on MMM but just kinda wanted to keep our eyes open. Kyong On Thu, Jul 22, 2010 at 11:19 PM, Rob Wultsch wult...@gmail.com wrote: On Thu, Jul 22, 2010 at 8:42 PM, Kyong Kim kykim...@gmail.com wrote: Has anyone used this in production? We're looking at this as part of our sharding/scale strategy and wanted some insight into real world experience. Are there alternatives out there? Kyong Lots of people are using MMM. Alternatives include Linux-HA (aka heartbeat) often combined with DRBD and MySQL cluster. For the general case MMM is probably the best option. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 2 servers 1 common data base
On Thu, Jun 10, 2010 at 07:09, camelia botez camelia.bo...@weizmann.ac.il wrote: What can be done to run on both servers mysqld simultaneously and use the same data base? You are probably asking the wrong question here. Let's take a step back and ask you another question: What is it you want to achieve on a non-technical level? My gutfeeling tells me you want to have a HA-setup, so that when your database server dies, another one will take over. If that is the case, there's a bunch of tools that can help you do that. You could use classic replication up to a certain point, but active-passive master-master is probably more like what you want to achieve. For that, you can use a tool like MMM (http://mysql-mmm.org) for instance, which will make your life much easier. hope this helps! === Walter Heck Engineer @ Open Query (http://openquery.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it
This kind of error usually means you ran out of disk space on your tmp_dir drive. Walter On Mon, May 31, 2010 at 13:30, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I am getting following error when I am trying to run one stored procedure on table which has 30 rows in it. Table Type id MyIsAM. ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it How to debug this error? I mean I tried to increase tmp_table_Size parameter but, it does not affect. Proc is as follows :- CREATE definer=`myus...@`localhost` PROCEDURE `SP_GetLogs`(InputToDate Date, InputFromDate Date, InputFrom int, InputTo int) DETERMINISTIC BEGIN Declare Count int; Declare AvgVal float(10,2); Drop Temporary Table If Exists norep_Temp; Create Temporary Table norep_Temp ( -- CountOfXML int, TaskName Varchar(100), MinFinalXML Varchar(1), MaxFinalXML Varchar(1) -- , -- AvgOfXML float(10,2) ); If (InputToDate IS NULL and InputFromDate IS NULL) Then SET @stmt = Concat('Insert into norep_Temp(MinFinalXML) Select distinct FinalXML From ClientLog Where TaskName = ','','Time required to complete task','',' and FinalXML Between 1 and 10 Order By FinalXML ASC LIMIT ',InputFrom,',',InputTo,';'); Select @stmt; Prepare stmt1 From @stmt; Execute stmt1; Deallocate Prepare stmt1; SET @stmt = Concat('Insert into norep_Temp(MaxFinalXML) Select Distinct FinalXML From ClientLog Where TaskName = ','','Time required to complete task','',' Order By FinalXML DESC LIMIT ',InputFrom,',',InputTo,';'); Prepare stmt1 From @stmt; Execute stmt1; Deallocate prepare stmt1; Select AVG(FinalXML) into AvgOfXML From ClientLog Where TaskName = 'Time required to complete task'; Select Count(*) into CountOfXML From ClientLog Where TaskName = 'Time required to complete task'; -- Select Count(*) as CountOfXML, MIN(MinFinalXML), MAX(MaxFinalXML), AvgOfXML From norep_Temp Order By MinFinalXML, MaxFinalXML Limit 0,10; Select CountOfXML, MinFinalXML, MaxFinalXML, AvgOfXML From norep_Temp; Drop Temporary Table If Exists Temp; Create Temporary Table Temp ( TaskName Varchar(100), MinVal Varchar(100), MaxVal Varchar(100) -- , ); If (InputToDate IS NULL and InputFromDate IS NULL) Then SET @stmt = Concat('Insert into Temp(MinVal) Select distinct Val From MyLogs Where TaskName = ','','Time required to complete task','',' and Val Between 1 and 10 Order By Val ASC LIMIT ',InputFrom,',',InputTo,';'); Prepare stmt1 From @stmt; Execute stmt1; Deallocate Prepare stmt1; SET @stmt = Concat('Insert into Temp(MaxVal) Select Distinct Val From MyLogs Where TaskName = ','','Time required to complete task','',' Order By Val DESC LIMIT ',InputFrom,',',InputTo,';'); Prepare stmt1 From @stmt; Execute stmt1; Deallocate prepare stmt1; Select AVG(Val) into AvgVal From MyLogs Where TaskName = 'Time required to complete task'; Select Count(*) into Count From MyLogs Where TaskName = 'Time required to complete task'; Select Count, MinVal, MaxVal, AvgVal From Temp; END; -- Regards, Manasi Save -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: upgrade from version 5.0.45
Depending on the seriousness of your environment you can read the changelogs and upgrade if you don't see any showstoppers. I have hardly ever seen any problems with minor version upgrades of mysql. Of course what Rob says is true, and it is a good idea to test things out in a test environment first. But I know many environment where it is okay to just run the upgrade, as long as it is a minor version upgrade. I guess it depends on the type of production environment you are running in. be careful though! Walter On Mon, Apr 5, 2010 at 11:17, Rob Wultsch wult...@gmail.com wrote: On Tue, Mar 30, 2010 at 6:36 AM, Marco Baiguera marco.baigu...@gmail.com wrote: Hello everyone, i am quite new to mysql and i recently begin to work with a company who is using mysql 5.0.45 in production. i think this version is too old and would like to upgrade to the most recent 5.0.xx my os is CentOS release 5.3. is it safe to simply use yum upgrade mysql ? are there any important differences i should be aware of between 5.0.45 and 5.0.77 ? any diffferences in password encoding etc. ? the db is properly backed up and replicated on two 5.0.77 slaves. thank you Marco I would not simply upgrade. I would upgrade the test environment first and have the development team sign off that there were no bad effects caused by the upgrade. The first version of 5.0 that I think is particularly useable and not buggy is 5.0.67. I suggest that this is worth the upgrade. In theory there are not significant differences between 5.0 versions after GA other that bug fixes. I *do not* trust this. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MyISAM better than innodb for large files?
Ah, if you are single-user and updating really is a special occasion that is completely in your control, you could even use compressed MyISAM. That makes the table read-only though, but it does give performance benefits: http://dev.mysql.com/doc/refman/4.1/en/myisampack.html good luck! Walter Heck Engineer @ Open Query (http://openquery.com) On Sat, Apr 3, 2010 at 08:50, Mitchell Maltenfort mmal...@gmail.com wrote: You want the crash safety and data integrity that comes with InnoDB. Even more so as your dataset grows. It's performance is far better than myisam tables for most OLTP users, and as your number of concurrent readers and writers grows, the improvement in performance from using innodb over myisam becomes more pronounced. His scenario is perhaps updated once a year, though, so crash recovery and multiple writer performance is not important. And the concurrent reader and writer number is set at one, unless I undergo mitosis or something. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysql proxy in production?
Take a look at haProxy. It can be combined with some scripts to loadbalance mysql. http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/ We use it at Open Query for a similar case. Cheers, Walter Heck Engineer @ Open Query http://openquery.com | http://openquery.com/blog | On Fri, Mar 12, 2010 at 02:09, John Daisley daisleyj...@googlemail.com wrote: Has MySQL Proxy been improved since that article was released? I ask because although I have no personal experience with it I do know of a big UK based online payment processing company who use MySQL Proxy with MySQL 5.1 in production very successfully. On Thu, Mar 11, 2010 at 3:34 PM, Johan De Meersman vegiv...@tuxera.bewrote: Bah, just spilled coffee on my keyboard. I never was a big fan of mysqlproxy, but this is almost inconceivable. The next genius to suggest it for our environment had better have asbestos underwear. Thanks for the link, Krishna. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Aborted_connects is incresing repidly
Random shot in the dark: I've seen this happen with some monitoring tools that just check to see if the database is up. Walter On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan jeetendra.ran...@sampatti.com wrote: Hi, My MySQL server Aborted_connects status is showing 8692 and is rapidly increasing. What are reasons and how do i decrease the same? We are using connect() method in PHP code and have tried below command mysqladmin flush-hosts but still the value is same. Thanks Jeetendra Ranjan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Specific benchmarking tool
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html Walter On Fri, Nov 13, 2009 at 22:33, Johan De Meersman vegiv...@tuxera.be wrote: Hey all, I'm looking for a Mysql benchmarking/stresstesting tool that can generate a workload based on standard Mysql full query log files. The idea is to verify performance of real production loads on various database setups. Does anyone know of such a tool, free or paying ? Thx, Johan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fw: 50M records each year, help me choosing the stretegy
Sudhir: do yourself a favr and split the blobs (=body) off to a different table. Most fo the time bodies are not used, only when the actual email needs to be shown. That means that you can keep the frequently used fields together in a table for much quicker access. cheers, Walter On Mon, Nov 2, 2009 at 17:49, || Sudhir Nimavat || sudhir_nima...@yahoo.com wrote: Its a very simple table that will store messages. Each message would have subject, body,to_user_id, from_user_id,is_deleted,date_sent and may be one or two more column There would be frequent read operation and slow write operation. Thanks SN Personally I'm always ready to learn, although I do not always like being taught - Forwarded Message From: sudhir543-nima...@yahoo.com sudhir543-nima...@yahoo.com To: Jay Ess li...@netrogenic.com Sent: Mon, 2 November, 2009 3:34:52 PM Subject: Re: 50M records each year, help me choosing the stretegy Its a very simple table that will store messages. Each message would have subject, body,to_user_id, from_user_id,is_deleted,date_sent and may be one or two more column There would be frequent read operation and slow write operation. Thanks SN Personally I'm always ready to learn, although I do not always like being taught From: Jay Ess li...@netrogenic.com Cc: Mysql mysql@lists.mysql.com Sent: Mon, 2 November, 2009 3:04:36 PM Subject: Re: 50M records each year, help me choosing the stretegy sudhir543-nima...@yahoo.com wrote: I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. 50M records is not that bad if you only store a couple of bytes in every row. So please describe your tables in more detail. And also describe the expected access on the data. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sudhir543-nima...@yahoo.com Yahoo! India has a new look. Take a sneak peek. Keep up with people you care about with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/connectmore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [OT] Suggestion of query manager
The GUI tools are horrible, and I probably wouldn't recommend them to my worst enemy :) Take a look at workbench. It is getting better with every release, especially now that they added SSH tunneling into it. It is still beta-status though, but it might work for you: http://dev.mysql.com/downloads/workbench/5.1.html Walter On Tue, Oct 13, 2009 at 12:59, Michael Dykman mdyk...@gmail.com wrote: http://dev.mysql.com/downloads/gui-tools/5.0.html On Mon, Oct 12, 2009 at 7:23 PM, Marcelo de Assis saloma...@gmail.com wrote: Hi people! Can anyone suggest a query manager on linux environment - like Heidisql? I using MySQL Navigator: http://www.bookofjesus.org/images/fl8ze90wpgyt87bkp5.png Thanks! -- Marcelo de Assis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Questions on un-index searches and slow-query-log
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html On Tue, Oct 6, 2009 at 02:59, Brown, Charles cbr...@bmi.com wrote: Questions Folks: (1) What do you about un-index searches. How can one report and monitor them? (2) What do you do with the slow-query log. Are there any utilities or scripts out there to filter and manage this log? Thanks This message is intended only for the use of the Addressee and may contain information that is PRIVILEGED and CONFIDENTIAL. If you are not the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please erase all copies of the message and its attachments and notify us immediately. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: recovery help needed
Hey Joe, stop the server, start it with --skip-grant-tables, change the root entry in mysql.user to your liking, and then restart the server without --skip-grant-tables. viola! Walter On Wed, Aug 26, 2009 at 02:12, Joemysql@bluepolka.net wrote: We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we really need some help regaining access to. While attempting to adjust/add remote user access, we accidentally did the following: use mysql; update user set host = 'SomeBogusIP' where user = 'root'; Now, we can't get into the DB to fix it: # mysql test ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'test' # mysql mysql ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql' We are not MySQL experts by any stretch, so any help is appreciated. Here are the files we evidently touched: # ls -ltr /var/lib/mysql/mysql/ -rw-r- 1 mysql mysql 5256 Aug 25 17:33 db.MYD -rw-r- 1 mysql mysql 844 Aug 25 17:35 user.MYD -rw-r- 1 mysql mysql 2048 Aug 25 17:50 user.MYI -rw-r- 1 mysql mysql 4096 Aug 25 17:50 db.MYI We do have a months-old copy of the 'mysql' db directory. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: reverting to passwd-less root w/out --skip-grant-tables
Is there a specific reason you cannot do it with --skip-grant-table? You should theoretically also be able to overwrite the files user.* (there should be 3) in /var/lib/mysql/mysql/ (replace everything up to and including teh first mysql in that path with your mysql data dir) when the server is stopped with a copy from a fresh install. That will wipe all users in your database though, and might have unforeseen consequences depending on what you had defined before. Backup first though! Walter On Wed, Aug 26, 2009 at 03:33, Joemysql@bluepolka.net wrote: I'm trying to get back to an earlier state where we started mysqld withOUT --skip-grant-tables but the root user had no password. Yes, insecure, but we're in restoration mode here. How do I reset/revert the root password to no password without running with --skip-grant-tables? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: update client
Check out replication. On Sun, Aug 23, 2009 at 09:00, m. zamil mza...@saudi.net.sa wrote: Hello all, due to connection state, I need to keep an updated copy of the database on the client. How can I accomplish this? TIA Mos -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
Re: Query Question
Bill, if you use an order by clause in your query, the limit will pick the first 100K rows in that order. That way you can ensure that all rows will be processed in (wait for it...) order :) Cheers, Walter On Tue, Aug 18, 2009 at 18:44, Bill Arbuckle b...@arbucklellc.com wrote: I am in need of some help for the following: Say I have a table with 1M rows. Users are being added constantly (not deleted) during the queries that I am about to explain. The pk is uid and appid. I need to run queries in increments of 100K rows until reaching the end without duplicating rows in the queries. I am using a select statement with a limit of row_index and row_count. This start row is where my question arises. If I make a query with limit 0,10 then 2 minutes later 10,10 then 2minutes later 30,10 and so on. My question is are new rows added to the end of the table or will they randomly appear in my queries? If they are added to the end of the table, that is fine because I will pick them up in my final pass. I hope this is clear enough. If not, let me know and I will provide more information. Thanks! -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
Re: Replication breakage when Heartbeat Failover occurs
Hi Imran, Have a look at MySQL MMM for Multi-Master Replication failover. The project is currently in refurbishment when ti comes to having a home, but you can start by looking at : http://mysql-mmm.org for information. This project is made for exactly what you want to achieve: Having multiple masters and multiple slaves with automatic failover. Hope this helps! Walter On Wed, Aug 12, 2009 at 09:08, Imran Chaudhry ichaud...@gmail.com wrote: I want to fix a replication issue with a 2-node cluster (one active, one passive) that is using Heartbeat for failover. The nodes are in Master-Master configuration (that is, each is the slave and master of the other). I have several other hosts that are replication slaves from the active node. They connect to MySQL via TCP over an SSH tunnels. When failover occurs, the passive node becomes the active node. However the replication slaves stop replicating. The error from a log on one of the slaves is: Jul 15 07:43:32 host mysqld[1339]: 090715 7:43:32 [Note] Slave I/O thread: conn ected to master 'user@127.0.0.1:3307', replication started in log 'mysql-bin.00 0978' at position 23923243 Jul 15 07:43:32 host mysqld[1339]: 090715 7:43:32 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( serve r_errno=1236) Jul 15 07:43:32 host mysqld[1339]: 090715 7:43:32 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log Jul 15 07:43:32 host mysqld[1339]: 090715 7:43:32 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000978', position 23923243 I do not think this is an SSH tunnel issue. I believe this is because of inconsistent binary log file names and positions between the two nodes. Probably because one of the nodes had been in operation a lot longer than the other. At the moment I have to get replication going by dumping the master databases again, re-import to the slave hosts and bootstrap the slaves. What is the best way to make this consistent and ensure that replication continues smoothly after a failover (and failback) event? Thank you, Imran Chaudhry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org
Re: Indexing? (Warning: relative newbie.)
Hey Tim, all On Wed, Jun 24, 2009 at 10:03 AM, Little, Timothytlit...@thomaspublishing.com wrote: Why, you might ask, index on physmessage_id? Because then the db won't have to do a fetch on items from the table since it's in the INDEX itself, saving any unnecessary reads. FYI: That only holds true for InnoDB, not for MyISAM. cheers, -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Half Hour Sub-query in MySQL vs. 5 Seconds in VFP?
Peter, On Thu, Jun 18, 2009 at 9:27 PM, Peter Brawleypeter.braw...@earthlink.net wrote: For explanation alternatives see The unbearable slowness of IN() at http://localhost/artful/infotree/queries.php. you prolly meant to not post a url pointing at your local copy of your website. This works better for most of us: http://www.artfulsoftware.com/infotree/queries.php ;) Walter -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqld not writing to err-log
It is probably writing to syslog. Try cat /var/log/messages | grep -i mysqld to search for entries made by mysqld. Walter On Tue, Jun 16, 2009 at 11:48 AM, Madan Thapamadan.feedb...@gmail.com wrote: Hi, mysqld is not writing to err-log and i do not see any log generated upon mysql service restart. In my.cnf = [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=16384 r...@server[~]# ll /var/log/mysqld.log -rw-r--r-- 1 mysql root 0 Nov 24 2008 /var/log/mysqld.log r...@server[~]# Please advise what i can look for to fix this issue. -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Trigger and Warning: #1265 Data truncated
Curdate() returns a datetime, which you are pushing into a date field. It is truncating the time part. Just truncate it and you should be fine :) Walter On Fri, Jun 5, 2009 at 5:56 AM, Keith Edmundsk...@midnighthax.com wrote: I'm very new to triggers, so I suspect I've done something naive. When a row is inserted into a table, I want populate a 'date' column with the date 45 days hence. I've created a trigger: CREATE TRIGGER `test`.`setExpiryDate` BEFORE INSERT ON `test`.`mysql_auth` FOR EACH ROW SET NEW.expires = curdate()+interval 45 day It works, doing what I want, but I get the following error: Warning: #1265 Data truncated for column 'expires' at row 1 The table is: CREATE TABLE `mysql_auth` ( `id` int(11) NOT NULL auto_increment, `user` varchar(25) NOT NULL, `password` varchar(32) NOT NULL, `expires` date NOT NULL, `login_failures` int(11) NOT NULL default '0', `last_login_failure` datetime default NULL, PRIMARY KEY (`id`) ) Can someone help me understand what it happening here, and how to fix it? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck, Engineer @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: creating databases in different folders
You might try and hack something together using NTFS juction points. Unadvisable though, and probably unsupported. Walter On Mon, Jun 1, 2009 at 9:00 PM, Foo JH jhfoo...@extracktor.com wrote: Hi all, I'm using MySQL 5.0 on Windows 2003. Problem background: We use the same server for different applications. All the applications share the same server as the database server. Each application uses their own database. In MSSQL we put each database in the corresponding application folder so that the application root folder contains everything (including the database). Now we're trying to do the same for MySQL as well, but I'm not sure how I can specify that a database should be created in a particular directory (and it's almost always not in C:\Program Files\MySQL Server). Can anyone advise? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck, Consultant @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Can a MyISAM DB hold /everything/?
Most commonly, you would store all information (including descriptions in teh database. The amount of data you describe is peanuts for MySQL. Then, you would probably store a path to an image in the database as well. You could then store the images on disk outside the database, or even think about using amazon S3 for that. Takes away your need for administering a file server :) Walter -- Walter Heck, Consultant @ Open Query (http://openquery.com) Affordable Training and ProActive Support for MySQL related technologies Follow our blog at http://openquery.com/blog/ OurDelta: free enhanced builds for MySQL @ http://ourdelta.org On Wed, May 27, 2009 at 10:50 AM, Pete Wilson pete...@yahoo.com wrote: Hi folks -- I am new to MySQL and just laying out what I hope will be just one db that holds all the info for a list of forged or machined metal parts. Let's say there are 10,000 such parts, each with a unique part number. That part number is the primary index. Each part has at least one, and maybe several, accompanying photos. And each part has at least one, and perhaps as many as five, human-language descriptions. These descriptions might be as long as 5,000 characters each. I believe I have the choice of: 1. Storing everything -- photos and descriptions included -- in the database; or 2. Holding some info in the database; and storing photos and descriptions in normal-type disk files apart from the database, with names based on part numbers. So my questions: 1. Which scheme is faster and less resource-hogging in reading, updating, adding, and deleting? 2. I understand there are problems in storing photos in the db. Can one overcome these problems somehow? Thanks! -- Pete -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: FW: GRANT and ticks or no ticks...
Start the server with --skip-grants-table. That will disable logins. Then do delete from mysql.user and restart :) Walter On Tue, May 26, 2009 at 6:05 PM, Daevid Vincent dae...@daevid.com wrote: Now I'm really confused. I just did this: REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user'@'10.10.10.%'; GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; and then I get this: SHOW GRANTS FOR 'user'@'10.10.10.%'; +--- + | Grants for u...@10.10.10.% | +--- + | GRANT USAGE ON *.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret' | | GRANT ALL PRIVILEGES ON `mydb`.* TO 'user'@'10.10.10.%' | +--- + So why mySQL is putting back ticks in there even though I didn't, and more importantly why doesn't the second line say: GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; like the first line says and like I specifically said in my grant statement up above??! -Original Message- From: Daevid Vincent [mailto:dae...@daevid.com] Sent: Tuesday, May 26, 2009 4:49 PM To: 'mysql@lists.mysql.com' Subject: GRANT and ticks or no ticks... Wondering which of these will work or not? (no quotes) GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (backticks) GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; (single quotes) GRANT ALL PRIVILEGES ON 'mydb'.'mytable' TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD 'secret'; All the examples seem to show no quotes: http://dev.mysql.com/doc/refman/5.0/en/privileges-provided.html But our grant table has a mixture of all three (legacy inheritance I'm trying to clean up) mysql -uroot -p -Bse SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user | mysql -uroot -p -Bs | sed 's/$/;/g' Also, is there a way to just wipe all the grants so that I can add them one at a time and get rid of the cruft? Obviously this has a risk of blowing away the root user you're adding grants with. Does this also mean that if I ungrant my current user, does that change take effect immediatly and I won't be able to grant anymore? Or as long as I stay logged into the mysql shell I am safe? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- Walter Heck -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Problem setting up slow logging in my,ini file
Try putting in a full existing pathname the server has write access to as opposed to just a file name. Walter Heck On Sun, May 17, 2009 at 12:13 PM, mos mo...@fastmail.fm wrote: I'm having a problem defining slow logging file in my.ini (Windows XP). I'm using MySQL 5.1.30. In the MySQL reference manual it says: As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be removed (along with the log_slow_queries system variable) in MySQL 7.0. Instead, use the --slow_query_log option to enable the slow query log and the --slow_query_log_file=file_name option to set the slow query log file name. So my.ini has: [mysqld] general_log=1 log-output=FILE general_log_file=LOG.TXT slow_query_log=1 slow_query_log_file=SLOWLOG.TXT After I restart MySQL, the variables have: Variable_name Value --- -- log ON log_bin OFF log_output FILE log_queries_not_using_indexes OFF log_slow_queries ON log_warnings 1 slow_query_log ON slow_query_log_file OFF sql_log_bin ON sql_log_off OFF sql_log_update ON So why is the variable slow_query_log_file set to OFF because it is not boolean and should be a file name? Why isn't it set to the file name SLOWLOG.TXT? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to copy an statement in Mysql console
Blatantly assuming you are using PuTTy because of your question: click-and-drag the mouse to select text. Then, press Shift+Ctrl+C to copy to the clipboard. Press Shift+Ins to insert text back into the console at the current carot-position. Hope that helps.. Walter Heck On Thu, May 14, 2009 at 5:41 PM, jean claude babin babi...@gmail.com wrote: Hello, I'm pretty new in MySql. I would like to know how you can copy a statement like mysql INSERT INTO customers ( firstname, surname, title, phone) values ( 'Jhon', 'Campbell', 'Mr', 345 987 5500) in the MySql console in order to avoid typing it each time you want to fill a new record. I tried to right click my mouse,it doesn't select what I need to highlight. Please,any advice is welcome. JC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Joining memory tables is very very slow!
Memory tables use hash indexes by default instead of b-tree. Try changing the index, that should help significantly. regards, Walter On Tue, Mar 31, 2009 at 6:47 PM, mos mo...@fastmail.fm wrote: I'm using MySQL 5.1.30 and have several memory tables with indexes on the appropriate columns. When I try and join 2 particular memory tables together to get 5k rows, it takes 90 seconds. This is incredibly slow considering table1 has 11k rows and table2 has 5k rows. A table join like this should take 10 ms. An explain shows it is not using and index for the table but Extra has Using where;Using join buffer. I can try and use Force Index(..) and it still will not use the index. If I use the MyISAM table instead of that one particular memory table the query takes 800ms which is reasonably fast. Is there a way to force it not to use the join buffer? Has anyone else noticed the slow memory table joins in 5.1? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Fwd: A problem relative ibdata1
forgot the list, sorry :) Walter Heck -- Forwarded message -- From: Walter Heck - OlinData.com li...@olindata.com Date: Thu, Mar 26, 2009 at 2:09 PM Subject: Re: A problem relative ibdata1 To: Cc: Riccardo Michele Filippone ethern...@gmail.com Riccardo, if you're ibdata1 file is growing fast, it means you are inserting lots of data into it. It doesn't magically grow out for no reason :) We can't look into your application, so you will have to monitor it yourself. Try enabling the general query log for 1 minute or so and see what kind of queries are running. You will most likely find something you are not expecting. What kind of application are you running MySQL under? If it is a website, is it custombuilt or an off-the-shelf product? Could it be some kind of logging procedure that is going banana's? We need more info to be able to answer your question :) good luck! Walter Heck On Thu, Mar 26, 2009 at 1:29 PM, Claudio Nanni claudio.na...@gmail.com wrote: Hi Riccardo, I don't think you should need any other storage engine if you need foreign keys. InnoDB is by far the most used, standard, transactional, foreign key-supporting MySQL storage engine. No other valid option comes to my mind now. But please share your needs and let's see if I am wrong. Ciao Claudio 2009/3/26 Riccardo Michele Filippone ethern...@gmail.com Well, I think it's abnormal because after a few days I can have a ibdata1 of 7-8 GB!!! I don't think it's normal because, if ibdata1 continue is growth... I must be purchase a datacente :P Now I try to retrive a charts of queries... however do you know if there is an engine that support/manage foreign key? I use innodb for this reason.. but the size of ibdata1 is a problem :'( Thanks for ur reply Il giorno 26/mar/09, alle ore 12:30, Claudio Nanni ha scritto: You can't! it is part of the datafiles of InnoDB storage engine! and It contains important data like the information schema. So I would rather ask you, is it abnormally growing or is it just your feeling? You should be more precise to have good answers, for instance how much megabytes per minute is it growing? How many inserts do you have on the tables per second/minute/hour? Ciao! Claudio 2009/3/26 Riccardo Michele Filippone ethern...@gmail.com Hello! First of all sorry for my terrible english. Well I've a big problem with ibdata1, this damn file increase its size constantly. I tryed to use innodb_file_per_table... but: - MySQL create a lot of ibd files for all DB (correct) - ibdata1 is however created and increase its size... how can I prevent the creation of this file (ibdata1)? Thanks for your future suggestion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Replication Issues
Most likely something is wrong in your AMSCD2-relay-bin.index file. Check this out: http://forums.mysql.com/read.php?26,9390,242387#msg-242387 Walter Heck On Thu, Mar 26, 2009 at 10:02 PM, Dirk Bremer dirk.bre...@nisc.coop wrote: Could not find first log file name in binary log index file -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: MySQL server has gone away...
Are you using large blobs by any chance? when max_allowed_packet (google it ;) ) is set too small, the server will also terminate the connection with this error message. Remember to set it correctly at the server and at the client side. One of the better explanations by monty is found here: http://bugs.mysql.com/bug.php?id=2110 regards, Walter Heck On Tue, Mar 24, 2009 at 8:12 PM, Jesse j...@msdlg.com wrote: I thought that the # of connections might be a problem at some point too. The last time this happened, there were a lot of connections. Right now, there are 19 connections. How do I tell what the TTL is? I'm not too familiar with perfmon. How do I set it up to watch MySQL connections? Thanks, Jesse - Original Message - From: Gary Smith g...@primeexalia.com To: Jesse j...@msdlg.com; mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 2:55 PM Subject: Re: MySQL server has gone away... Netstat -an. How many 3306 entries do you have in there. What's the TTL on them. Once the pool issues the bad connection multiple issuances of the same connection will probably result in the same error.if yoi birst to 20 connections then drop to 10 for the next 24 hours then burst to 11 that 11th might have been dropped. Next asp request gets 11. Next one gets 11. And so on until the active requests drop to the point where the connections are still active. Does this make sense? It doesn't round robin them (at least to the best of my knowledge) so some may go stayle. When testing the odbc connection some time ago I had connections stay in the pool for a day whereas my timeout was 120 minutes. Anyway. Watch the connection count with the windows perfmon and see if there is a corrolation. Sent via BlackBerry by ATT -Original Message- From: Jesse j...@msdlg.com Date: Tue, 24 Mar 2009 14:47:30 To: Jessej...@msdlg.com; mysql@lists.mysql.com Subject: Re: MySQL server has gone away... An update on this issue. It just happened again, and the first error was: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]Lost connection to MySQL server during que Then, after that, I got a BUNCH of [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away errors. I'm pretty sure that the 2nd errors were caused by the first error. Again, there is nothing strange in the IIS logs, or Windows Event log The database server is on the same machine as the web server, so the network should not be involved here. Why would it suddenly loose connection? Jesse - Original Message - From: Jesse j...@msdlg.com To: mysql@lists.mysql.com Sent: Tuesday, March 24, 2009 11:41 AM Subject: MySQL server has gone away... We are running MySQL Server version 5.0.67-community-nt-log on a WS03 server. It seems like every once in a while (sometimes once or twice a week, sometimes more), something will happen, then I'll start getting a lot of errors: [MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt-log]MySQL server has gone away This is driving me absolutely nuts. I don't see any errors in the Event Viewer, or the MySQL error log. Does anyone know of any reasons that this might happen? Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub...@msdlg.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=g...@primeexalia.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=li...@olindata.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org