Jump to content

Igor

Administrators
 View Profile  See their activity

  • Posts

    13612

  • Joined

  • Last visited

 Content Type 

Posts posted by Igor

    Forum upgrade

    in Off-topic

    Posted

    You are hidden from here if you mean that? This works as expected, but you see yourself of course.

     

    Hints has to be rewritten or perhaps only enabled back. Since search work decently, we might not need to expose alternative that much, only as a optional, not as a "must use".

    0

    Forum upgrade

    in Off-topic

    Posted

    5 hours ago, lanefu said:

    that'll work too!


    It worked for some time ... :) But the actual problem was that cron job (which also handle purging of this table) was running with too low interval.  Well, this is now sorted out.

    0

    Forum upgrade

    in Off-topic

    Posted · Edited by Igor
    Add super slow mysql command

    1 hour ago, zador.blood.stained said:

     

    I think web server and database connection limits need to be checked first since for me ofter connection hangs for a while or even times out.

     

     

    Upgrade to 8 core and 8G memory seems to provide no change at all.

     

    I suspect problem with mySQL since when I click "online users", this happens:

    Spoiler 
    

  PID USER      PRI  NI  VIRT   RES   SHR S CPU% MEM%   TIME+  Command
 1103 mysql      20   0 2785M  177M 11036 S 114.  9.5  4:35.10 /usr/sbin/mysqld 
 4347 mysql      20   0 2785M  177M 11036 R 99.6  9.5  0:25.90 /usr/sbin/mysqld

     

     

    my.conf

    Spoiler 
    
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
# 
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
ft_min_word_len=3

#forum *
interactive_timeout=30
wait_timeout=30

#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 256K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover         = BACKUP
max_connections        = 200
#table_cache            = 64
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 1M
query_cache_size        = 16M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file        = /var/log/mysql/mysql.log
#general_log             = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#slow_query_log_file = /var/log/mysql/mysql-slow.log
#slow_query_log      = 1
#long_query_time = 2
#log_queries_not_using_indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M

     


    With this hardware it should be as smooth as this.


    Edit:
     

    This command is super slow query_time: 11.154960:  

     

    SELECT count(*) FROM `armcore_sessions` AS `core_sessions` WHERE ( core_sessions.id IN(SELECT MAX(id) FROM `armcore_sessions` AS `s` WHERE s.running_time>1488722103 AND s.login_type!=3 GROUP BY `member_id`) OR ( core_sessions.member_id IS NULL AND core_sessions.login_type != 3 AND core_sessions.running_time > 1488722103) )

    0

    HDMI dimming to black

    in Allwinner sunxi

    Posted

    Booting process is set to serial console and HDMI screen by default. Some kernels doesn't understand that and they default it to serial console ... you can force this by adding 

    console=display 

    to /boot/armbianEnv.txt

     

    Random HDMI blanking can be due to bad power supply, cables or similar.

     

    Edit:

    Also try forcing display mode with h3-disp utility.

    0
×
×
  • Create New...

Important Information

Terms of Use - Privacy Policy - Guidelines

  I accept