Search:

Type: Posts; User: bit

Page 1 of 20 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    yeah, always backup :)
  2. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    tnx Rob.

    Al, can you confirm that on OR 2.5.8.? Tnx
  3. Re: Send notification cron Fatal error: Allowed memory size of 33554432 bytes exhaus

    yeah, tnx, what I wont to ask is there any other table involved, or everything is only in that table. I know that for listings there are many tables involved, thats why I asked which table(s) holds...
  4. Re: Send notification cron Fatal error: Allowed memory size of 33554432 bytes exhaus

    Tnx Sanding, and pls tell me which table holds saved searches. Id like to empty it, or delete some old saved searches, how to do that?

    Thank you
  5. Re: Send notification cron Fatal error: Allowed memory size of 33554432 bytes exhaus

    yeah, I know that. but how much to increase and to not harm server performance? I have set to 64 now, let see how will perform tonight. I have great sysadmin who is doing tuning of my server this...
  6. Re: Send notification cron Fatal error: Allowed memory size of 33554432 bytes exhaus

    PLS, can anyone give me advice, what table should I empty to remove all saved searches?
  7. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    got your email, Will check and test.

    Regarding what I sai, If I remember good (it was very long ago) it was your first try to make chained selects, and it wasnt addon, it was modified OR...
  8. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    CSA addon update: Id like to inform everyone subscribed to this thread that CSA addon is in development phase. Our plan is to make it work with max 5 chained fields. If you think that there is need...
  9. Send notification cron Fatal error: Allowed memory size of 33554432 bytes exhausted

    When my cron job triggers send notifications function I get this kind of error by email:

    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 86560 bytes) in...
  10. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    apology accepted!

    If you have a demo of addon for test, yes Id like to test it on my test site. Maybe new improved version could satisfy my need, so no need for new addon development.

    I still...
  11. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    Sounds a bit like my listingeditor addon that you, Bit, bought from me and never paid for.

    that is 100% untruth! I never bought your addon! How could I bought without of payment? I remember I have...
  12. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    hmm, I understand why you think so, but lets wait to finish development. There will be NO CORE FILE CHANGES for this addon. You will only need to add (insert) js in template, and you can do that in...
  13. Replies
    19
    Views
    13,725

    Re: Open Realty 3 in progress

    I like your seachresults template. What addon you use for sorting, and selecting number of listings per page? Can I buy just that from you? I already have template, so just like to add that...
  14. Re: {check_featured} to show only if the listing is featured

    just few things in the world are impossible, and I don't believe that this one you stated is one of them : ) I think that better answer would be "I dont know how" : ) but Im almost sure its possible,...
  15. Poll: Re: Advanced chained select with autosuggestions in backend and frontned

    thanx pb for a hint. Well, my developer thinks it can be done without of core files change. maybe we are thinking about different approaches. let see when finished. yes, at the moment I have few...
  16. Re: {check_featured} to show only if the listing is featured

    hint for NEON: on listing detail page in footer you have:

    IZDVOJENI OGLASI
    {addon_multfeat_show1}

    that addon tag dont work there.
  17. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    tnx, I sent you PM
  18. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    yeah, tnx, I understand from your first post I need to use my table prefix. I used SELECT COUNT (*) FROM default_en_listingsdbelements WHERE listingsdbelements_field_value = '';

    and got 67000.
    ...
  19. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    I FIGURED OUT, I CAN USE SELECT COUNT (*)

    It outputs me 67000 rows (in one install) so probably about 250.000 rows in all 4 installs.
  20. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    dear Al,

    thank you for this great hints.

    When I run from phpmyadmin SELECT * FROM $config[table_prefix]listingsdbelements WHERE listingsdbelements_field_value = ''; I get reulsts, but how can I...
  21. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    forget to give my mysql variables from phpmyadmin:


    Server variables and settings
    Variable Session value / Global value
    auto increment increment 1
    auto increment offset 1
    automatic sp...
  22. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    thank you guys. Yes pb, I downloaded both script tuner and tuning primer. Did some optimization. Now I will wait for few days and see report again.

    However, when I run tuning primer, I am getting...
  23. Re: Need to change template charset, problem with characters

    As I said, problem is solved, can be locked.

    p.a. When find/replace use this codes in mysql dump file: http://www.thesauruslex.com/typo/eng/enghtml.htm
  24. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    thank you greeng,

    here is what it says:


    >> MySQLTuner 1.0.1 - Major Hayden <major@mhtx.net>
    >> Bug reports, feature requests, and downloads at http://mysqltuner.com/
    >> Run with...
  25. Replies
    20
    Views
    16,511

    Re: MYSQL configuration for best OR performance

    tnx sandking for reply.

    I understand that many variables are important. While I was searching on net for some advices for optimizing mysql, I found a lot of post related to other products...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4